|
0 | SELECT `countries`.*, ST_AsText(`countries`.location) AS `location` FROM `countries` WHERE (`countries`.`subdomain` = 'bulgaria') LIMIT 1; |
1 | SELECT `ws_visits`.* FROM `ws_visits` WHERE (`ws_visits`.`hash_id` = '9a6cff42934145ed2623356a949e983e') LIMIT 1; |
2 | SELECT `cities`.*, ST_AsText(`cities`.location) AS `location` FROM `cities` WHERE (`cities`.`seo_link` = 'varna') LIMIT 1; |
3 | SELECT * FROM ws_menus WHERE LOWER(url) = "search"
AND parent_id IS NULL
AND (country_id = 13 OR country_id IS NULL)
AND (site_id = 3 OR site_id IS NULL)
ORDER BY country_id DESC, site_id DESC LIMIT 1; |
4 | SELECT DISTINCT ad_id FROM n2n_estate_ad_recent WHERE session_id = "36fa8dh9l10h5noju5duepi211" ORDER BY ctime DESC; |
5 | SELECT estate_ad.score_info, estate_ad.name, estate_ad.name_en, estate_ad.description, estate_ad.description_en, estate_ad.id, estate_ad.adress, estate_ad.adress_en, 2 as currency, ((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) / 41.547) as price_usd, estate_ad.no_reservation, estate_ad.city_public_paused, estate_ad.lat, estate_ad.lng, estate_ad.city_id, estate_ad.country_id, estate_ad.rooms, estate_ad.images, estate_ad.type_id, estate_ad.qty_comments, estate_ad.comments_score, estate_ad.can_low_price, estate_ad.sleeping, estate_ad.city_hot_paused, estate_ad.city_hot_main_paused, estate_ad.end_hot_2, estate_ad.end_hot_main, estate_ad.end_public, estate_ad.end_hot, estate_ad.daily_fee_paid, estate_ad.recommend, estate_ad.reserv, estate_ad.partner_id, estate_ad.customer_id FROM estate_ad WHERE estate_ad.parked = 0 AND estate_ad.public = 1 AND estate_ad.city_id = 2948 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-13" OR estate_ad.reserv = 1 OR estate_ad.city_id = 9602 OR estate_ad.city_id = 9870) ORDER BY estate_ad.daily_fee_paid DESC, estate_ad.daily_fee_time ASC, estate_ad.score DESC, estate_ad.id ASC LIMIT 0,26; |
6 | SELECT `city_info`.* FROM `city_info` WHERE ((city_id = 2948 OR city_id = 0 OR city_id IS NULL)) AND (`city_info`.`site_id` = '3') AND ((country_id = 13 OR country_id = 0 OR country_id IS NULL)) AND (`city_info`.`site_id` IS NULL OR `city_info`.`site_id` = '3') ORDER BY IFNULL(country_id, 0) DESC, IFNULL(city_id, 0) DESC; |
7 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Квартиры посуточно') LIMIT 1; |
8 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Укажите город') LIMIT 1; |
9 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'объект') LIMIT 1; |
10 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'объекта') LIMIT 1; |
11 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'объектов') LIMIT 1; |
12 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Комнаты и гости') LIMIT 1; |
13 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Тип жилья') LIMIT 1; |
14 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'от') LIMIT 1; |
15 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Расположение') LIMIT 1; |
16 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Другие фильтры') LIMIT 1; |
17 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Очистить') LIMIT 1; |
18 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Мгновенные') LIMIT 1; |
19 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'например') LIMIT 1; |
20 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Гости') LIMIT 1; |
21 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'По рейтингу') LIMIT 1; |
22 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'по рейтингу') LIMIT 1; |
23 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'сначала с отзывами') LIMIT 1; |
24 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'сначала мгновенные') LIMIT 1; |
25 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'безопасное бронирование') LIMIT 1; |
26 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'сначала дешевле') LIMIT 1; |
27 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'сначала дороже') LIMIT 1; |
28 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'по скорости ответа') LIMIT 1; |
29 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Забронировать мгновенно') LIMIT 1; |
30 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'ad_type_id_30') LIMIT 1; |
31 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'комнаты') LIMIT 1; |
32 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'комнат') LIMIT 1; |
33 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Ваши платежи защищены') LIMIT 1; |
34 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'гарантирует безопасность') LIMIT 1; |
35 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'бронирования') LIMIT 1; |
36 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'договор оферты') LIMIT 1; |
37 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'безопасные платежи') LIMIT 1; |
38 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'гарантия возврата средств') LIMIT 1; |
39 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Всё это работает только при условии') LIMIT 1; |
40 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'через сайт') LIMIT 1; |
41 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'ad_type_id_27') LIMIT 1; |
42 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'ad_type_id_24') LIMIT 1; |
43 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Ничего') LIMIT 1; |
44 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'не подошло') LIMIT 1; |
45 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Заполните') LIMIT 1; |
46 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'заявку на поиск') LIMIT 1; |
47 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Мы отправим ее всем владельцам недвижимости в городе') LIMIT 1; |
48 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Показать еще') LIMIT 1; |
49 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Искать в радиусе') LIMIT 1; |
50 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'км') LIMIT 1; |
51 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'предложение') LIMIT 1; |
52 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'предложения') LIMIT 1; |
53 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'предложений') LIMIT 1; |
54 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'Списком') LIMIT 1; |
55 | SELECT `ws_translations`.* FROM `ws_translations` WHERE (`ws_translations`.`name` = 'На карте') LIMIT 1; |
56 | SELECT `comments`.* FROM `comments` WHERE (`comments`.`public` = 1) AND (`comments`.`type` = 1) AND (`comments`.`site_id` IS NULL OR `comments`.`site_id` = '3') ORDER BY `ctime` DESC LIMIT 5; |
Социальные сети