in Advanced

Bay Area >> 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 '%volunteer%' or comment like '%volunteer%' ) AND del_code='0' AND (business_review_data.category_id ='7' OR business_data.category_id='701' OR business_data.category_id='702' OR business_data.category_id='703' OR business_data.category_id='704' OR business_data.category_id='705' OR business_data.category_id='706' OR business_data.category_id='707' OR business_data.category_id='708' OR business_data.category_id='709' OR business_data.category_id='70901' OR business_data.category_id='70902' OR business_data.category_id='710' OR business_data.category_id='711' )