SELECT count(e.id) AS orderkey
                     
                     
                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
                     LEFT OUTER JOIN serendipity_entryproperties ep_cache_extended
                                                  ON (e.id = ep_cache_extended.entryid AND ep_cache_extended.property = 'ep_cache_extended')
 LEFT OUTER JOIN serendipity_entryproperties ep_cache_body
                                                  ON (e.id = ep_cache_body.entryid AND ep_cache_body.property = 'ep_cache_body')
 LEFT OUTER JOIN serendipity_entryproperties ep_access
                                              ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')INNER JOIN serendipity_entrytags AS entrytags ON (e.id = entrytags.entryid) INNER JOIN serendipity_entrytags AS entrytags ON e.id = entrytags.entryid 
                     WHERE e.timestamp >= 1335844800 AND e.timestamp <= 1338523199 AND isdraft = 'false' AND e.timestamp <= 1337562000 AND  (ep_access.property IS NULL OR ep_access.value = 'public')  AND entrytags.tag = 'livecam'   AND (entrytags.tag IN ('livecam','P2.html')) 
                     
            ORDER BY orderkey DESC, timestamp DESC