00000select isbuy,ext_table from mallbuilder_product_cat where catid='101410'
11111SHOW TABLES LIKE 'mallbuilder_defind_4'
22222select * from mallbuilder_defind_4 where product_id = '6321'
33333select * from mallbuilder_property where type_id = '4' order by displayorder
44444select id,name from mallbuilder_property_value where property_id = '7' order by displayorder
44444select id,name from mallbuilder_property_value where property_id = '6' order by displayorder
44444select id,name from mallbuilder_property_value where property_id = '25' order by displayorder
44444select id,name from mallbuilder_property_value where property_id = '26' order by displayorder
44444select id,name from mallbuilder_property_value where property_id = '93' order by displayorder
44444select id,name from mallbuilder_property_value where property_id = '27' order by displayorder
44444select id,name from mallbuilder_property_value where property_id = '90' order by displayorder
44444select id,name from mallbuilder_property_value where property_id = '92' order by displayorder
44444select id,name from mallbuilder_property_value where property_id = '89' order by displayorder
44444select id,name from mallbuilder_property_value where property_id = '29' order by displayorder
44444select id,name from mallbuilder_property_value where property_id = '30' order by displayorder
44444select id,name from mallbuilder_property_value where property_id = '95' order by displayorder
44444select id,name from mallbuilder_property_value where property_id = '31' order by displayorder
44444select id,name from mallbuilder_property_value where property_id = '88' order by displayorder
44444select id,name from mallbuilder_property_value where property_id = '33' order by displayorder
44444select id,name from mallbuilder_property_value where property_id = '35' order by displayorder
44444select id,name from mallbuilder_property_value where property_id = '91' order by displayorder
44444select id,name from mallbuilder_property_value where property_id = '94' order by displayorder
55555select a.* from mallbuilder_spec a left join mallbuilder_type_spec b on a.id = b.spec_id where b.type_id = '4' order by displayorder
66666select * from mallbuilder_spec_value where spec_id = '12' order by displayorder