Search the Directory for Something Specific:
Browse Around the Following Categories:
Access denied for user 'musicpool'@'localhost' (using password: NO)select *, ESTABLISHMENTS.ESTABLISHMENT_ID,ESTABLISHMENTS.ESTABLISHMENT_NAME,ESTABLISHMENT_CATEGORY.CATEGORY_ID , ESTABLISHMENT_SEARCH as search from ESTABLISHMENTS
INNER JOIN ESTABLISHMENT_CATEGORY ON ESTABLISHMENTS.ESTABLISHMENT_ID=ESTABLISHMENT_CATEGORY.ESTABLISHMENT_ID
WHERE ( ESTABLISHMENT_CATEGORY.CATEGORY_ID ='16') GROUP BY ESTABLISHMENT_NAME