SELECT * FROM `hotel_offer`, `counchsurfing_offer` `offers` WHERE `hotel_offer`.`id` AND `counchsurfing_offer`.`id` IN (SELECT `offers`.`offer_id` FROM `offers` WHERE (`map_position_lat` < '46.65730590716864' AND `map_position_lat` > '46.278960077142436' AND `map_position_lon` > '30.44723635143587' AND `map_position_lon` < '30.99655026965788') )