jeremy_c

# User@Host: lifewit_lwc2[lifewit_lwc2] @ localhost []
# Query_time: 3  Lock_time: 0  Rows_sent: 9  Rows_examined: 9376

SELECT     
  c.com_id AS comment_id,     
  c.com_itemid AS post_id,     
  c.com_created AS created,     
  c.com_text AS body,     
  c.com_uid AS uid,     
  p.title AS title,     
  p.perm_title AS perm_title, 
  p.publish_date AS publish_date,     
  p.cat_id AS cat_id 
FROM     
  xoops_xoopscomments AS c,     
  xoops_weblog_post AS p 
WHERE     
  c.com_itemid = p.post_id     
  AND c.com_modid = 19     
  AND p.weblog_id = 30       
ORDER BY     
  c.com_created DESC 
LIMIT 9;