Wyniki wyszukiwania - strona 30

Zawęź wyszukanie
Wyszukiwanie zaawansowane
Iconic Award-winning Meier New York Penthouse
29 950 000 $

Iconic Award-winning Meier New York Penthouse

450 m266555zł/m2
Obiekt - Mielno
26 000 000 zł

Obiekt - Mielno

1484 m217520zł/m2
Luksusowe mieszkanie w samym centrum Pruszkowa
315 000 zł

Luksusowe mieszkanie w samym centrum Pruszkowa

38,85 m28289zł/m2
Lokal na parterze koło Uniwersytetu i Słodowej
521 000 zł

Lokal na parterze koło Uniwersytetu i Słodowej

81 m26432zł/m2
Działka, 2 232 m², Mierzyn
299 000 zł

Działka, 2 232 m², Mierzyn

2232 m2133zł/m2
Mieszkanie Warszawa Śródmieście, Rondo Radosława, ul. Zygmunta Słomińskiego
1 560 000 zł

Mieszkanie Warszawa Śródmieście, Rondo Radosława, ul. Zygmunta Słomińskiego

143 m210909zł/m2
Zalesiany sprzedam, rolna działka
3 650 000 zł

Zalesiany sprzedam, rolna działka

73000 m250zł/m2
Mikołajki posiadłość sprzedam
995 000 zł

Mikołajki posiadłość sprzedam

200 m² m24975zł/m2

Do wynajęcia 2 pokojowe na Woli z dużym balkonem 15 m2!!!!

40 m2

929 ogłoszeń z kategorii: Polska

Hostel w topowej lokalizacji
1 400 000 zł

Hostel w topowej lokalizacji

171 m28187zł/m2
Okazja ! Super lokalizacja ! Duża działka !
2 510 000 zł

Okazja ! Super lokalizacja ! Duża działka !

2211 m21135zł/m2
Pod segmenty, ok 9300m2, Józefosław
5 400 000 zł

Pod segmenty, ok 9300m2, Józefosław

9300 m2580zł/m2
Działka, 14 000 m², Węgrzce
5 400 000 zł

Działka, 14 000 m², Węgrzce

14000 m2385zł/m2
Ul. Górna Wilda - lokal handlowo-usługowy
488 000 zł

Ul. Górna Wilda - lokal handlowo-usługowy

62.4 m27820zł/m2
Działka, 18 000 m², Bielsko-Biała
5 400 000 zł

Działka, 18 000 m², Bielsko-Biała

18000 m2300zł/m2
Nieruchomość Handlowo-Biurowa/ Hotel
6 100 000 zł

Nieruchomość Handlowo-Biurowa/ Hotel

3209.7 m21900zł/m2
Działka, 40 557 m², Konstantynów Łódzki
5 400 000 zł

Działka, 40 557 m², Konstantynów Łódzki

40557 m2133zł/m2
Lokal komercyjny - Warszawa Włochy
2 500 000 zł

Lokal komercyjny - Warszawa Włochy

1000 m22500zł/m2
Działka, 19 230 m², Słomczyn
5 400 000 zł

Działka, 19 230 m², Słomczyn

19230 m2280zł/m2
Lokal 135m2 Warszawa Mokotów pod inwestycję !!!!
1 280 000 zł

Lokal 135m2 Warszawa Mokotów pod inwestycję !!!!

135 m29481zł/m2
Działka, 8 712 m², Warszawa
5 401 440 zł

Działka, 8 712 m², Warszawa

8712 m2620zł/m2
  Database queries (Total queries: 149 - Total queries time: 0.14920425415039)  
0.001007080078125 SELECT *
FROM (oc_t_preference)
0.00073099136352539 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.00023818016052246 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.00022196769714355 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'page'
LIMIT 1
0.00025486946105957 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sCountry'
LIMIT 1
0.00019598007202148 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'iPage'
LIMIT 1
0.00019717216491699 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sShowAs'
LIMIT 1
0.004256010055542 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 >= '2025-04-21 06:59:31')
AND ( oc_t_item_location.fk_c_country_code = 'pl' )
ORDER BY dt_pub_date desc
LIMIT 348, 12
0.0062661170959473 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 >= '2025-04-21 06:59:31')
AND ( oc_t_item_location.fk_c_country_code = 'pl' )
ORDER BY dt_pub_date desc
LIMIT 1200000
0.0004119873046875 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '844'
0.00068497657775879 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 = '844'
AND s.fk_i_item_id = '844'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00041007995605469 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '843'
0.00063514709472656 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 = '843'
AND s.fk_i_item_id = '843'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00045180320739746 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '842'
0.00068902969360352 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 = '842'
AND s.fk_i_item_id = '842'
AND cd.fk_i_category_id = '238'
GROUP BY fk_i_item_id
0.00035500526428223 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '841'
0.00052595138549805 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 = '841'
AND s.fk_i_item_id = '841'
AND cd.fk_i_category_id = '238'
GROUP BY fk_i_item_id
0.00021195411682129 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '840'
0.00068116188049316 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 = '840'
AND s.fk_i_item_id = '840'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00036716461181641 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '839'
0.00064396858215332 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 = '839'
AND s.fk_i_item_id = '839'
AND cd.fk_i_category_id = '238'
GROUP BY fk_i_item_id
0.00038290023803711 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '838'
0.00061798095703125 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 = '838'
AND s.fk_i_item_id = '838'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00038003921508789 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '837'
0.00068116188049316 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 = '837'
AND s.fk_i_item_id = '837'
AND cd.fk_i_category_id = '238'
GROUP BY fk_i_item_id
0.00035905838012695 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '836'
0.00064802169799805 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 = '836'
AND s.fk_i_item_id = '836'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00039005279541016 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '835'
0.00053596496582031 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 = '835'
AND s.fk_i_item_id = '835'
AND cd.fk_i_category_id = '238'
GROUP BY fk_i_item_id
0.00040292739868164 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '834'
0.00063180923461914 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 = '834'
AND s.fk_i_item_id = '834'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00039505958557129 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '833'
0.00063800811767578 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 = '833'
AND s.fk_i_item_id = '833'
AND cd.fk_i_category_id = '238'
GROUP BY fk_i_item_id
0.00019693374633789 SELECT *
FROM (oc_t_country)
WHERE pk_c_code = 'PL'
0.00028300285339355 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.0009160041809082 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.00045895576477051 SELECT *
FROM (oc_t_banner)
WHERE b_id = '5'
0.0007319450378418 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=5
0.00025200843811035 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 a.fk_i_parent_id IS NULL
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.00024199485778809 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.00023698806762695 SELECT *
FROM (oc_t_country)
WHERE s_name = 'Polska'
0.00016188621520996 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
AND oc_t_region.fk_c_country_code = 'PL'
ORDER BY region_name ASC
0.00036287307739258 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.00023794174194336 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 a.fk_i_parent_id IS NULL
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.00024509429931641 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.00022101402282715 SELECT *
FROM (oc_t_country)
WHERE s_name = 'Polska'
0.053333044052124 SELECT oc_t_item.*, oc_t_item.s_contact_name as s_user_name
FROM (oc_t_item, oc_t_item_stats)
LEFT JOIN oc_t_item_location ON oc_t_item_location.fk_i_item_id = oc_t_item.pk_i_id
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_location.fk_c_country_code = 'pl' )
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.00083088874816895 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (308, '2025-04-21 06:59:31',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00044512748718262 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (481, '2025-04-21 06:59:31',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00040006637573242 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (329, '2025-04-21 06:59:31',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0003361701965332 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (306, '2025-04-21 06:59:31',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00037312507629395 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (1127, '2025-04-21 06:59:31',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00030088424682617 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (293, '2025-04-21 06:59:31',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0002439022064209 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (348, '2025-04-21 06:59:31',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00034880638122559 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (276, '2025-04-21 06:59:31',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00023508071899414 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (988, '2025-04-21 06:59:31',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
8.702278137207E-5 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '308'
0.0035829544067383 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 = '308'
AND s.fk_i_item_id = '308'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.0001978874206543 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '481'
0.0034999847412109 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 = '481'
AND s.fk_i_item_id = '481'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00010895729064941 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '329'
0.0032658576965332 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 = '329'
AND s.fk_i_item_id = '329'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00013399124145508 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '306'
0.0035638809204102 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 = '306'
AND s.fk_i_item_id = '306'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.0002138614654541 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1127'
0.0035529136657715 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 = '1127'
AND s.fk_i_item_id = '1127'
AND cd.fk_i_category_id = '238'
GROUP BY fk_i_item_id
0.00018501281738281 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '293'
0.0035009384155273 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 = '293'
AND s.fk_i_item_id = '293'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00015687942504883 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '348'
0.0035049915313721 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 = '348'
AND s.fk_i_item_id = '348'
AND cd.fk_i_category_id = '238'
GROUP BY fk_i_item_id
0.00018000602722168 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '276'
0.0031719207763672 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.00019502639770508 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '988'
0.0035278797149658 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 = '988'
AND s.fk_i_item_id = '988'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00032687187194824 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 308
AND dt_expiration_date >= '2025-04-21 06:59:31'
0.00019311904907227 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 308
0.0002739429473877 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'USD'
0.00020098686218262 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=308
0.00031113624572754 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 481
AND dt_expiration_date >= '2025-04-21 06:59:31'
0.00041985511779785 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 481
0.00023102760314941 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.0006260871887207 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=481
0.00029802322387695 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 329
AND dt_expiration_date >= '2025-04-21 06:59:31'
0.00019001960754395 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 329
0.00024104118347168 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=329
0.00035285949707031 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 306
AND dt_expiration_date >= '2025-04-21 06:59:31'
0.0002448558807373 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 306
0.00018715858459473 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=306
0.00029993057250977 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1127
AND dt_expiration_date >= '2025-04-21 06:59:31'
0.00019407272338867 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1127
0.00011682510375977 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=1127
0.0002748966217041 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 293
AND dt_expiration_date >= '2025-04-21 06:59:31'
0.00016307830810547 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 293
0.0002281665802002 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=293
0.00037693977355957 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 348
AND dt_expiration_date >= '2025-04-21 06:59:31'
0.00019216537475586 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 348
0.00021505355834961 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=348
0.00035190582275391 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 276
AND dt_expiration_date >= '2025-04-21 06:59:31'
0.00010514259338379 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 276
0.00021195411682129 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.00032711029052734 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 988
AND dt_expiration_date >= '2025-04-21 06:59:31'
0.00022006034851074 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 988
0.00013589859008789 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=988
0.00032997131347656 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 844
AND dt_expiration_date >= '2025-04-21 06:59:31'
0.00043797492980957 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 844
0.00082612037658691 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=844
0.00035691261291504 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 843
AND dt_expiration_date >= '2025-04-21 06:59:31'
0.00037598609924316 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 843
0.00066614151000977 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=843
0.00033903121948242 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 842
AND dt_expiration_date >= '2025-04-21 06:59:31'
0.00034189224243164 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 842
0.00070285797119141 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=842
0.00032615661621094 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 841
AND dt_expiration_date >= '2025-04-21 06:59:31'
0.00064396858215332 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 841
0.00078392028808594 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=841
0.00040698051452637 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 840
AND dt_expiration_date >= '2025-04-21 06:59:31'
0.0002131462097168 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 840
0.00074601173400879 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=840
0.00031876564025879 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 839
AND dt_expiration_date >= '2025-04-21 06:59:31'
0.00036382675170898 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 839
0.00081706047058105 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=839
0.00032591819763184 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 838
AND dt_expiration_date >= '2025-04-21 06:59:31'
0.00037813186645508 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 838
0.00073599815368652 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=838
0.00031805038452148 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 837
AND dt_expiration_date >= '2025-04-21 06:59:31'
0.00032496452331543 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 837
0.00078797340393066 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=837
0.0003969669342041 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 836
AND dt_expiration_date >= '2025-04-21 06:59:31'
0.00035405158996582 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 836
0.0007789134979248 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=836
0.00031590461730957 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 835
AND dt_expiration_date >= '2025-04-21 06:59:31'
0.00031900405883789 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 835
0.00081396102905273 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=835
0.00033903121948242 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 834
AND dt_expiration_date >= '2025-04-21 06:59:31'
0.00038886070251465 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 834
0.00072908401489258 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=834
0.0002601146697998 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 833
AND dt_expiration_date >= '2025-04-21 06:59:31'
0.00030899047851562 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 833
0.00075101852416992 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=833
0.00066709518432617 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.0004429817199707 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.00051021575927734 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00046491622924805 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.00042200088500977 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.00046110153198242 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00056791305541992 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.00036287307739258 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.00043702125549316 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00021100044250488 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC