in Advanced


Gurgaon > Patel Nagar ▼
Bookmark and Share

Search Patel Nagar
Type a keyword - (e.g. restaurant, theatre, pizza, jewellers, tours etc)
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 ('%propert*% %dealer*% %near% %civil% %hospital% %% %% %% %%' 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 ('%propert*% %dealer*% %near% %civil% %hospital% %% %% %% %%' IN BOOLEAN MODE)) AND (business_data.city='Gurgaon') AND ( business_data.country= 'India' ) AND del_code='0' AND (business_review_data.category_id ='1' or category_id = 101 or category_id = 102 or category_id = 103 or category_id = 104 or category_id = 105 or category_id = 106 or category_id = 107 or category_id = 108 or category_id = 109 or category_id = 110 or category_id = 111 or category_id = 10801 or category_id = 10802 or category_id = 10803 or category_id = 10804 or category_id = 10805 or category_id = 10806 or category_id = 10807 or category_id = 10808 or category_id = 10901 or category_id = 11001 ) AND (business_data.add_2 ='Patel Nagar' or business_data.neighbourhood ='Patel Nagar' ) HAVING review_relevance > 0.2