# Wed Oct 15 13:30:08 2008
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use theclari_rugProd;
SELECT value FROM jos_jomcomment_config WHERE name='all'

# Wed Oct 15 13:30:28 2008
# Query_time: 17  Lock_time: 5  Rows_sent: 0  Rows_examined: 0
use theclari_rugProd;
SELECT a.*, b.created_by FROM jos_jomcomment AS a, jos_content AS b
 WHERE a.`contentid`='3'
 AND(a.`option`='com_content' OR a.`option`='com_myblog')
 AND a.`published`='1'
 AND b.`id`=a.`contentid`  ORDER BY date DESC, id DESC