THE TRUE AUSTRALIAN
TRADE SITE FOR ALL
MySQL Server:
42S22 - Unknown column 'c.customer_membership_id' in 'where clause'.
SELECT a.*, b.`module_text`, b.`module_image` from
`content_advertising` a
inner join `content_advertising_template` b on b.`id` = a.`template_id`
inner join `content_advertising_stores_all` c ON a.id = c.content_advertising_id
WHERE c.customer_membership_id='' AND a.active=1 AND a.expiration_date>='2025-10-09' AND '' NOT IN(SELECT z.user_id FROM content_advertising_stores_user_except z WHERE z.user_id='' AND z.content_advertising_id=a.id) ORDER BY a.`order` ASC LIMIT 20