$query = DB::query("SELECT i.itemid,i.subject,i.address,i.tel,m.mapapimark FROM ".DB::table('shopitems')." i LEFT JOIN ".DB::table('shopmessage')." m ON i.itemid=m.itemid WHERE i.catid='".$catid."' AND m.mapapimark!='' AND i.grade>2 ORDER BY i.displayorder DESC LIMIT 10");