SELECT fm.factory_no,fm.tmp_jit,p.standard,substring(p.standard,1,12) standard_short,p.under_stock,p.fanli,p.prod_no,p.prod_name,p.web_name,substring(p.web_name,1,12) web_name_short, p.fanli,p.ref_memo,p.sub_title,p.rebuy_price,p.comp_price,p.normal_price,p.pv,product_img.name
FROM product_m AS p LEFT JOIN product_img ON p.prod_no=product_img.prod_no and product_img.prev=1 ,factory fm,factory_d fd
WHERE p.group_show=1 and fm.factory_no = fd.factory_no and fd.prod_no =p.prod_no and p.prod_no IN(SELECT prod_no FROM product_kind WHERE link_no IN(SELECT link_no FROM kind_link WHERE level1= and level2= and level3=)) and p.prod_no in ( select * from (select prod_no from factory_d where factory_no='C01')tab2) and ( (start_time<='1732464000' and end_time=0)
or (start_time<='1732464000' and end_time>'1732464000')) group by p.prod_no
insert into sql_log values('sql_all','','SELECT fm.factory_no,fm.tmp_jit,p.standard,substring(p.standard,1,12) standard_short,p.under_stock,p.fanli,p.prod_no,p.prod_name,p.web_name,substring(p.web_name,1,12) web_name_short, p.fanli,p.ref_memo,p.sub_title,p.rebuy_price,p.comp_price,p.normal_price,p.pv,product_img.name
FROM product_m AS p LEFT JOIN product_img ON p.prod_no=product_img.prod_no and product_img.prev=1 ,factory fm,factory_d fd
WHERE p.group_show=1 and fm.factory_no = fd.factory_no and fd.prod_no =p.prod_no and p.prod_no IN(SELECT prod_no FROM product_kind WHERE link_no IN(SELECT link_no FROM kind_link WHERE level1= and level2= and level3=)) and p.prod_no in ( select * from (select prod_no from factory_d where factory_no='C01')tab2) and ( (start_time<='1732464000' and end_time=0)
or (start_time<='1732464000' and end_time>'1732464000')) group by p.prod_no','1732490798','','18.191.154.132')
Notice: Could not query database!! in E:\web\chmove\Connection\dbclass.php on line 117
>> 共 項商品
|
|
