SELECT ox_pics.*, username FROM ox_pics LEFT OUTER JOIN accounts ON ox_pics.account_id = accounts.id WHERE 1=1 AND pic_id IN ( SELECT pic_id FROM ox_pics_catepics WHERE cate_id = '{B7F0B9B1-CDBD-45D1-A227-AE66FF7A2F7C}' ) AND state_visible = 'visible' ORDER BY date_upload DESC