You are here: >
>
in Advanced


Delhi > Shalimar bagh ▼
Bookmark and Share

Search Shalimar bagh
Type a keyword - (e.g. restaurant, theatre, pizza, jewellers, tours etc)
SQL error: Column 'del_code' in where clause is ambiguous\b

Original query: Select SQL_CACHE business_review_data.business_id,(MATCH(title, comment) AGAINST ('%Govt*% %Sarvodaya*% %Kanya% %Vidyalaya% %bl% %block% %% %% %%' 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 ('%Govt*% %Sarvodaya*% %Kanya% %Vidyalaya% %bl% %block% %% %% %%' IN BOOLEAN MODE)) AND (business_data.city='Delhi') AND ( business_data.country= 'India' ) AND del_code='0' AND (business_data.add_2 ='Shalimar bagh' or business_data.neighbourhood ='Shalimar bagh' ) HAVING review_relevance > 0.2