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, p.dsoftware, p.dfirmware, p.dbrochure, p.dmanual from products p left join category c on p.category_id=c.catid where p.id > 0 and p.id=27 order by p.sorter asc limit 0,20