 |
|
 |
 |
|
|
|
|
|
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,
sc.showfields,
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
pc.category_id = sc.id
LEFT OUTER JOIN
publisher pu
ON
p.publisher_id = pu.id
LEFT OUTER JOIN
label l
ON
p.label_id = l.id
INNER JOIN
shopproductartist pa
ON
p.id = pa.shopproduct_id
WHERE
(pa.artist_id = '50' OR pa.shopproduct_id IN (72,72,74,74,164,195,195) )AND
p.status = 1
ORDER BY
p.name1
LIMIT
0, 12 Unknown column 'l.name' in 'field list' | |
Home 
