SELECT p.id, p.postid, p.date , p.sell_type, p.hot, p.lastupdate, p.author, p.reply, p.type, p.subject, p.category, p.subcategory, p.price, p.stick, p.status, p.comment_rating_count, p.comment_count, p.comment_rating_mark, p.comment_count, p.images, p.image_width, p.image_height, p.location, m.mark, m.positivemark, m.name, m.status as mstatus, m.type as mtype, UNIX_TIMESTAMP(m.service_end_date) AS service_end_time, m.avatar, p.location FROM phomuaban.pmb249_postsall p JOIN phomuaban.pmb249_postsall_hot ph ON p.id=ph.postid LEFT JOIN phomuaban_user.pmb249_members m ON p.author=m.id WHERE 1=1 AND (ph.stick > 0 OR ph.hot > 0) AND p.category=? AND p.subcategory=? AND p.location=? AND p.type=0 AND p.status=1 ORDER BY p.stick DESC, p.hot DESC, p.lastupdate DESC
SELECT p.id, p.postid, p.date , p.sell_type, p.hot, p.lastupdate, p.author, p.reply, p.type, p.subject, p.category, p.subcategory, p.price, p.stick, p.status, p.comment_rating_count, p.comment_count, p.comment_rating_mark, p.comment_count, p.images, p.image_width, p.image_height, p.location, m.mark, m.positivemark, m.name, m.status as mstatus, m.type as mtype, UNIX_TIMESTAMP(m.service_end_date) AS service_end_time, m.avatar, p.location FROM phomuaban.pmb249_postsall p LEFT JOIN phomuaban_user.pmb249_members m ON p.author=m.id WHERE 1=1 AND (p.lastupdate > ?) AND p.category=? AND p.subcategory=? AND p.location=? AND p.type=0 AND p.status=1 ORDER BY p.lastupdate DESC LIMIT 0,20
