FOOTISTA＆WCCF買取

SELECT `cards_new`.* , series.ordering_id as colororder , `kaitoriprices`.*, `cards_new`.comment AS cards_new_comment, `kaitoriprices`.comment AS kaitori_comment FROM `kaitoriprices` left join `cards_new` on(kaitoriprices.`card_ID`=`id` and price>0) , series Where series.id = `cards_new`.series AND `cards_new`.`type` =119 AND `cards_new`.kind!='z' AND `cards_new`.kind!='z' Order by series.ordering_id, series, shape ,orderid desc, name Limit 300, 300