You are here: >
>
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='Nawanshahr') AND ((business_data.country='India')or (business_data.country IS NULL)) AND (title like '%adidas%' or comment like '%adidas%' ) AND business_review_data.del_code='0' AND (business_review_data.category_id ='4' or category_id = 401 or category_id = 402 or category_id = 403 or category_id = 404 or category_id = 405 or category_id = 406 or category_id = 407 or category_id = 408 or category_id = 409 or category_id = 410 or category_id = 411 or category_id = 412 or category_id = 413 or category_id = 40101 or category_id = 40102 or category_id = 40103 or category_id = 40104 or category_id = 40105 or category_id = 40106 or category_id = 40107 or category_id = 40108 or category_id = 40401 or category_id = 40402 or category_id = 40403 or category_id = 40404 or category_id = 40405 or category_id = 40501 or category_id = 40502 or category_id = 40503 or category_id = 40504 or category_id = 40505 or category_id = 40506 or category_id = 40601 or category_id = 40602 or category_id = 40603 or category_id = 40604 or category_id = 40605 or category_id = 40606 or category_id = 40607 or category_id = 40608 or category_id = 40609 or category_id = 40610 or category_id = 40611 or category_id = 40612 or category_id = 40701 or category_id = 40702 or category_id = 40703 or category_id = 40801 or category_id = 40901 or category_id = 40902 or category_id = 40903 or category_id = 41001 or category_id = 41002 or category_id = 41101 or category_id = 41102 or category_id = 41103 or category_id = 41104 or category_id = 41105 )