select p.id, p.itemcode, p.category_id,p.subcate_id, p.color_id,p.nameTh, p.nameEn, p.titleTh, p.titleEn, p.detailTh, p.detailEn, p.lastupdate, p.online, p.home, p.bestsale, p.skinvar, p.yeeho_id from products p left join category c on p.category_id=c.catid where p.id > 0 and p.online='y' and p.category_id=54 order by p.sorter asc limit 20,20