SELECT
p.id,
pc.id as category_id,
p.lifestyleshot_image,
p.productshot_image,
p.product_image,
p.distance_image,
p.distance,
p.transmiter,
p.receiver,
p.art_number,
pr.language_id,
pcr.language_id as lang_id,
pr.name,
pr.short_description,
pr.long_description,
pr.key_features,
p.eol
FROM
products p
INNER JOIN
products_resources pr
ON
p.id = pr.product_id
JOIN
products_categories prc
ON
prc.product_id = p.id
LEFT JOIN
productcategories pc
ON
prc.category_id = pc.id
AND
pc.id = '10'
LEFT JOIN
productcategories_resources pcr
ON
pcr.category_id = pc.id
WHERE
p.status = 'active'
AND
p.id = '228'
Unknown column 'p.eol' in 'field list'
|
