SQL�����s��:
SELECT md.md_id, cntry.cntry_id, cntry.cntry_name, cntry.cntry_url,
subcntry.subcntry_id, subcntry.subcntry_name, subcntry.subcntry_url,
class.class_id, class.class_name, subclass.subclass_id, subclass.subclass_name,
mdtype.mdtype_name, submdtype.submdtype_name, md.md_name_one, md.md_name_two, md.md_name_thr,
mdlmaker.mdlmaker_name, mdlmaker.mdlmaker_url, md.scale_id, scale.scale_com,
md.rare_id, rare.rare_star, rare.rare_com, md.md_sale_flg, md.md_sale_date,
md.md_fprice, md.md_tprice, md.md_com, md.md_img_url, md.pack_unit
FROM (((((((((md LEFT JOIN mdlmaker ON md.mdlmaker_id = mdlmaker.mdlmaker_id)
LEFT JOIN mdtype ON md.mdtype_id = mdtype.mdtype_id)
LEFT JOIN rare ON md.rare_id = rare.rare_id) LEFT JOIN cntry ON md.cntry_id = cntry.cntry_id)
LEFT JOIN subcntry ON (md.subcntry_id = subcntry.subcntry_id) AND (md.cntry_id = subcntry.cntry_id))
LEFT JOIN class ON md.class_id = class.class_id)
LEFT JOIN subclass ON (md.subclass_id = subclass.subclass_id) AND (md.class_id = subclass.class_id))
LEFT JOIN submdtype ON (md.submdtype_id = submdtype.submdtype_id) AND (md.mdtype_id = submdtype.mdtype_id))
LEFT JOIN zaiko ON md.md_id = zaiko.md_id)
LEFT JOIN scale ON md.scale_id = scale.scale_id
WHERE ( md.md_sale_flg < '7')
AND md.cntry_id = 357 AND md.mdtype_id = and md.subcntry_id = 011 order by md.md_name_one, md.md_name_two, md.md_name_thr asc
limit 0,28
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/valuetoys/valuetoys01/www/model/MySQL.php on line 50
SQL�����s��:
SELECT md.md_id, cntry.cntry_id, cntry.cntry_name, cntry.cntry_url,
subcntry.subcntry_id, subcntry.subcntry_name, subcntry.subcntry_url,
class.class_id, class.class_name, subclass.subclass_id, subclass.subclass_name,
mdtype.mdtype_name, submdtype.submdtype_name, md.md_name_one, md.md_name_two, md.md_name_thr,
mdlmaker.mdlmaker_name, mdlmaker.mdlmaker_url, md.scale_id, scale.scale_com,
md.rare_id, rare.rare_star, rare.rare_com, md.md_sale_flg, md.md_sale_date,
md.md_fprice, md.md_tprice, md.md_com, md.md_img_url, md.pack_unit
FROM (((((((((md LEFT JOIN mdlmaker ON md.mdlmaker_id = mdlmaker.mdlmaker_id)
LEFT JOIN mdtype ON md.mdtype_id = mdtype.mdtype_id)
LEFT JOIN rare ON md.rare_id = rare.rare_id) LEFT JOIN cntry ON md.cntry_id = cntry.cntry_id)
LEFT JOIN subcntry ON (md.subcntry_id = subcntry.subcntry_id) AND (md.cntry_id = subcntry.cntry_id))
LEFT JOIN class ON md.class_id = class.class_id)
LEFT JOIN subclass ON (md.subclass_id = subclass.subclass_id) AND (md.class_id = subclass.class_id))
LEFT JOIN submdtype ON (md.submdtype_id = submdtype.submdtype_id) AND (md.mdtype_id = submdtype.mdtype_id))
LEFT JOIN zaiko ON md.md_id = zaiko.md_id)
LEFT JOIN scale ON md.scale_id = scale.scale_id
WHERE ( md.md_sale_flg < '7')
AND md.cntry_id = 357 AND md.mdtype_id = and md.subcntry_id = 011
Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/valuetoys/valuetoys01/www/model/modellist.php on line 24
SQL�����s��:
SELECT md.md_id, cntry.cntry_id, cntry.cntry_name, cntry.cntry_url,
subcntry.subcntry_id, subcntry.subcntry_name, subcntry.subcntry_url,
class.class_id, class.class_name, subclass.subclass_id, subclass.subclass_name,
mdtype.mdtype_name, submdtype.submdtype_name, md.md_name_one, md.md_name_two, md.md_name_thr,
mdlmaker.mdlmaker_name, mdlmaker.mdlmaker_url, md.scale_id, scale.scale_com,
md.rare_id, rare.rare_star, rare.rare_com, md.md_sale_flg, md.md_sale_date,
md.md_fprice, md.md_tprice, md.md_com, md.md_img_url, md.pack_unit
FROM (((((((((md LEFT JOIN mdlmaker ON md.mdlmaker_id = mdlmaker.mdlmaker_id)
LEFT JOIN mdtype ON md.mdtype_id = mdtype.mdtype_id)
LEFT JOIN rare ON md.rare_id = rare.rare_id) LEFT JOIN cntry ON md.cntry_id = cntry.cntry_id)
LEFT JOIN subcntry ON (md.subcntry_id = subcntry.subcntry_id) AND (md.cntry_id = subcntry.cntry_id))
LEFT JOIN class ON md.class_id = class.class_id)
LEFT JOIN subclass ON (md.subclass_id = subclass.subclass_id) AND (md.class_id = subclass.class_id))
LEFT JOIN submdtype ON (md.submdtype_id = submdtype.submdtype_id) AND (md.mdtype_id = submdtype.mdtype_id))
LEFT JOIN zaiko ON md.md_id = zaiko.md_id)
LEFT JOIN scale ON md.scale_id = scale.scale_id
WHERE ( md.md_sale_flg < '7')
AND md.cntry_id = 357 AND md.mdtype_id = and md.subcntry_id = 011 order by md.md_name_one, md.md_name_two, md.md_name_thr asc
limit 0,28
|
