SELECT pubs.id as pubId,pubs.name as pubName,pubs.address_line_one,pubs.address_line_two, pubs.postcode, cities.name as cityName,regions.name as regionName, pubs.lat,pubs.lng,descriptions.* FROM pubs LEFT JOIN descriptions ON pubs.id = descriptions.pub_id LEFT JOIN regions on regions.id = pubs.region_id LEFT JOIN cities ON cities.id = pubs.city_id WHERE pubs.id = 2984 NO PUB