SELECT
ct_category.id as ct_category_id,
ct_category.name as ct_category_name,
ct_category.slug as ct_category_slug
FROM ct_category
LEFT JOIN ct_promoter_website_category_iorder on ct_category.id = ct_promoter_website_category_iorder.ct_category_id
and ct_promoter_website_category_iorder.ct_promoter_website_id = 5595
and ct_promoter_website_category_iorder.active = 1
WHERE ct_category.active = 1
and ct_category.id in ()
ORDER BY ct_promoter_website_category_iorder.iorder, ct_category.iorder, ct_category.name
ERROR: syntax error at or near ")"
LINE 10: and ct_category.id in ()
^