# Fri Jun 27 00:25:41 2008
# Query_time: 3  Lock_time: 0  Rows_sent: 1  Rows_examined: 44
use theclari_rugProd;
SELECT a.*, COUNT( b.id ) AS numitems, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug FROM jos_categories AS a LEFT JOIN jos_content AS b ON b.catid = a.id AND b.state = 1 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2008-06-27 06:25' ) AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2008-06-27 06:25' ) AND b.access <= 0 WHERE a.section = 10 AND a.published = 1 AND a.access <= 0 GROUP BY a.id HAVING numitems > 0 ORDER BY a.ordering

# Fri Jun 27 00:53:05 2008
# Query_time: 2  Lock_time: 0  Rows_sent: 18  Rows_examined: 282
use theclari_clarionReport;
SELECT DISTINCT DAYOFMONTH(post_date)
		FROM wp_posts WHERE MONTH(post_date) = '06'
		AND YEAR(post_date) = '2008'
		AND post_type = 'post' AND post_status = 'publish'
		AND post_date < '2008-06-26 23:53:03'

# Fri Jun 27 00:53:10 2008
# Query_time: 5  Lock_time: 0  Rows_sent: 20  Rows_examined: 264
use theclari_clarionReport;
SELECT post_title, DAYOFMONTH(post_date) as dom FROM wp_posts WHERE YEAR(post_date) = '2008' AND MONTH(post_date) = '06' AND post_date < '2008-06-26 23:53:05' AND post_type = 'post' AND post_status = 'publish'