# Tue Jul  8 15:54:55 2008
# Query_time: 2  Lock_time: 0  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`='49'
 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