SELECT beach.id,dogs, dogNote, beach.lon, beach.lat, surf_desc, fishing, directions, parking, lifeguards, aka, amenities, cam, cam2, beach.name AS beachname, beach.description AS beachdescription, towns.name AS townname, area.name AS areaname, area.url AS url FROM `beach`,`towns`, `area` WHERE beach.name LIKE 'Mother Ivey's Bay' AND towns.id = beach.town AND beach.area = area.id Query failed