SELECT A.*, B.picture_item_id, B.picture_item_name
FROM se_tm_category_items A
LEFT OUTER JOIN se_tm_pictures_items B ON A.category_item_id = B.category_item_id AND B.picture_item_type = 1
WHERE A.category_id = 2 AND A.category_item_online = 1 ORDER BY A.category_item_id DESC
LIMIT 0, 12 |