|
SELECT SQL_CALC_FOUND_ROWS
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
FROM
shopproduct p
INNER JOIN
manufacturer m
ON
p.manufacturer_id = m.id
INNER JOIN
shopproductcategory pc
ON
p.id = pc.product_id
LEFT OUTER JOIN
publisher pu
ON
p.publisher_id = pu.id
LEFT OUTER JOIN
label l
ON
p.label_id = l.id
WHERE
pc.category_id = 'cdfolkmusic' AND
p.status = 1
ORDER BY
pc.weight DESC
LIMIT
0, 15 Unknown column 'l.name' in 'field list' | |
Home 
