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.085978269577026)  
0.0015230178833008 SELECT *
FROM (oc_t_preference)
0.00078797340393066 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.0001981258392334 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.0017619132995605 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.00022292137145996 SELECT *
FROM (oc_t_item_description)
WHERE fk_i_item_id = '634'
0.0016670227050781 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_views) VALUES (634, '2025-07-13 23:43:40',1) ON DUPLICATE KEY UPDATE i_num_views = i_num_views + 1
0.00072193145751953 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = '33'
0.0002439022064209 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '33'
0.0005800724029541 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.00040102005004883 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 634
0.00027203559875488 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.0001978874206543 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.00017786026000977 SELECT pk_i_id, fk_c_country_code, s_name, b_active, s_slug
FROM (oc_t_region)
WHERE pk_i_id = '781806'
0.00023889541625977 SELECT *
FROM (oc_t_region)
WHERE s_name = 'lubuskie'
LIMIT 1
0.001086950302124 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.0014338493347168 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.00023913383483887 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.00065398216247559 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 33
0.00014019012451172 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '33'
0.00015401840209961 SELECT *
FROM (oc_t_user)
WHERE pk_i_id = 33
0.00011610984802246 SELECT *
FROM (oc_t_user_description)
WHERE fk_i_user_id = '33'
0.00024700164794922 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_6'
0.0011489391326904 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.00018000602722168 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_6'
0.0005347728729248 SELECT *
FROM (oc_t_banner)
WHERE b_id = '6'
0.0011930465698242 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=6
0.00022101402282715 SELECT COUNT(*) AS numrows
FROM (oc_t_plugin_category)
WHERE fk_i_category_id = 240
AND s_plugin_name = 'custom_attributes'
0.0001370906829834 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.00018095970153809 SELECT fk_i_field_id
FROM (oc_t_item_custom_attr_meta)
0.00023889541625977 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.00023007392883301 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.0009768009185791 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.00084304809570312 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.00077295303344727 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.00069212913513184 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.00082278251647949 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.0005791187286377 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.00013995170593262 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.00011587142944336 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.00011515617370605 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.00010800361633301 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.00010800361633301 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.00010299682617188 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.00011801719665527 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.00056791305541992 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.00053286552429199 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.00059604644775391 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.0005180835723877 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.00053596496582031 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.00016093254089355 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.00012683868408203 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.00011706352233887 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.00011396408081055 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.00011205673217773 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.00017285346984863 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.00058698654174805 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.0005500316619873 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.00059199333190918 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.00057196617126465 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.0005500316619873 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.0005948543548584 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.00056099891662598 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.00013899803161621 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.00011801719665527 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.00013208389282227 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.00011396408081055 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.00011205673217773 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.00012803077697754 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.00011396408081055 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.00013279914855957 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.00069999694824219 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.00052785873413086 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.00047492980957031 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.00042581558227539 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.00039100646972656 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.00040411949157715 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.00014781951904297 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.00071501731872559 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.0006561279296875 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.00061416625976562 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.00068402290344238 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.00057196617126465 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.00067591667175293 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.00063300132751465 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.00061607360839844 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.00061297416687012 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.00014400482177734 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.00012302398681641 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.00011205673217773 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.00011205673217773 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.00011110305786133 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.00010800361633301 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.00011491775512695 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.00010919570922852 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.0001070499420166 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.00012779235839844 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.0006721019744873 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.00051307678222656 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.00070905685424805 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.00068402290344238 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.00075888633728027 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.00057101249694824 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.00082612037658691 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.00060606002807617 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.00026702880859375 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.00015497207641602 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.00013899803161621 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.00015783309936523 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.00013399124145508 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.00013089179992676 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.00013184547424316 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.00014901161193848 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.0018761157989502 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-07-13 23:43:40') 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.0012810230255127 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-07-13 23:43:40') 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.00025677680969238 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '583'
0.00095105171203613 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.00019192695617676 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '522'
0.00092101097106934 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.00091695785522461 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-07-13 23:43:40') 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.0012450218200684 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-07-13 23:43:40') 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.00018000602722168 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1190'
0.001539945602417 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.00019979476928711 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1188'
0.0013401508331299 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.00017094612121582 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1186'
0.0011780261993408 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.0001981258392334 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1184'
0.0014970302581787 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.0002748966217041 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1182'
0.0012190341949463 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.0002140998840332 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1180'
0.0009009838104248 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.00020790100097656 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1178'
0.00084090232849121 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.0001518726348877 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1176'
0.00093317031860352 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.00017786026000977 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '1174'
0.0014579296112061 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.00047016143798828 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1190
AND dt_expiration_date >= '2025-07-13 23:43:40'
0.00016093254089355 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1190
0.00023388862609863 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.00052595138549805 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1188
AND dt_expiration_date >= '2025-07-13 23:43:40'
0.00016593933105469 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1188
0.00032496452331543 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.00045204162597656 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1186
AND dt_expiration_date >= '2025-07-13 23:43:40'
0.00015592575073242 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1186
0.0002589225769043 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.00046014785766602 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1184
AND dt_expiration_date >= '2025-07-13 23:43:40'
0.00016093254089355 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1184
0.00025486946105957 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.00049400329589844 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1182
AND dt_expiration_date >= '2025-07-13 23:43:41'
0.00015497207641602 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1182
0.00025796890258789 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.00059103965759277 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1180
AND dt_expiration_date >= '2025-07-13 23:43:41'
0.00020694732666016 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1180
0.00024914741516113 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.0006558895111084 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1178
AND dt_expiration_date >= '2025-07-13 23:43:41'
0.00018000602722168 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1178
0.00026893615722656 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.00051617622375488 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1176
AND dt_expiration_date >= '2025-07-13 23:43:41'
0.00017714500427246 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1176
0.0002591609954834 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.00048089027404785 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 1174
AND dt_expiration_date >= '2025-07-13 23:43:41'
0.00017714500427246 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 1174
0.00024509429931641 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.00024294853210449 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_2'
0.0010569095611572 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.00016403198242188 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_2'
0.0004878044128418 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.0013082027435303 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00022387504577637 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_3'
0.00091886520385742 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.00017809867858887 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_3'
0.00046396255493164 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.0012490749359131 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00021004676818848 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_group_4'
0.00081205368041992 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.00017309188842773 SELECT fk_i_category_id
FROM (oc_t_plugin_category)
WHERE s_plugin_name = 'ads_manager_banner_4'
0.00046396255493164 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.0011289119720459 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00023293495178223 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC