Error Number: 1054
Unknown column 'offer_campaign.id' in 'where clause'
SELECT * FROM (`business_information`) WHERE FIND_IN_SET('123',subcategory) != 0 AND `location` = '47' AND `category` = '31' AND `publisher` = '4' AND `status` = 1 AND `paidStatus` = 1 AND `listing` = 'premium' AND (SELECT avg(paid) FROM offer_campaign as oc JOIN offer_list on offer_list.id in (oc.list_offer) JOIN orders_info on orders_info.online_ad_id = offer_list.id_ads JOIN order_list on orders_info.order_id = order_list.order_id WHERE oc.id = offer_campaign.id) = 1
Filename: /var/www/admin.clascal.com/public_html/models/business_model.php
Line Number: 276