• 0

Domy

Zawęź wyszukanie
Wyszukiwanie zaawansowane
Dom, 600 m², Kraków
19 900 000 zł

Dom, 600 m², Kraków

600 m233166zł/m2
Energooszczędny Dom MDM Przy Lesie, ul. Osiedle Tygrysie Dachowa
289 000 zł

Energooszczędny Dom MDM Przy Lesie, ul. Osiedle Tygrysie Dachowa

99-230 m22919zł/m2
Tomaryny (Mazury Zach.) Leśniczówka + Stodoła + 0,5-3 Ha Działka
748 000 zł

Tomaryny (Mazury Zach.) Leśniczówka + Stodoła + 0,5-3 Ha Działka

130 m25753zł/m2
Dom, 573 m², Warszawa
18 000 zł

Dom, 573 m², Warszawa

573 m231zł/m2
Mikołajki posiadłość sprzedam
995 000 zł

Mikołajki posiadłość sprzedam

200 m² m24975zł/m2

136 ogłoszeń z kategorii: Domy

Dom, 560 m², Warszawa
2 490 000 zł

Dom, 560 m², Warszawa

560 m24446zł/m2
Nowy dom, stan deweloperski
379 000 zł

Nowy dom, stan deweloperski

127.96 m22961zł/m2
Dom z garażem Opole
619 000 zł

Dom z garażem Opole

159 m23893zł/m2
Całoroczny dom, na dużej zagospodarowanej działce
238 000 zł

Całoroczny dom, na dużej zagospodarowanej działce

60.50 m23933zł/m2
Poniemiecka willa w Cieplicach Śląskich Zdrój
2 200 000 zł

Poniemiecka willa w Cieplicach Śląskich Zdrój

355.15 m26194zł/m2
FES
23 124 zł

FES

22 m21051zł/m2
Nowocześnie urządzony i przytulny - Włochy
1 585 000 zł

Nowocześnie urządzony i przytulny - Włochy

290 m25465zł/m2
Ursus centum blisko Pkp dom wolnostojący
1 100 000 zł

Ursus centum blisko Pkp dom wolnostojący

160 m26875zł/m2
Zielona i cicha Sadyba
1 530 000 zł

Zielona i cicha Sadyba

255 m26000zł/m2
Dom, 148 m², Warszawa
1 350 000 zł

Dom, 148 m², Warszawa

148 m29121zł/m2
Rezydencja, 730m2, pod lasem, na granicy Warszawy
9 000 000 zł

Rezydencja, 730m2, pod lasem, na granicy Warszawy

730 m212328zł/m2
Dom na Ursynowie 290 m2. Spokojna i cicha okolica.
1 870 000 zł

Dom na Ursynowie 290 m2. Spokojna i cicha okolica.

290 m26448zł/m2
  Database queries (Total queries: 159 - Total queries time: 0.11312913894653)  
0.00092720985412598 SELECT *
FROM (oc_t_preference)
0.0011429786682129 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.0023210048675537 SELECT *
FROM ((SELECT a.*, b.*, c.i_num_items, FIELD(fk_c_locale_code, 'pl_PL') as locale_order
FROM (oc_t_category as a)
INNER JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT JOIN oc_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id
WHERE b.s_name != ''
AND a.b_enabled = 1
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
0.0015499591827393 SELECT *
FROM ((SELECT a.*, b.*, c.i_num_items, FIELD(fk_c_locale_code, 'pl_PL') as locale_order
FROM (oc_t_category as a)
INNER JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT JOIN oc_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id
WHERE b.s_slug = 'domy'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
0.00032210350036621 SELECT f.pk_i_id
FROM (oc_t_meta_fields f, oc_t_meta_categories c)
WHERE ( c.fk_i_category_id = 237 )
AND f.pk_i_id = c.fk_i_field_id
AND f.b_searchable = 1
0.00028300285339355 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'page'
LIMIT 1
0.00019717216491699 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sCategory'
LIMIT 1
0.0020880699157715 SELECT oc_t_item.*, oc_t_item.s_contact_name as s_user_name, oc_t_item_car_attr.i_power, oc_t_item_car_attr.i_year, oc_t_item_car_attr.i_mileage, oc_t_item_car_attr.e_fuel
FROM (oc_t_item)
LEFT JOIN oc_t_item_location ON oc_t_item_location.fk_i_item_id = oc_t_item.pk_i_id
LEFT JOIN oc_t_item_car_attr ON oc_t_item_car_attr.fk_i_item_id = oc_t_item.pk_i_id
WHERE oc_t_item.b_enabled = 1 AND oc_t_item.b_active = 1 AND oc_t_item.b_spam = 0 AND (oc_t_item.b_premium = 1 || oc_t_item.dt_expiration >= '2022-05-16 07:35:36')
AND oc_t_item.fk_i_category_id IN (237)
ORDER BY dt_pub_date desc
LIMIT 0, 12
0.0014209747314453 SELECT oc_t_item.pk_i_id, oc_t_item_car_attr.i_power, oc_t_item_car_attr.i_year, oc_t_item_car_attr.i_mileage, oc_t_item_car_attr.e_fuel
FROM (oc_t_item)
LEFT JOIN oc_t_item_location ON oc_t_item_location.fk_i_item_id = oc_t_item.pk_i_id
LEFT JOIN oc_t_item_car_attr ON oc_t_item_car_attr.fk_i_item_id = oc_t_item.pk_i_id
WHERE oc_t_item.b_enabled = 1 AND oc_t_item.b_active = 1 AND oc_t_item.b_spam = 0 AND (oc_t_item.b_premium = 1 || oc_t_item.dt_expiration >= '2022-05-16 07:35:36')
AND oc_t_item.fk_i_category_id IN (237)
ORDER BY dt_pub_date desc
LIMIT 1200000
0.00036120414733887 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1150'
0.00065994262695312 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '1150'
AND s.fk_i_item_id = '1150'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00037002563476562 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1149'
0.00082182884216309 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '1149'
AND s.fk_i_item_id = '1149'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00023698806762695 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1148'
0.00054001808166504 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '1148'
AND s.fk_i_item_id = '1148'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00024199485778809 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1147'
0.00055909156799316 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '1147'
AND s.fk_i_item_id = '1147'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00027203559875488 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1146'
0.0013539791107178 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '1146'
AND s.fk_i_item_id = '1146'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.0005030632019043 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1140'
0.00059795379638672 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '1140'
AND s.fk_i_item_id = '1140'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00037312507629395 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1082'
0.00046300888061523 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '1082'
AND s.fk_i_item_id = '1082'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00027012825012207 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1081'
0.00050902366638184 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '1081'
AND s.fk_i_item_id = '1081'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00031900405883789 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1075'
0.00071883201599121 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '1075'
AND s.fk_i_item_id = '1075'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00033211708068848 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1073'
0.00048184394836426 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '1073'
AND s.fk_i_item_id = '1073'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00026822090148926 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1071'
0.00052309036254883 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '1071'
AND s.fk_i_item_id = '1071'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00025010108947754 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1069'
0.0005500316619873 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '1069'
AND s.fk_i_item_id = '1069'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00054097175598145 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.00038003921508789 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_5'
0.00075507164001465 SELECT g.b_id as "b_group_id", g.b_name as "b_group_name", g.b_banner_id, b.*, rand() as "rand_ind"
FROM (oc_t_banner b, oc_t_banner_group g)
WHERE g.b_banner_id = b.b_id
AND g.b_id = 5
ORDER BY rand_ind asc
0.00032305717468262 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_5'
0.00037312507629395 SELECT *
FROM (oc_t_banner)
WHERE b_id = '5'
0.0012710094451904 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=5
0.002079963684082 SELECT *
FROM ((SELECT a.*, b.*, c.i_num_items, FIELD(fk_c_locale_code, 'pl_PL') as locale_order
FROM (oc_t_category as a)
INNER JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT JOIN oc_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 237
AND a.b_enabled = '1'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
0.00089192390441895 SELECT oc_t_country_stats.fk_c_country_code as country_code, oc_t_country_stats.i_num_items as items, oc_t_country.s_name as country_name, oc_t_country.s_slug as country_slug
FROM (oc_t_country_stats)
JOIN oc_t_country ON oc_t_country_stats.fk_c_country_code = oc_t_country.pk_c_code
WHERE i_num_items > 0
ORDER BY country_name ASC
0.00049686431884766 SELECT STRAIGHT_JOIN oc_t_region_stats.fk_i_region_id as region_id, oc_t_region_stats.i_num_items as items, oc_t_region.s_name as region_name, oc_t_region.s_slug as region_slug
FROM (oc_t_region , oc_t_region_stats)
WHERE oc_t_region_stats.fk_i_region_id = oc_t_region.pk_i_id
AND i_num_items > 0
ORDER BY region_name ASC
0.0017490386962891 SELECT oc_t_city_stats.fk_i_city_id as city_id, oc_t_city_stats.i_num_items as items, oc_t_city.s_name as city_name, oc_t_city.s_slug as city_slug
FROM (oc_t_city_stats)
LEFT JOIN oc_t_city ON oc_t_city_stats.fk_i_city_id = oc_t_city.pk_i_id
WHERE i_num_items > 0
ORDER BY city_name ASC
0.0020990371704102 SELECT *
FROM ((SELECT a.*, b.*, c.i_num_items, FIELD(fk_c_locale_code, 'pl_PL') as locale_order
FROM (oc_t_category as a)
INNER JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT JOIN oc_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id
WHERE fk_i_parent_id = 237
AND a.b_enabled = '1'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
0.0006411075592041 SELECT oc_t_country_stats.fk_c_country_code as country_code, oc_t_country_stats.i_num_items as items, oc_t_country.s_name as country_name, oc_t_country.s_slug as country_slug
FROM (oc_t_country_stats)
JOIN oc_t_country ON oc_t_country_stats.fk_c_country_code = oc_t_country.pk_c_code
WHERE i_num_items > 0
ORDER BY country_name ASC
0.00048303604125977 SELECT mf.*
FROM (oc_t_meta_fields mf, oc_t_meta_categories mc)
WHERE mc.fk_i_category_id = '237'
AND mf.pk_i_id = mc.fk_i_field_id
0.00060081481933594 SELECT COUNT(*) AS numrows
FROM (oc_t_plugin_category)
WHERE fk_i_category_id = '237'
AND s_plugin_name = 'custom_attributes'
0.00054788589477539 SELECT *
FROM (oc_t_item_custom_attr_groups)
JOIN oc_t_item_custom_attr_categories ON fk_i_group_id = pk_i_id
WHERE fk_i_category_id = '237'
ORDER BY oc_t_item_custom_attr_groups.order ASC
0.00044107437133789 SELECT fk_i_field_id
FROM (oc_t_item_custom_attr_meta)
0.0010981559753418 SELECT *
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id NOT IN ('3', '4', '5', '8', '9', '10', '11', '12', '13', '14', '15', '17', '18', '20', '21', '28', '29', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '41', '42', '43', '44', '45', '46', '47', '50', '51', '52', '53', '57', '58', '59', '60', '61', '62', '63', '64', '65', '66', '67', '70', '71', '77', '78', '79', '80', '81', '82', '83', '84', '85', '86', '87', '89', '90', '91', '93', '94', '95', '97', '98', '99', '105', '107', '109', '110', '112', '113', '114', '115', '116', '117', '118', '119', '120', '121', '122', '123', '124', '125', '126', '128', '129', '130', '131', '133', '134', '136', '137', '138', '139', '140', '141', '142', '143', '144', '147', '151', '152', '153', '154', '155', '156', '157', '158', '159', '160', '161', '162', '163', '164', '165', '171', '173', '174', '175', '176', '178', '181', '184', '185', '186', '187', '188', '192', '193', '194', '195', '196', '197', '198', '199', '200', '202', '203', '205', '206', '207', '208', '209', '210', '211', '212', '213', '214', '215', '216', '217', '218', '219', '221', '222', '223', '224', '225', '226', '227', '228', '229', '230', '231', '233', '234', '235', '236', '237', '238')
ORDER BY i_order ASC
0.0012688636779785 SELECT *
FROM (oc_t_item_custom_attr_fields)
JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id
WHERE fk_i_group_id = '1'
ORDER BY i_order ASC
0.00048112869262695 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '120'
LIMIT 1
0.00031590461730957 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '5'
LIMIT 1
0.00031185150146484 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '4'
LIMIT 1
0.00029993057250977 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '202'
LIMIT 1
0.0012080669403076 SELECT *
FROM (oc_t_item_custom_attr_fields)
JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id
WHERE fk_i_group_id = '5'
ORDER BY i_order ASC
0.00033307075500488 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '39'
LIMIT 1
0.0002892017364502 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '36'
LIMIT 1
0.00028896331787109 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '38'
LIMIT 1
0.00026106834411621 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '50'
LIMIT 1
0.00030994415283203 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '91'
LIMIT 1
0.00026679039001465 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '130'
LIMIT 1
0.00026679039001465 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '51'
LIMIT 1
0.00026106834411621 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '41'
LIMIT 1
0.00024294853210449 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '52'
LIMIT 1
0.00026512145996094 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '124'
LIMIT 1
0.00028109550476074 SELECT s_options
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = '216'
LIMIT 1
0.00087499618530273 SELECT *
FROM (oc_t_item_custom_attr_fields)
JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id
WHERE fk_i_group_id = '6'
ORDER BY i_order ASC
0.00074315071105957 SELECT *
FROM (oc_t_item_custom_attr_fields)
JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id
WHERE fk_i_group_id = '18'
ORDER BY i_order ASC
0.00083518028259277 SELECT *
FROM (oc_t_item_custom_attr_fields)
JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id
WHERE fk_i_group_id = '14'
ORDER BY i_order ASC
0.00076794624328613 SELECT *
FROM (oc_t_item_custom_attr_fields)
JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id
WHERE fk_i_group_id = '3'
ORDER BY i_order ASC
0.00077605247497559 SELECT *
FROM (oc_t_item_custom_attr_fields)
JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id
WHERE fk_i_group_id = '24'
ORDER BY i_order ASC
0.00085115432739258 SELECT *
FROM (oc_t_item_custom_attr_fields)
JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id
WHERE fk_i_group_id = '10'
ORDER BY s_label ASC
0.00081110000610352 SELECT *
FROM (oc_t_item_custom_attr_fields)
JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id
WHERE fk_i_group_id = '16'
ORDER BY i_order ASC
0.00082516670227051 SELECT *
FROM (oc_t_item_custom_attr_fields)
JOIN oc_t_item_custom_attr_meta ON fk_i_field_id = pk_i_id
WHERE fk_i_group_id = '20'
ORDER BY i_order ASC
0.015869855880737 SELECT oc_t_item.*, oc_t_item.s_contact_name as s_user_name
FROM (oc_t_item, oc_t_item_stats)
WHERE oc_t_item_stats.fk_i_item_id = oc_t_item.pk_i_id
AND oc_t_item.b_premium = 1
AND oc_t_item.b_enabled = 1
AND oc_t_item.b_active = 1
AND oc_t_item.b_spam = 0
AND oc_t_item.fk_i_category_id IN (237)
GROUP BY oc_t_item.pk_i_id
ORDER BY SUM(oc_t_item_stats.i_num_premium_views) ASC, RAND()
LIMIT 0, 9
0.001413106918335 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (467, '2022-05-16 07:35:36',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00096487998962402 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (303, '2022-05-16 07:35:36',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00053596496582031 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (304, '2022-05-16 07:35:36',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00043392181396484 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (340, '2022-05-16 07:35:36',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0004279613494873 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (276, '2022-05-16 07:35:36',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00038599967956543 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '467'
0.0022740364074707 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '467'
AND s.fk_i_item_id = '467'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00035285949707031 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '303'
0.0022380352020264 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '303'
AND s.fk_i_item_id = '303'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00037193298339844 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '304'
0.0020890235900879 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '304'
AND s.fk_i_item_id = '304'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00052118301391602 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '340'
0.0020999908447266 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '340'
AND s.fk_i_item_id = '340'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00033307075500488 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '276'
0.0018808841705322 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '276'
AND s.fk_i_item_id = '276'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00031495094299316 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 467
AND dt_expiration_date >= '2022-05-16 07:35:36'
0.00042891502380371 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 467
0.00031399726867676 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.00059199333190918 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=467
0.00027108192443848 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 303
AND dt_expiration_date >= '2022-05-16 07:35:36'
0.00037097930908203 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 303
0.00044894218444824 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=303
0.00028896331787109 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 304
AND dt_expiration_date >= '2022-05-16 07:35:36'
0.0003669261932373 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 304
0.00042295455932617 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=304
0.00030303001403809 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 340
AND dt_expiration_date >= '2022-05-16 07:35:36'
0.00035786628723145 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 340
0.00046396255493164 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=340
0.00028514862060547 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 276
AND dt_expiration_date >= '2022-05-16 07:35:36'
0.00040292739868164 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 276
0.00075507164001465 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=276
0.00028395652770996 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1150
AND dt_expiration_date >= '2022-05-16 07:35:36'
0.00035595893859863 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1150
0.00083017349243164 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=1150
0.00029587745666504 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1149
AND dt_expiration_date >= '2022-05-16 07:35:36'
0.00033998489379883 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1149
0.00075888633728027 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=1149
0.00026798248291016 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1148
AND dt_expiration_date >= '2022-05-16 07:35:36'
0.00034689903259277 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1148
0.0007939338684082 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=1148
0.00044488906860352 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1147
AND dt_expiration_date >= '2022-05-16 07:35:36'
0.00033020973205566 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1147
0.0007779598236084 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=1147
0.00026607513427734 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1146
AND dt_expiration_date >= '2022-05-16 07:35:36'
0.00034189224243164 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1146
0.00077390670776367 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=1146
0.00026702880859375 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1140
AND dt_expiration_date >= '2022-05-16 07:35:36'
0.00031113624572754 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1140
0.00075387954711914 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=1140
0.00029087066650391 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1082
AND dt_expiration_date >= '2022-05-16 07:35:36'
0.00037407875061035 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1082
0.000762939453125 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=1082
0.0002901554107666 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1081
AND dt_expiration_date >= '2022-05-16 07:35:36'
0.00034403800964355 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1081
0.00078511238098145 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=1081
0.00023412704467773 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1075
AND dt_expiration_date >= '2022-05-16 07:35:36'
0.00034379959106445 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1075
0.00075292587280273 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=1075
0.00027203559875488 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1073
AND dt_expiration_date >= '2022-05-16 07:35:36'
0.00031399726867676 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1073
0.00072002410888672 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=1073
0.00029516220092773 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1071
AND dt_expiration_date >= '2022-05-16 07:35:36'
0.00035715103149414 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1071
0.00072693824768066 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=1071
0.00028800964355469 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1069
AND dt_expiration_date >= '2022-05-16 07:35:36'
0.00034403800964355 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1069
0.00071811676025391 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=1069
0.00029993057250977 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_2'
0.00068116188049316 SELECT g.b_id as "b_group_id", g.b_name as "b_group_name", g.b_banner_id, b.*, rand() as "rand_ind"
FROM (oc_t_banner b, oc_t_banner_group g)
WHERE g.b_banner_id = b.b_id
AND g.b_id = 2
ORDER BY rand_ind asc
0.00029397010803223 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_2'
0.00030803680419922 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.0010440349578857 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00026297569274902 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_3'
0.00051403045654297 SELECT g.b_id as "b_group_id", g.b_name as "b_group_name", g.b_banner_id, b.*, rand() as "rand_ind"
FROM (oc_t_banner b, oc_t_banner_group g)
WHERE g.b_banner_id = b.b_id
AND g.b_id = 3
ORDER BY rand_ind asc
0.00027298927307129 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_3'
0.0003349781036377 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.0010218620300293 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00031280517578125 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_4'
0.00049304962158203 SELECT g.b_id as "b_group_id", g.b_name as "b_group_name", g.b_banner_id, b.*, rand() as "rand_ind"
FROM (oc_t_banner b, oc_t_banner_group g)
WHERE g.b_banner_id = b.b_id
AND g.b_id = 4
ORDER BY rand_ind asc
0.00029587745666504 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_4'
0.00032711029052734 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.00096297264099121 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00033092498779297 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC