総合トップ
>> 戦国大戦TCG>> 戦国大戦TCGシングルカード買取
|
|
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` = 164 AND `cards_new`.kind!='z' AND `cards_new`.kind!='z' Order by series.ordering_id, series, shape ,orderid desc, name Limit 0, 300