SELECT
p.id, p.code, p.parent_id,
pc.id AS productcategoryid,
IF(p.name1 = '' OR p.name1 IS NULL, p.name1, p.name1) as name,
IF(p.shortdescription1 = '' OR p.shortdescription1 IS NULL, p.shortdescription1, p.shortdescription1) as shortdescription,
IF(p.popupdescription1 = '' OR popupdescription1 IS NULL, p.popupdescription1, p.popupdescription1) as popupdescription,
p.pic,
p.price,
p.rebate,
p.publishyear,
p.isbn,
p.label_id,
p.manufacturer_id,
p.publisher_id,
l.name AS labelname,
m.name1 AS manufacturername,
pu.name AS publishername,
pc.category_id
FROM
shopproduct p
INNER JOIN
manufacturer m
ON
p.manufacturer_id = m.id
INNER JOIN
shopproductcategory pc
ON
p.id = pc.product_id
INNER JOIN
shopcategory sc
ON
sc.id = pc.category_id
LEFT OUTER JOIN
publisher pu
ON
p.publisher_id = pu.id
LEFT OUTER JOIN
label l
ON
p.label_id = l.id
WHERE
p.id IN (864, 917, 855, 511) AND
p.status = 1
GROUP BY
p.id
LIMIT
4 Unknown column 'l.name' in 'field list' | | |