Song Lyrics
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.description1 = '' OR p.description1 IS NULL, p.description1, p.description1) as description,
pic,
price,
rebate,
p.publishyear,
p.label_id,
l.name AS labelname,
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
track t
ON
t.shopproduct_id = p.id
LEFT OUTER JOIN
label l
ON
p.label_id = l.id
WHERE
t.id = '62' AND
p.status = 1 Unknown column 'l.name' in 'field list' |