string(286) "SELECT distinct l.LocationID as id, l.LocationName as name, l.red_flag
FROM tbllocations as l  LEFT OUTER JOIN toplocations_typ as tl ON (l.locationid=tl.locationid and 3 = tl.type_id) 
WHERE l.NotToShoot = 0
	AND l.IsActive = 1 
	AND l.CountryCode = 'ZA'
		ORDER BY name ASC LIMIT 2000"