|
0 | SELECT `ws_visits`.* FROM `ws_visits` WHERE (`ws_visits`.`hash_id` = 'cb4971ef1e6d7b01055e5fc2767d45f0') LIMIT 1; |
1 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 9756 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
2 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 9907 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
3 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 9967 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
4 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 10117 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
5 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 9737 AND estate_ad.partner_id IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
6 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 9686 AND estate_ad.partner_id IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
7 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 9492 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
8 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 9550 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
9 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 9649 AND estate_ad.partner_id IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
10 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 9690 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
11 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 9722 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
12 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 10153 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
13 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 9990 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
14 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 9558 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
15 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 9786 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
16 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 31 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
17 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 9910 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
18 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 9999 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
19 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 10020 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
20 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 10042 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
21 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 10067 AND estate_ad.partner_id IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
22 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 9920 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
23 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 9680 AND estate_ad.partner_id IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
24 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 10140 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
25 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 10163 AND estate_ad.partner_id IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
26 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 10186 AND estate_ad.partner_id IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
27 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 10213 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
28 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 10228 AND estate_ad.partner_id IS NULL AND estate_ad.city_public_paused IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |
29 | SELECT COUNT(1) as qty, MIN((CASE estate_ad.currency WHEN 1 THEN estate_ad.price_eur * 46.7528 WHEN 2 THEN estate_ad.price_usd * 41.547 WHEN 3 THEN estate_ad.price_rub * 0.60353 WHEN 4 THEN estate_ad.price_gbp * 55.1536 WHEN 5 THEN estate_ad.price_chf * 50.0114 WHEN 6 THEN estate_ad.price_uah * 1 WHEN 7 THEN estate_ad.price_kzt * 0.080536 WHEN 8 THEN estate_ad.price_bgn * 16.683198691073 WHEN 9 THEN estate_ad.price_byn * 15.0766 WHEN 10 THEN estate_ad.price_azn * 24.4351 END)) as min FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 9958 AND estate_ad.partner_id IS NULL AND (estate_ad.no_reservation = 0 OR estate_ad.daily_fee_paid > 0 OR estate_ad.end_public >= "2025-05-12" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870); |