INSERT INTO csg_config (name,value,authorid) values ('serendipity_event_weblogping:6cddc7e071ee81f5d59d7f41f82c3c61/manual_services', '', '0')

INSERT INTO csg_config (name,value,authorid) values ('serendipity_event_adduser:dfa6fb03b0a73625eefd1335fc58cf28/registered_only', '', '0')

INSERT INTO csg_config (name,value,authorid) values ('serendipity_event_adduser:dfa6fb03b0a73625eefd1335fc58cf28/true_identities', '1', '0')

INSERT INTO csg_config (name,value,authorid) values ('serendipity_event_staticpage:24cb82d51815e31468e1b36d300941f6/db_built', '', '0')

INSERT INTO csg_config (name,value,authorid) values ('serendipity_event_staticpage:24cb82d51815e31468e1b36d300941f6/db_built', '7', '0')

SELECT 
                    

                    e.id,
                    e.title,
                    e.timestamp,
                    e.comments,
                    e.exflag,
                    e.authorid,
                    e.trackbacks,
                    e.isdraft,
                    e.allow_comments,
                    e.last_modified,

                    a.realname AS author,
                    a.username AS loginname,
                    a.email
                     , e.body, e.extended
                     
                FROM
                    csg_entries AS e
                    LEFT JOIN csg_authors a
                        ON e.authorid = a.authorid
                    LEFT JOIN csg_entrycat ec
                        ON e.id = ec.entryid
                    LEFT JOIN csg_category c
                        ON ec.categoryid = c.categoryid
                     LEFT JOIN csg_authorgroups AS acl_a
                                   ON acl_a.authorid = 0
                            LEFT JOIN csg_access AS acl_acc
                                   ON (    acl_acc.artifact_mode = 'read'
                                       AND acl_acc.artifact_type = 'category'
                                       AND acl_acc.artifact_id   = c.categoryid
                                      )
                    WHERE isdraft = 'false' AND e.timestamp <= 1732257000 AND     (
                                 c.categoryid IS NULL
                                 OR ( acl_acc.groupid = 0)
                                 OR ( acl_acc.artifact_id IS NULL
                                      
                                    )
                               )
                     GROUP BY e.id
                     
                     ORDER BY timestamp DESC
                      LIMIT 15