Dzięki! Jest to bardzo pomocne!

NA sprzedaż obiekt magazyn. - prod. - handl. w Z-G

Hale i magazyny Zielona Góra, lubuskie, Polska
4 500 000 PLN brutto 3 658 537 PLN netto  
4 500 000 PLN brutto 3 658 537 PLN netto
  • 0

Pochodzenie oferty

Region lubuskie
Miasto Zielona Góra

Informacje o ogłoszeniu

Przeznaczenie lokalu magazyn
Rynek Wtórny
Ilość m2 3395
Rodzaj ogłoszenia Na sprzedaż

Konstrukcja murowana
Posadzka pylna

Informacje o budynku

Stan budynku bardzo dobry
Typ budynku hala

Media

internet Tak
kanalizacja Tak
prąd Tak
telefon Tak
woda Tak
gaz Tak
siła Tak

Zabezpieczenia

alarm Tak
monitoring Tak
ochrona Tak
teren zamknięty Tak

Opis

NA SPRZEDAŻ obiekt składający się z budynków o przeznaczeniu produkcyjno-usługowo-biurowo-handlowo-magazynowym położonych na działce o łącznej powierzchni 3300m2 w Zielonej Górze blisko centrum.

Nieruchomość składa się z:
1) Główny budynek: niepodpiwniczony, 4 kondygnacyjny z poddaszem użytkowym, z portiernią, z częścią biurową, z windą przemysłową, wykonany w technologii tradycyjnej. Możliwość wykorzystania budynku do celów produkcyjnych, handlowych, usługowych, spedycyjnych, magazynowych, biurowych, adaptacji pod lofty. Powierzchnia użytkowa: ok. 1 700m², powierzchnia działki: 567m².
2) budynek o przeznaczeniu magazynowo – usługowym, powierzchnia użytkowa: 392m², powierzchnia działki 330m²
3) budynek o przeznaczeniu produkcyjno-magazynowo-usługowym. Powierzchnia użytkowa: 162m², powierzchnia działki 162m²
4) dwa połączone budynki o przeznaczeniu produkcyjno-magazynowo-usługowym. Powierzchnia użytkowa: 252 + 141m², powierzchnia działki 252 + 141m²
5) 3 budynki połączone o przeznaczeniu produkcyjno-magazynowo-usługowo-handlowym połączone ze sobą z dostępem od wewnątrz placu oraz od gł. ulicy, o powierzchni użytkowej ok. 270m², powierzchnia działki ok. 270m²
6) 2 piętro budynku, o przeznaczeniu produkcyjno - magazynowo – usługowym, połączone z budynkiem głównym nr 1) oraz z osobnym wejściem i klatką schodową, powierzchnia użytkowa ok. 600m²
7) budynek magazynowy o powierzchni ok. 40m
8) plac o powierzchni ok. 1100m²
9) parking o powierzchni ok. 930m²

Dostępne media: woda, kanalizacja, prąd (siła), linia teleinformatyczna, gaz, ogrzewanie nowoczesnym piecem gazowym.

Przeznaczenie preferowane:
Podstawowe - Teren zabudowy produkcyjnej, bazy sprzętowo-transportowe, magazyny, składy, handel hurtowy,
Uzupełniające - obiekty socjalne, biurowe, handel detaliczny, usługi, stacje obsługi, stacje serwisowe, domy spokojnej starości, bazy szpitalne, uczelnie, akademiki, itp.

Forma własności: użytkowanie wieczyste gruntu oraz własność budynków.

Istnieje możliwość dołączenia do sprzedaży obiektu położonego obok ww budynków, o powierzchni użytkowej ok.600m², przeznaczonego do celów produkcyjno - magazynowo – usługowych.

Lokalizacja: nieruchomość położona blisko ścisłego centrum miasta (1,5km), przy jednej z głównych ulic. Obok osiedla mieszkaniowe, markety, firmy usługowo - produkcyjne, przystanki komunikacji miejskiej.

Cena sprzedaży: 4 500 000zł - DO NEGOCJACJI.

  Database queries (Total queries: 181 - Total queries time: 0.1018660068512)  
0.0015938282012939 SELECT *
FROM (oc_t_preference)
0.00087213516235352 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.00031900405883789 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.0013358592987061 SELECT l.*, i.*, SUM(s.i_num_views) AS i_num_views
FROM (oc_t_item i)
LEFT JOIN oc_t_item_location l ON l.fk_i_item_id = i.pk_i_id
LEFT JOIN oc_t_item_stats s ON i.pk_i_id = s.fk_i_item_id
WHERE i.pk_i_id = '634'
GROUP BY s.fk_i_item_id
0.0002140998840332 SELECT *
FROM (oc_t_item_description)
WHERE fk_i_item_id = '634'
0.0014069080352783 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_views) VALUES (634, '2025-08-04 16:29:30',1) ON DUPLICATE KEY UPDATE i_num_views = i_num_views + 1
0.00028204917907715 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = '33'
0.00018119812011719 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '33'
0.00023508071899414 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.00077104568481445 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 634
0.0002589225769043 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.00058293342590332 SELECT pk_i_id, fk_i_region_id, s_name, fk_c_country_code, b_active, s_slug
FROM (oc_t_city)
WHERE pk_i_id = '363559'
0.00047492980957031 SELECT pk_i_id, fk_c_country_code, s_name, b_active, s_slug
FROM (oc_t_region)
WHERE pk_i_id = '781806'
0.0006561279296875 SELECT *
FROM (oc_t_region)
WHERE s_name = 'lubuskie'
LIMIT 1
0.00063705444335938 SELECT pk_i_id, fk_i_region_id, s_name, fk_c_country_code, b_active, s_slug
FROM (oc_t_city)
WHERE s_name = 'Zielona Góra'
LIMIT 1
0.00032496452331543 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 = 'hale-i-magazyny'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
0.00025510787963867 SELECT pk_i_id, fk_i_region_id, s_name, fk_c_country_code, b_active, s_slug
FROM (oc_t_city)
WHERE s_name = 'Zielona Góra'
LIMIT 1
0.00025200843811035 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 33
0.00015807151794434 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '33'
0.00018405914306641 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 33
0.0001380443572998 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '33'
0.00020408630371094 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_6'
0.0011138916015625 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 = 6
ORDER BY rand_ind asc
0.00017809867858887 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_6'
0.00056219100952148 SELECT *
FROM (oc_t_banner)
WHERE b_id = '6'
0.0015711784362793 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=6
0.00029587745666504 SELECT COUNT(*) AS numrows
FROM (oc_t_plugin_category)
WHERE fk_i_category_id = 240
AND s_plugin_name = 'custom_attributes'
0.00017595291137695 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 = 240
ORDER BY oc_t_item_custom_attr_groups.order ASC
0.00027990341186523 SELECT fk_i_field_id
FROM (oc_t_item_custom_attr_meta)
0.00023102760314941 SELECT *
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id NOT IN ('3', '4', '5', '61', '120', '202', '8', '9', '10', '11', '12', '13', '21', '99', '14', '15', '17', '18', '20', '28', '29', '30', '31', '32', '33', '34', '35', '83', '84', '123', '125', '129', '184', '185', '186', '188', '192', '217', '219', '221', '222', '223', '36', '37', '38', '39', '41', '42', '43', '44', '45', '46', '47', '50', '51', '52', '53', '91', '98', '124', '130', '216', '218', '57', '58', '59', '60', '85', '121', '122', '147', '62', '63', '64', '65', '66', '67', '126', '70', '71', '78', '79', '80', '81', '82', '93', '94', '95', '97', '77', '86', '87', '89', '90', '159', '160', '161', '105', '107', '115', '131', '165', '109', '110', '112', '113', '114', '162', '206', '233', '116', '117', '118', '119', '195', '196', '197', '200', '128', '133', '134', '136', '137', '138', '139', '140', '141', '142', '143', '144', '151', '152', '153', '154', '155', '156', '157', '158', '163', '164', '235', '236', '237', '238', '171', '173', '174', '175', '203', '205', '224', '178', '181', '176', '187', '193', '194', '198', '199', '234', '207', '208', '209', '210', '211', '212', '213', '214', '215', '225', '226', '227', '228', '229', '230', '231')
ORDER BY i_order ASC
0.00026202201843262 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.00089216232299805 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '120'
LIMIT 1
0.0016748905181885 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '5'
LIMIT 1
0.00091695785522461 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '3'
LIMIT 1
0.00081992149353027 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '61'
LIMIT 1
0.00097393989562988 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '4'
LIMIT 1
0.00066804885864258 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '202'
LIMIT 1
0.00018596649169922 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '120'
LIMIT 1
0.00015401840209961 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '5'
LIMIT 1
0.00014495849609375 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '3'
LIMIT 1
0.0001380443572998 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '61'
LIMIT 1
0.00015616416931152 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '4'
LIMIT 1
0.00018906593322754 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '202'
LIMIT 1
0.00024199485778809 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 = '12'
ORDER BY i_order ASC
0.00076007843017578 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '105'
LIMIT 1
0.00069284439086914 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '107'
LIMIT 1
0.00071811676025391 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '115'
LIMIT 1
0.00065803527832031 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '131'
LIMIT 1
0.00069212913513184 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '165'
LIMIT 1
0.0002439022064209 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '105'
LIMIT 1
0.00015902519226074 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '107'
LIMIT 1
0.00014185905456543 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '115'
LIMIT 1
0.00013184547424316 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '131'
LIMIT 1
0.00013279914855957 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '165'
LIMIT 1
0.00016498565673828 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 = '7'
ORDER BY i_order ASC
0.00077104568481445 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '64'
LIMIT 1
0.00076580047607422 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '65'
LIMIT 1
0.00087380409240723 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '66'
LIMIT 1
0.00077104568481445 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '62'
LIMIT 1
0.00069189071655273 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '63'
LIMIT 1
0.00078296661376953 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '67'
LIMIT 1
0.0008690357208252 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '126'
LIMIT 1
0.00018191337585449 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '64'
LIMIT 1
0.00014305114746094 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '65'
LIMIT 1
0.00014400482177734 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '66'
LIMIT 1
0.00013303756713867 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '62'
LIMIT 1
0.00013208389282227 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '63'
LIMIT 1
0.00012993812561035 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '67'
LIMIT 1
0.00013899803161621 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '126'
LIMIT 1
0.00017094612121582 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 = '9'
ORDER BY i_order ASC
0.00083112716674805 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '78'
LIMIT 1
0.00071191787719727 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '79'
LIMIT 1
0.00065207481384277 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '80'
LIMIT 1
0.00071096420288086 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '81'
LIMIT 1
0.00076007843017578 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '82'
LIMIT 1
0.00088810920715332 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '93'
LIMIT 1
0.00092697143554688 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '94'
LIMIT 1
0.00076007843017578 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '95'
LIMIT 1
0.00069713592529297 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '97'
LIMIT 1
0.00016498565673828 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '78'
LIMIT 1
0.0001378059387207 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '79'
LIMIT 1
0.00014400482177734 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '80'
LIMIT 1
0.00013399124145508 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '81'
LIMIT 1
0.00013208389282227 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '82'
LIMIT 1
0.00013089179992676 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '93'
LIMIT 1
0.00013399124145508 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '94'
LIMIT 1
0.00013113021850586 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '95'
LIMIT 1
0.00012898445129395 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '97'
LIMIT 1
0.00016617774963379 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 = '21'
ORDER BY i_order ASC
0.0007469654083252 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '163'
LIMIT 1
0.00062203407287598 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '164'
LIMIT 1
0.00053095817565918 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '235'
LIMIT 1
0.00046896934509277 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '236'
LIMIT 1
0.00046396255493164 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '237'
LIMIT 1
0.00048303604125977 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '238'
LIMIT 1
0.00019502639770508 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.0009620189666748 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '77'
LIMIT 1
0.00078988075256348 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '159'
LIMIT 1
0.00087714195251465 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '87'
LIMIT 1
0.00084185600280762 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '86'
LIMIT 1
0.00098896026611328 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '90'
LIMIT 1
0.00078606605529785 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '161'
LIMIT 1
0.0010159015655518 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '89'
LIMIT 1
0.00086307525634766 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '160'
LIMIT 1
0.00026917457580566 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '77'
LIMIT 1
0.00016093254089355 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '159'
LIMIT 1
0.00016903877258301 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '87'
LIMIT 1
0.00014686584472656 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '86'
LIMIT 1
0.00014400482177734 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '90'
LIMIT 1
0.00013995170593262 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '161'
LIMIT 1
0.00014901161193848 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '89'
LIMIT 1
0.00013899803161621 SELECT s_value
FROM (oc_t_item_custom_attr_values)
WHERE fk_i_item_id = 634
AND fk_i_field_id = '160'
LIMIT 1
0.0017669200897217 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-04 16:29:30') AND oc_t_item.pk_i_id < 634
AND oc_t_item.fk_i_category_id IN (240)
AND ( oc_t_item_location.s_region LIKE 'lubuskie' )
ORDER BY dt_pub_date DESC
LIMIT 0, 9
0.0014379024505615 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-04 16:29:30') AND oc_t_item.pk_i_id < 634
AND oc_t_item.fk_i_category_id IN (240)
AND ( oc_t_item_location.s_region LIKE 'lubuskie' )
ORDER BY dt_pub_date DESC
LIMIT 900000
0.00071811676025391 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '583'
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 = '583'
AND s.fk_i_item_id = '583'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00073003768920898 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '522'
0.0010550022125244 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 = '522'
AND s.fk_i_item_id = '522'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.0013129711151123 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-04 16:29:30') AND oc_t_item.pk_i_id != 634
AND oc_t_item.fk_i_category_id IN (240)
ORDER BY dt_pub_date DESC
LIMIT 0, 9
0.0018110275268555 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-04 16:29:30') AND oc_t_item.pk_i_id != 634
AND oc_t_item.fk_i_category_id IN (240)
ORDER BY dt_pub_date DESC
LIMIT 900000
0.00022196769714355 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1190'
0.0022108554840088 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 = '1190'
AND s.fk_i_item_id = '1190'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00028896331787109 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1188'
0.001906156539917 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 = '1188'
AND s.fk_i_item_id = '1188'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00029802322387695 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1186'
0.0017819404602051 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 = '1186'
AND s.fk_i_item_id = '1186'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00028681755065918 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1184'
0.002216100692749 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 = '1184'
AND s.fk_i_item_id = '1184'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00025677680969238 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1182'
0.0018000602722168 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 = '1182'
AND s.fk_i_item_id = '1182'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00029516220092773 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1180'
0.0013000965118408 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 = '1180'
AND s.fk_i_item_id = '1180'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00019407272338867 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1178'
0.0012631416320801 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 = '1178'
AND s.fk_i_item_id = '1178'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00026297569274902 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1176'
0.0014450550079346 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 = '1176'
AND s.fk_i_item_id = '1176'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00026512145996094 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1174'
0.0022749900817871 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 = '1174'
AND s.fk_i_item_id = '1174'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00060486793518066 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1190
AND dt_expiration_date >= '2025-08-04 16:29:30'
0.00028204917907715 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1190
0.00029802322387695 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=1190
0.00047588348388672 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1188
AND dt_expiration_date >= '2025-08-04 16:29:30'
0.00021600723266602 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1188
0.0003049373626709 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=1188
0.00049090385437012 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1186
AND dt_expiration_date >= '2025-08-04 16:29:30'
0.00025010108947754 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1186
0.00027322769165039 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=1186
0.00054788589477539 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1184
AND dt_expiration_date >= '2025-08-04 16:29:30'
0.00027704238891602 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1184
0.00023794174194336 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=1184
0.00047492980957031 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1182
AND dt_expiration_date >= '2025-08-04 16:29:30'
0.00021004676818848 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1182
0.00027608871459961 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=1182
0.0004580020904541 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1180
AND dt_expiration_date >= '2025-08-04 16:29:30'
0.00016593933105469 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1180
0.00026488304138184 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=1180
0.00047707557678223 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1178
AND dt_expiration_date >= '2025-08-04 16:29:30'
0.0002448558807373 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1178
0.00027298927307129 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=1178
0.00047802925109863 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1176
AND dt_expiration_date >= '2025-08-04 16:29:30'
0.00024104118347168 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1176
0.00027799606323242 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=1176
0.00049686431884766 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1174
AND dt_expiration_date >= '2025-08-04 16:29:30'
0.00024580955505371 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1174
0.00026798248291016 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=1174
0.00024199485778809 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_2'
0.0010721683502197 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.00019693374633789 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_2'
0.00049686431884766 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.0013790130615234 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00018000602722168 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_3'
0.00093507766723633 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.00019097328186035 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_3'
0.0006248950958252 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.0010318756103516 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00020098686218262 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_4'
0.00093388557434082 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.00018191337585449 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_4'
0.00045204162597656 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.0012412071228027 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00024914741516113 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC