in Advanced

Advanced Search

Enter Keyword:
Enter Location:
Select Category:
Search:  Business  Products  Events  Deals
 Classifieds  Forum  Community
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 ('%rto*% %online*% %checking% %of% %learning% %licence% %issue% %status% %%' 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 ('%rto*% %online*% %checking% %of% %learning% %licence% %issue% %status% %%' IN BOOLEAN MODE)) AND ('Lucknow') AND ( 'India' ) AND del_code='0' HAVING review_relevance > 0.2