We hebben de producten onderverdeeld in (sub)categorieën. U kunt kiezen op medium (CD, DVD, etc.) of op genre.
Kies hiernaast een categorie waar u meer van wil zien.
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 cat_id = 155
ORDER BY
CASE WHEN pt.titel like ' %' THEN...' at line 6 on: `SELECT *, p.artiest as p_artiest
FROM `gos_shop_producten` p
LEFT JOIN `gos_shop_product2categorie` pc ON pc.product_id = p.product_id
LEFT JOIN `gos_shop_producten_text` pt ON p.product_id = pt.product_id
WHERE
AND cat_id = 155
ORDER BY
CASE WHEN pt.titel like ' %' THEN 0
WHEN pt.titel like '%' THEN 1
WHEN pt.titel like '% %' THEN 2
ELSE 3
END, pt.titel LIMIT ?,?;`.
