SELECT SQL_CALC_FOUND_ROWS
p.id, p.code, p.parent_id,
pc.id AS productcategoryid,
IF(p.name5 = '' OR p.name5 IS NULL, p.name1, p.name5) as name,
IF(p.shortdescription5 = '' OR p.shortdescription5 IS NULL, p.shortdescription1, p.shortdescription5) as shortdescription,
IF(p.popupdescription5 = '' OR popupdescription5 IS NULL, p.popupdescription1, p.popupdescription5) as popupdescription,
p.pic,
p.price,
p.rebate,
p.isbn,
p.publishyear,
p.manufacturer_id,
p.publisher_id,
m.name5 AS manufacturername,
pu.name2 AS publishername
FROM
shopproduct p
INNER JOIN
manufacturer m
ON
p.manufacturer_id = m.id
LEFT OUTER JOIN
publisher pu
ON
p.publisher_id = pu.id
INNER JOIN
shopproductcategory pc
ON
p.id = pc.product_id
WHERE
pc.category_id = 'textiles-bg∏uct_id=871' AND
p.parent_id = 0 AND
p.status = 1
ORDER BY
pc.weight DESC
LIMIT
0, 10 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' |