|
SELECT
p.id, p.code,
IF(p.name1 = '' OR p.name1 IS NULL, p.name1, p.name1) as name,
p.pic,
pc.category_id,
sc1.name1 AS categoryname
FROM
shopproduct p
INNER JOIN
shopproductcategory pc
ON
p.id = pc.product_id
INNER JOIN
shopcategory sc
ON
pc.category_id = sc.id
INNER JOIN
shopcategory sc1
ON
sc.parent_id = sc1.id
WHERE
p.id IN () AND
p.status = 1 AND
p.pic <> ''
ORDER BY
p.createdate DESC You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND
p.status = 1 AND
p.pic <> ''
ORDER BY
' at line 22 |
Home 
