INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_contentrewrite:3c7f8a202733dfc511277d32ff62e2df/fromstring', '', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_contentrewrite:3c7f8a202733dfc511277d32ff62e2df/tostring', '', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_contentrewrite:3c7f8a202733dfc511277d32ff62e2df/fromstring', 'from', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_contentrewrite:3c7f8a202733dfc511277d32ff62e2df/tostring', 'to', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_multilingual:7f3f032e369dd30052248b058d212302/db_built', '', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_multilingual:7f3f032e369dd30052248b058d212302/db_built', '2', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_weblogping:ff56993d6c7738f1efdd31052b46e24e/manual_services', '', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_downloadmanager:ec570e5c06c4ad6e91b9938bd040f467/chg2archivespath', '', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_downloadmanager:ec570e5c06c4ad6e91b9938bd040f467/absincomingpath', '/home/www/web152/web/archives/.dlm/ftpin', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_downloadmanager:ec570e5c06c4ad6e91b9938bd040f467/chg2archivespath', '', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_downloadmanager:ec570e5c06c4ad6e91b9938bd040f467/absdownloadspath', '/home/www/web152/web/archives/.dlm/files', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_statistics:7ade9482a2f1cc4ce66294084b60eca2/ext_vis_stat', 'no', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_loginform:9362926905316afd72770dd287f32555/logout_url', '', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_adduser:64242b2c69650ba8851ce3224d32b137/registered_only', '', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_adduser:64242b2c69650ba8851ce3224d32b137/true_identities', '1', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_entryproperties:3e9a7bdbb905a9cc26a55dfb29577906/use_groups', 'false', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_entryproperties:3e9a7bdbb905a9cc26a55dfb29577906/use_users', 'false', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_entryproperties:3e9a7bdbb905a9cc26a55dfb29577906/use_ext_joins', 'true', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_trackback:561c705dd3c87de169f48da8e822280f/db_upgrade', '2', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_microformats:70b1e55df684255bb5511fa8b7388b5a/subnode', '', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_microformats:70b1e55df684255bb5511fa8b7388b5a/timezone', 'Z', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_usergallery:1fa088baa1a8f804ff68a2d11cb0c98b/subpage', 'gallery', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_usergallery:1fa088baa1a8f804ff68a2d11cb0c98b/permalink', '/index.php?/pages/gallery.html', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_contactform:7e51821694c9e29de7ca83b58fc6a84e/pagetitle', 'Contact Form', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_contactform:7e51821694c9e29de7ca83b58fc6a84e/permalink', '/index.php?/pages/contactform.html', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_staticpage:e40590f4e09f66b09682a3d4e918b1a8/db_built', '', '0')

INSERT INTO serendipity_config (name,value,authorid) values ('serendipity_event_staticpage:e40590f4e09f66b09682a3d4e918b1a8/db_built', '7', '0')

SELECT 
                    ep_sticky.value AS orderkey,

                    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
                    serendipity_entries AS e
                    LEFT JOIN serendipity_authors a
                        ON e.authorid = a.authorid
                    LEFT JOIN serendipity_entrycat ec
                        ON e.id = ec.entryid
                    LEFT JOIN serendipity_category c
                        ON ec.categoryid = c.categoryid
                    INNER JOIN serendipity_entrytags AS entrytags ON (e.id = entrytags.entryid)  LEFT OUTER JOIN serendipity_entryproperties ep_access
                                              ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
 LEFT JOIN serendipity_entryproperties ep_sticky
                                            ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky') LEFT JOIN serendipity_authorgroups AS acl_a
                                   ON acl_a.authorid = 0
                            LEFT JOIN serendipity_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 <= 1545021900 AND entrytags.tag =  'blog'   AND  (ep_access.property IS NULL OR ep_access.value = 'public')  AND     (
                                 c.categoryid IS NULL
                                 OR ( acl_acc.groupid = 0)
                                 OR ( acl_acc.artifact_id IS NULL
                                      
                                    )
                               )
                     GROUP BY e.id
                     
                     ORDER BY orderkey DESC, timestamp DESC
                      LIMIT 15