# Sat Jul  5 09:10:29 2008
# Query_time: 6  Lock_time: 0  Rows_sent: 1  Rows_examined: 45
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-07-05 15:10' ) AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2008-07-05 15:10' ) 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

# Sat Jul  5 09:29:05 2008
# Query_time: 4  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use theclari_rugProd;
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '16512efa98953789cdee760c5fd30fe5','1215271741','','0','1','0' )