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 =