in Advanced

>
Advanced Search


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

Original query: select SQL_CACHE 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='Lucknow') AND ((business_data.country='India')or (business_data.country IS NULL)) AND (title like '%09280903507400%' or comment like '%09280903507400%' ) AND business_review_data.del_code='0' AND (business_review_data.category_id ='410' or category_id = 41001 or category_id = 41002 )