 |
|
 |
 |
 |
|
 |
 |
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 = '148' OR pa.shopproduct_id IN (79,79,79,79,79,79,79,27,27,27,27,27,27,27,27,27,27,27,27,27,27,58,58,58,58,58,58,58,58,58,58,58,58,58,58,58,58,58,58,58,58,71,76,76,76,76,76,76,76,76,76,76,76,76,76,76,76,76,91,91,91,91,91,91,91,91,91,91,91,91,91,91,91,91,91,91,120,120,120,120,120,120,120,120,120,120,120,120,121,121,121,121,121,122,122,122,122,122,122,122,122,122,121,122,122,121,122,122,121,121,121,121,121,121,122,121,121,123,123,123,123,123,123,123,123,123,123,123,123,123,123,123,123,123,123,121,131,132,132,132,132,132,132,132,132,132,132,136,136,136,136,136,136,136,136,136,136,136,136,136,136,136,136,136,136,136,136,136,136,136,136,146,146,146,146,146,146,146,146,146,146,146,146,146,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,151,151,151,151,151,151,151,151,151,151,151,151,151,151,151,151,151,151,151,151,151,154,154,154,154,154,154,154,154,154,154,154,154,154,154,154,154,154,154,154,154,154,154,154,154,154,154,155,155,155,155,155,155,155,155,155,155,155,155,155,155,155,155,155,155,155,155,155,156,156,156,156,156,156,156,156,156,156,156,156,156,156,156,156,156,156,156,156,156,190,190,190,190,190,190,190,190,190,190,190,190,190,190,190,215,215,215,215,215,215,215,215,215,215,215,215,363,363,363,363,363,363,363,363,363,363,363,363,363,363,363,363,363,363,363,363,363,368,368,368,368,368,368,368,368,368,368,368,368,368,368,368,368,368,371,371,371,371,371,371,371,371,371,371,371,372,372,372,372,372,372,372,372,372,372,372,372,372,372,372,372,392,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,14,246,246,246,246,246,246,246,246,246,246,246,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,570,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,542,567,567,567,567,567,567,570,570,567,567,567,567,603,616,616,616,632,632,632,632,632,632,632,632,632,632,632,632,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,638,642,642,642,642,642,642,642,642,642,642,642,656,656,656,656,656,656,656,656,656,657,657,657,657,657,657,657,657,657,657,657,657,657,657,657,657,657,657,657,657,657,657,658,658,658,658,658,658,658,658,658,659,659,659,659,659,659,659,659,659,659,659,659,659,659,659,659,659,660,660,660,660,660,660,660,660,660,660,660,660,660,660,660,660,660,660,660,660,661,661,661,661,661,661,661,661,661,661,661,661,661,661,661,661,662,662,662,662,662,662,662,662,662,662,662,662,662,662,662,662,662,662,710,710,710,710,710,710,710,710,710,710,710,710,710,710,710,710,710,710,710,710) )AND
p.status = 1
ORDER BY
p.name1
LIMIT
0, 12 Unknown column 'l.name' in 'field list' | |