A Database Error Occurred

Error Number: 1054

Unknown column 'offer_campaign.id' in 'where clause'

SELECT * FROM (`business_information`) WHERE FIND_IN_SET('144',subcategory) != 0 AND `location` = '47' AND `category` = '143' 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

Bejsment