SELECT p.*,c.id as cid FROM products_tw as p, categories_tw c, products_category_tw as it WHERE (p.id = '88996691' || p.serial_no = '88996691') AND p.id = it.pid AND it.category=c.id AND (p.available='1' OR (p.available='2' and p.sdate <= '2025-04-22' AND p.edate >= '2025-04-22')) AND c.available = '1' AND it.category in (Surprise) GROUP by it.pid
MySQL Error: Unknown column 'Surprise' in 'where clause'
This script cannot continue, terminating.