in Advanced

Michigan >> Advanced Search


 
Enter Keyword:
Enter Location:
Select Category:
Search:  Business  Products  Events  Deals
 Classifieds  Forum  Community
 
SQL error: Column 'del_code' in where clause is ambiguous\b

Original query: select business_review_data.business_id from business_review_data left OUTER JOIN business_data ON business_review_data.business_id = business_data.business_id WHERE (business_data.city='') AND ((business_data.country='USA')or (business_data.country IS NULL)) AND (title like '%domestic%' or comment like '%domestic%' ) AND del_code='0' AND (business_review_data.category_id ='4' OR business_data.category_id='401' OR business_data.category_id='40101' OR business_data.category_id='40102' OR business_data.category_id='40103' OR business_data.category_id='40104' OR business_data.category_id='40105' OR business_data.category_id='40106' OR business_data.category_id='40107' OR business_data.category_id='40108' OR business_data.category_id='402' OR business_data.category_id='403' OR business_data.category_id='404' OR business_data.category_id='40401' OR business_data.category_id='40402' OR business_data.category_id='40404' OR business_data.category_id='40403' OR business_data.category_id='40405' OR business_data.category_id='405' OR business_data.category_id='40501' OR business_data.category_id='40502' OR business_data.category_id='40503' OR business_data.category_id='40504' OR business_data.category_id='40505' OR business_data.category_id='40506' OR business_data.category_id='406' OR business_data.category_id='40601' OR business_data.category_id='40602' OR business_data.category_id='40603' OR business_data.category_id='40605' OR business_data.category_id='40604' OR business_data.category_id='40606' OR business_data.category_id='40607' OR business_data.category_id='40608' OR business_data.category_id='40609' OR business_data.category_id='40610' OR business_data.category_id='40611' OR business_data.category_id='40612' OR business_data.category_id='407' OR business_data.category_id='40701' OR business_data.category_id='40702' OR business_data.category_id='40703' OR business_data.category_id='408' OR business_data.category_id='40801' OR business_data.category_id='409' OR business_data.category_id='40901' OR business_data.category_id='40902' OR business_data.category_id='40903' OR business_data.category_id='410' OR business_data.category_id='41001' OR business_data.category_id='41002' OR business_data.category_id='411' OR business_data.category_id='41102' OR business_data.category_id='41101' OR business_data.category_id='41103' OR business_data.category_id='41104' OR business_data.category_id='41105' OR business_data.category_id='412' OR business_data.category_id='413' )