SELECT markers.id, markers.streetsid, markers.address1, markers.address2, markers.city, markers.state, markers.zip, markers.country, markers.eventdate, markers.iconid, markers.latitude, markers.longitude, markers.lonlatmatch, markers.markerdetails, markers.markername, markers.view, icontypes.id AS IconTypesID, icontypes.IconImgPath, icontypes.IconImgName FROM markers LEFT JOIN icontypes ON markers.iconid = icontypes.ID WHERE markers.latitude BETWEEN #geoboxed.latmin# AND #geoboxed.latmax# AND markers.longitude BETWEEN #geoboxed.lonmin# AND #geoboxed.lonmax# AND markers.view = 6 AND ( markers.streetsid = 0 OR (markers.streetsid IN(select id FROM users WHERE users.username LIKE '%#arguments.searchstr#%' OR users.name LIKE '%#arguments.searchstr#%')) OR (markers.streetsid IN(select userid FROM garage WHERE garage.car_name LIKE '%#arguments.searchstr#%')) OR (markers.streetsid IN(select streetsid FROM garagedescriptions WHERE garagedescriptions.details LIKE '%#arguments.searchstr#%')) OR (markers.streetsid IN(select userid FROM garage WHERE garage.car_make LIKE '%#arguments.car_make#%')) ) GROUP BY markers.streetsid SELECT ID,LATITUDE,LONGITUDE FROM getBrowseQueryResultsTMP WHERE ID = #id# ORDER BY ID