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,(MATCH(title, comment) AGAINST ('%ssc*% %board*% %exam% %2013% %center% %code% %1461% %% %%' IN BOOLEAN MODE)) as review_relevance from business_review_data left OUTER JOIN business_data ON business_review_data.business_id = business_data.business_id WHERE (MATCH(title, comment) AGAINST ('%ssc*% %board*% %exam% %2013% %center% %code% %1461% %% %%' IN BOOLEAN MODE)) AND (business_data.city='Mumbai') AND ( business_data.country= 'India' ) AND del_code='0' AND (business_review_data.category_id ='1901' or category_id = 190102 or category_id = 190103 or category_id = 190104 or category_id = 190105 or category_id = 190106 or category_id = 190107 or category_id = 190108 ) HAVING review_relevance > 0.2