SELECT product_no,menu_class,class,eng_class,sub_class,eng_sub_class,small_class,eng_small_class_x,class_index,PC_ID,topic_index,product_name,supplier,brand,show_brand,show_class,model,color,unit,packing,cost,ref_price,selling_price,easy_price,vipprice,region_price,min_qty,min_order_price,product_description,status,remark,related_product,stock_qty,htm_page,htm_page_h,gift,gift_link,add_pic,min_gift,min_order_gift,min_gift_link,exchange_price,exchange_gift,exchange_text,exchange_unit,exchange_link,exclude_if,exclude_quantity,'stat' as typess FROM stationery_2 WHERE stationery_2.easy_price < stationery_2.selling_price AND stationery_2.easy_price > 0 AND stationery_2.status<>'1' and stationery_2.class='梁隤嗅鞎冽' union SELECT product_no,menu_class,class,eng_class,sub_class,eng_sub_class,small_class,eng_small_class_x,class_index,PC_ID,topic_index,product_name,supplier,brand,show_brand,show_class,model,color,unit,packing,cost,ref_price,selling_price,easy_price,vipprice,region_price,min_order as min_qty,min_order_price,product_description,status,remark,related_product,stock_qty,htm_page,htm_page_h,gift,gift_link,add_pic,min_gift,min_order_gift,min_gift_link,exchange_price,exchange_gift,exchange_text,exchange_unit,exchange_link,exclude_if,exclude_quantity,'mach' as typess FROM machine WHERE machine.easy_price < machine.selling_price AND machine.easy_price > 0 AND machine.status<>'1' and machine.class='梁隤嗅鞎冽' order by PC_ID asc limit 0,20mysql_do error! |