Wyniki wyszukiwania - strona 17

Zawęź wyszukanie
Wyszukiwanie zaawansowane
Praga-Południe, Saska Kępa, ul. Nowaka-Jeziorańskiego
2 099 000 zł

Praga-Południe, Saska Kępa, ul. Nowaka-Jeziorańskiego

140,15 m214992zł/m2
Działka, 2 232 m², Mierzyn
299 000 zł

Działka, 2 232 m², Mierzyn

2232 m2133zł/m2
Śródmieście, 2 pokoje, Kamienica
542 000 zł

Śródmieście, 2 pokoje, Kamienica

49 m211061zł/m2
lokal biurowy na wynajem w Warszawa
7 000 zł

lokal biurowy na wynajem w Warszawa

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
Zalesiany sprzedam, rolna działka
3 650 000 zł

Zalesiany sprzedam, rolna działka

73000 m250zł/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
Warszawa Żoliborz, ul. Gen. Józefa Zajączka
1 999 000 zł

Warszawa Żoliborz, ul. Gen. Józefa Zajączka

122 m216385zł/m2
Mieszkanie, 66,60 m², Gdynia
449 000 zł

Mieszkanie, 66,60 m², Gdynia

66.6 m26741zł/m2

929 ogłoszeń z kategorii: Polska

Obiekt produkc.-magazyn. 608 m2. Działka 2600m2 By
695 000 zł

Obiekt produkc.-magazyn. 608 m2. Działka 2600m2 By

608 m21143zł/m2
Garaż, Wrocław, ul. Zachodnia
30 000 zł

Garaż, Wrocław, ul. Zachodnia

15.7 m21910zł/m2
Hala/Magazyn, 680 m², Warszawa
2 500 000 zł

Hala/Magazyn, 680 m², Warszawa

680 m23676zł/m2
Garaż, Reda
50 000 zł

Garaż, Reda

24 m22083zł/m2
Hala/Magazyn, 2 954 m², Poznań
7 295 000 zł

Hala/Magazyn, 2 954 m², Poznań

2954 m22469zł/m2
Skierniewice, ul. Wschodnia
16 867 zł

Skierniewice, ul. Wschodnia

16.86 m21000zł/m2
Hala/Magazyn, 185,85 m², Szczecin
799 000 zł

Hala/Magazyn, 185,85 m², Szczecin

185.85 m24299zł/m2
Garaż, Lubin, Żurawia
25 000 zł

Garaż, Lubin, Żurawia

17.6 m21420zł/m2
Hala produkcyjno-magazynowa, 2750m2 z biurami
4 500 000 zł

Hala produkcyjno-magazynowa, 2750m2 z biurami

2750 m21636zł/m2
Garaż Głuchołazy, ul. Szymanowskiego
25 000 zł

Garaż Głuchołazy, ul. Szymanowskiego

15 m21666zł/m2
Kompleks biurowo-magazynowy- możliwy AUTOSERWIS
2 290 000 zł

Kompleks biurowo-magazynowy- możliwy AUTOSERWIS

606 m23778zł/m2
M-ce postojowe w garażu podziemnym, Prądnik Biały
28 000 zł

M-ce postojowe w garażu podziemnym, Prądnik Biały

17.52 m21598zł/m2
  Database queries (Total queries: 147 - Total queries time: 0.24202513694763)  
0.0017950534820557 SELECT *
FROM (oc_t_preference)
0.001060962677002 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.00031614303588867 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.00027203559875488 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'page'
LIMIT 1
0.00020694732666016 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sCountry'
LIMIT 1
0.00023603439331055 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'iPage'
LIMIT 1
0.0050671100616455 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-08-05 04:33:26')
AND ( oc_t_item_location.fk_c_country_code = 'pl' )
ORDER BY dt_pub_date desc
LIMIT 192, 12
0.0084779262542725 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-08-05 04:33:26')
AND ( oc_t_item_location.fk_c_country_code = 'pl' )
ORDER BY dt_pub_date desc
LIMIT 1200000
0.00071620941162109 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1000'
0.0011518001556396 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 = '1000'
AND s.fk_i_item_id = '1000'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00060200691223145 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '999'
0.0010900497436523 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 = '999'
AND s.fk_i_item_id = '999'
AND cd.fk_i_category_id = '241'
GROUP BY fk_i_item_id
0.00059413909912109 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '998'
0.0010430812835693 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 = '998'
AND s.fk_i_item_id = '998'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00054287910461426 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '997'
0.0018608570098877 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 = '997'
AND s.fk_i_item_id = '997'
AND cd.fk_i_category_id = '241'
GROUP BY fk_i_item_id
0.00054502487182617 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '996'
0.0010988712310791 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 = '996'
AND s.fk_i_item_id = '996'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.0005500316619873 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '995'
0.0013620853424072 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 = '995'
AND s.fk_i_item_id = '995'
AND cd.fk_i_category_id = '241'
GROUP BY fk_i_item_id
0.0005340576171875 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '994'
0.0012221336364746 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 = '994'
AND s.fk_i_item_id = '994'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00059103965759277 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '993'
0.0014898777008057 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 = '993'
AND s.fk_i_item_id = '993'
AND cd.fk_i_category_id = '241'
GROUP BY fk_i_item_id
0.00063204765319824 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '992'
0.0010948181152344 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 = '992'
AND s.fk_i_item_id = '992'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00057792663574219 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '991'
0.0017049312591553 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 = '991'
AND s.fk_i_item_id = '991'
AND cd.fk_i_category_id = '241'
GROUP BY fk_i_item_id
0.00058603286743164 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '990'
0.0011351108551025 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 = '990'
AND s.fk_i_item_id = '990'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00064396858215332 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '989'
0.001176118850708 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 = '989'
AND s.fk_i_item_id = '989'
AND cd.fk_i_category_id = '241'
GROUP BY fk_i_item_id
0.00033187866210938 SELECT *
FROM (oc_t_country)
WHERE pk_c_code = 'PL'
0.00038909912109375 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.0015859603881836 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.00069093704223633 SELECT *
FROM (oc_t_banner)
WHERE b_id = '5'
0.0015690326690674 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=5
0.00031089782714844 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.00039505958557129 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.00025701522827148 SELECT *
FROM (oc_t_country)
WHERE s_name = 'Polska'
0.00098586082458496 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.0003960132598877 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.00030207633972168 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.00029993057250977 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.00026798248291016 SELECT *
FROM (oc_t_country)
WHERE s_name = 'Polska'
0.068060874938965 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.0021710395812988 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (300, '2025-08-05 04:33:26',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.001227855682373 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (1127, '2025-08-05 04:33:26',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0011880397796631 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (311, '2025-08-05 04:33:26',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0010738372802734 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (346, '2025-08-05 04:33:26',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0011758804321289 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (303, '2025-08-05 04:33:26',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0011751651763916 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (348, '2025-08-05 04:33:26',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0012509822845459 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (293, '2025-08-05 04:33:26',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0011270046234131 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (295, '2025-08-05 04:33:26',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0011730194091797 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (357, '2025-08-05 04:33:26',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00036191940307617 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '300'
0.0058221817016602 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 = '300'
AND s.fk_i_item_id = '300'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00026082992553711 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1127'
0.0055539608001709 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.00025200843811035 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '311'
0.0058810710906982 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 = '311'
AND s.fk_i_item_id = '311'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00026798248291016 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '346'
0.0056028366088867 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 = '346'
AND s.fk_i_item_id = '346'
AND cd.fk_i_category_id = '243'
GROUP BY fk_i_item_id
0.00029110908508301 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '303'
0.0057551860809326 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.00028204917907715 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '348'
0.0054478645324707 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.00023698806762695 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '293'
0.0059311389923096 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.00018787384033203 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '295'
0.0054759979248047 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 = '295'
AND s.fk_i_item_id = '295'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00023913383483887 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '357'
0.0053200721740723 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 = '357'
AND s.fk_i_item_id = '357'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00059413909912109 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 300
AND dt_expiration_date >= '2025-08-05 04:33:27'
0.00075793266296387 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 300
0.00026297569274902 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.0011348724365234 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=300
0.00061416625976562 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1127
AND dt_expiration_date >= '2025-08-05 04:33:27'
0.00063109397888184 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1127
0.0014469623565674 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.00062084197998047 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 311
AND dt_expiration_date >= '2025-08-05 04:33:27'
0.00020480155944824 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 311
0.00028610229492188 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=311
0.0006561279296875 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 346
AND dt_expiration_date >= '2025-08-05 04:33:27'
0.00070285797119141 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 346
0.00084590911865234 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=346
0.00058913230895996 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 303
AND dt_expiration_date >= '2025-08-05 04:33:27'
0.00029611587524414 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 303
0.00098109245300293 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.00059199333190918 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 348
AND dt_expiration_date >= '2025-08-05 04:33:27'
0.00023484230041504 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 348
0.00029301643371582 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.00056600570678711 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 293
AND dt_expiration_date >= '2025-08-05 04:33:27'
0.00028681755065918 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 293
0.00028896331787109 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.00058507919311523 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 295
AND dt_expiration_date >= '2025-08-05 04:33:27'
0.00081086158752441 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 295
0.0010380744934082 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=295
0.00060796737670898 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 357
AND dt_expiration_date >= '2025-08-05 04:33:27'
0.00030899047851562 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 357
0.00030303001403809 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=357
0.0005800724029541 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1000
AND dt_expiration_date >= '2025-08-05 04:33:27'
0.00072002410888672 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1000
0.0029089450836182 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=1000
0.00063109397888184 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 999
AND dt_expiration_date >= '2025-08-05 04:33:27'
0.00067496299743652 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 999
0.0014050006866455 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=999
0.00060510635375977 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 998
AND dt_expiration_date >= '2025-08-05 04:33:27'
0.00072312355041504 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 998
0.001413106918335 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=998
0.00058197975158691 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 997
AND dt_expiration_date >= '2025-08-05 04:33:27'
0.00069689750671387 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 997
0.0014231204986572 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=997
0.00062108039855957 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 996
AND dt_expiration_date >= '2025-08-05 04:33:27'
0.00073480606079102 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 996
0.0019659996032715 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=996
0.0005958080291748 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 995
AND dt_expiration_date >= '2025-08-05 04:33:27'
0.00060915946960449 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 995
0.0016229152679443 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=995
0.0012211799621582 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 994
AND dt_expiration_date >= '2025-08-05 04:33:27'
0.00071597099304199 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 994
0.0015079975128174 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=994
0.00057601928710938 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 993
AND dt_expiration_date >= '2025-08-05 04:33:27'
0.00075697898864746 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 993
0.0014739036560059 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=993
0.00055193901062012 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 992
AND dt_expiration_date >= '2025-08-05 04:33:27'
0.00061202049255371 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 992
0.0013248920440674 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=992
0.0006411075592041 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 991
AND dt_expiration_date >= '2025-08-05 04:33:27'
0.00065493583679199 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 991
0.0013461112976074 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=991
0.00060200691223145 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 990
AND dt_expiration_date >= '2025-08-05 04:33:27'
0.00060510635375977 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 990
0.0013740062713623 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=990
0.00057005882263184 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 989
AND dt_expiration_date >= '2025-08-05 04:33:27'
0.0006859302520752 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 989
0.0013828277587891 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=989
0.0011618137359619 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.00068187713623047 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.0016298294067383 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.0010600090026855 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.00061893463134766 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.0013020038604736 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.0010800361633301 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.00062298774719238 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.0013668537139893 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00029087066650391 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC