SQL Error:
SELECT p.pcode , p.pdesc , p.unit , p.qty , p.vat , p.customer_price , p.price , p.pv , p.weight , p.link_regis_uid , pc.catagoryname , pg.groupname , pt.typename , p.product_type , p.product_img , p.locationbase FROM (SELECT pcode , pdesc , type_id , group_id , catagory_id , unit , qty , vat , customer_price , price , pv , weight , link_regis_uid , show_status_link_regis , 1 AS product_type , product_img , locationbase FROM ali_product WHERE pcode NOT LIKE 'DC%' AND pcode NOT LIKE 'RE%' UNION ALL SELECT pcode , pdesc , type_id , group_id , catagory_id , unit , qty , vat , customer_price , price , pv , weight , link_regis_uid , show_status_link_regis , 2 AS product_type , product_img , locationbase FROM ali_product_package ) AS p LEFT JOIN ali_productcatagory pc ON (p.catagory_id = pc.id) LEFT JOIN ali_productgroup pg ON (p.group_id = pg.id) LEFT JOIN ali_productype pt ON (p.type_id = pt.id) WHERE p.pcode NOT LIKE 'DC%' AND p.pcode NOT LIKE 'RE%' AND p.show_status_link_regis = 1 AND p.locationbase =