Wyniki wyszukiwania - strona 42

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

Iconic Award-winning Meier New York Penthouse

450 m266555zł/m2
Warszawa Żoliborz, ul. Gen. Józefa Zajączka
1 999 000 zł

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

122 m216385zł/m2
Obiekt - Mielno
26 000 000 zł

Obiekt - Mielno

1484 m217520zł/m2

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

40 m2
Luksusowe mieszkanie w samym centrum Pruszkowa
315 000 zł

Luksusowe mieszkanie w samym centrum Pruszkowa

38,85 m28289zł/m2
WYNAJMĘ LOKAL USŁUGOWY BEZ POŚREDNIKÓW/CENTRUM OŁTASZYN
2 000 zł

WYNAJMĘ LOKAL USŁUGOWY BEZ POŚREDNIKÓW/CENTRUM OŁTASZYN

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

Mieszkanie Warszawa Śródmieście, Powiśle

104 m2
Penthouse, Żoliborz, ul. Przasnyska
1 700 000 zł

Penthouse, Żoliborz, ul. Przasnyska

118,19 m214406zł/m2

929 ogłoszeń z kategorii: Polska

Restauracja W Sercu Bydgoszczy
5 540 725 zł

Restauracja W Sercu Bydgoszczy

651,85 m28511zł/m2
Hala/Magazyn, 1 293,70 m², Zielona Góra
4 200 000 zł

Hala/Magazyn, 1 293,70 m², Zielona Góra

1293.7 m23246zł/m2
Lokal użytkowy, 2 936 m², Częstochowa
10 000 000 zł

Lokal użytkowy, 2 936 m², Częstochowa

2936 m23405zł/m2
Hala/Magazyn, 3 100 m², Kraków
4 200 000 zł

Hala/Magazyn, 3 100 m², Kraków

3100 m21354zł/m2
Lokal użytkowy, 540 m², Sopot
10 000 000 zł

Lokal użytkowy, 540 m², Sopot

540 m218518zł/m2
Hala/Magazyn, 1 600 m², Niepruszewo
4 200 000 zł

Hala/Magazyn, 1 600 m², Niepruszewo

1600 m22625zł/m2
Lokal użytkowy, 1 600 m², Ustroń
10 000 000 zł

Lokal użytkowy, 1 600 m², Ustroń

1600 m26250zł/m2
Hala/Magazyn, 4 049 m², Lubartów
4 200 000 zł

Hala/Magazyn, 4 049 m², Lubartów

4049 m21037zł/m2
Lokal użytkowy, 820 m², Warszawa
10 000 000 zł

Lokal użytkowy, 820 m², Warszawa

820 m212195zł/m2
Hotel 860,04 m2, Baranówek
10 000 000 zł

Hotel 860,04 m2, Baranówek

860.04 m211627zł/m2
Hala/Magazyn, 1 362 m², Warszawa
4 200 000 zł

Hala/Magazyn, 1 362 m², Warszawa

1362 m23083zł/m2
Nowo wybudowany pawilon handlowy
10 000 000 zł

Nowo wybudowany pawilon handlowy

1000 m210000zł/m2
  Database queries (Total queries: 148 - Total queries time: 0.24591755867004)  
0.00097799301147461 SELECT *
FROM (oc_t_preference)
0.00070309638977051 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.00024986267089844 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.00018501281738281 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'page'
LIMIT 1
0.00045490264892578 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sCountry'
LIMIT 1
6.8902969360352E-5 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'iPage'
LIMIT 1
0.013093948364258 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 >= '2024-11-26 15:23:12')
AND ( oc_t_item_location.fk_c_country_code = 'pl' )
ORDER BY dt_pub_date desc
LIMIT 492, 12
0.0067539215087891 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 >= '2024-11-26 15:23:12')
AND ( oc_t_item_location.fk_c_country_code = 'pl' )
ORDER BY dt_pub_date desc
LIMIT 1200000
0.0067918300628662 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '701'
0.017271995544434 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 = '701'
AND s.fk_i_item_id = '701'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00044393539428711 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '700'
0.00069403648376465 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 = '700'
AND s.fk_i_item_id = '700'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.0045511722564697 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '699'
0.0088729858398438 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 = '699'
AND s.fk_i_item_id = '699'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00039100646972656 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '698'
0.0005800724029541 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 = '698'
AND s.fk_i_item_id = '698'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.007429838180542 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '697'
0.00055885314941406 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 = '697'
AND s.fk_i_item_id = '697'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00038599967956543 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '696'
0.00059890747070312 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 = '696'
AND s.fk_i_item_id = '696'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00038409233093262 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '695'
0.00057196617126465 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 = '695'
AND s.fk_i_item_id = '695'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00037312507629395 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '694'
0.0092880725860596 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 = '694'
AND s.fk_i_item_id = '694'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00041913986206055 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '693'
0.00058984756469727 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 = '693'
AND s.fk_i_item_id = '693'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00038599967956543 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '692'
0.00056195259094238 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 = '692'
AND s.fk_i_item_id = '692'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00042200088500977 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '691'
0.00049400329589844 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 = '691'
AND s.fk_i_item_id = '691'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00049495697021484 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '690'
0.00054597854614258 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 = '690'
AND s.fk_i_item_id = '690'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.0003659725189209 SELECT *
FROM (oc_t_country)
WHERE pk_c_code = 'PL'
0.00025081634521484 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.00093317031860352 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.00032901763916016 SELECT *
FROM (oc_t_banner)
WHERE b_id = '5'
0.00094509124755859 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=5
0.00022315979003906 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.00026297569274902 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.0092039108276367 SELECT *
FROM (oc_t_country)
WHERE s_name = 'Polska'
0.0062570571899414 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.00036191940307617 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.00026106834411621 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.00023007392883301 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.00022196769714355 SELECT *
FROM (oc_t_country)
WHERE s_name = 'Polska'
0.049201965332031 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.0011858940124512 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (308, '2024-11-26 15:23:12',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00058984756469727 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (295, '2024-11-26 15:23:12',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0009150505065918 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (481, '2024-11-26 15:23:12',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00053501129150391 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (988, '2024-11-26 15:23:12',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00048589706420898 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (329, '2024-11-26 15:23:12',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00047588348388672 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (347, '2024-11-26 15:23:12',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00041389465332031 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (300, '2024-11-26 15:23:12',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00046396255493164 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (277, '2024-11-26 15:23:12',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00037097930908203 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (297, '2024-11-26 15:23:12',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00048398971557617 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '308'
0.003291130065918 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '308'
AND s.fk_i_item_id = '308'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00033092498779297 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '295'
0.0031619071960449 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.00038313865661621 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '481'
0.0032279491424561 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '481'
AND s.fk_i_item_id = '481'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.0003960132598877 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '988'
0.0032250881195068 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '988'
AND s.fk_i_item_id = '988'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.0004570484161377 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '329'
0.0031888484954834 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '329'
AND s.fk_i_item_id = '329'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00031304359436035 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '347'
0.0030910968780518 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 = '347'
AND s.fk_i_item_id = '347'
AND cd.fk_i_category_id = '243'
GROUP BY fk_i_item_id
0.00034689903259277 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '300'
0.0032298564910889 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.0003969669342041 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '277'
0.0032331943511963 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 = '277'
AND s.fk_i_item_id = '277'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00036406517028809 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '297'
0.003385066986084 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 = '297'
AND s.fk_i_item_id = '297'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00037384033203125 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 308
AND dt_expiration_date >= '2024-11-26 15:23:12'
0.00046396255493164 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 308
0.0003669261932373 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'USD'
0.00058603286743164 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=308
0.00033211708068848 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 295
AND dt_expiration_date >= '2024-11-26 15:23:12'
0.0078771114349365 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 295
0.00026106834411621 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.00050997734069824 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.0003509521484375 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 481
AND dt_expiration_date >= '2024-11-26 15:23:12'
0.00044703483581543 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 481
0.00062894821166992 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=481
0.00040984153747559 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 988
AND dt_expiration_date >= '2024-11-26 15:23:12'
0.0044269561767578 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 988
0.0060219764709473 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=988
0.00035285949707031 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 329
AND dt_expiration_date >= '2024-11-26 15:23:12'
0.00038504600524902 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 329
0.00052690505981445 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=329
0.00035810470581055 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 347
AND dt_expiration_date >= '2024-11-26 15:23:12'
0.00037407875061035 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 347
0.00046682357788086 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=347
0.00035500526428223 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 300
AND dt_expiration_date >= '2024-11-26 15:23:12'
0.00037813186645508 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 300
0.00055193901062012 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.00034999847412109 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 277
AND dt_expiration_date >= '2024-11-26 15:23:12'
0.00041890144348145 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 277
0.00050091743469238 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=277
0.00024819374084473 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 297
AND dt_expiration_date >= '2024-11-26 15:23:12'
0.00034618377685547 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 297
0.0005190372467041 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=297
0.00025105476379395 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 701
AND dt_expiration_date >= '2024-11-26 15:23:12'
0.0053110122680664 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 701
0.0006561279296875 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=701
0.00027298927307129 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 700
AND dt_expiration_date >= '2024-11-26 15:23:12'
0.0003509521484375 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 700
0.00058603286743164 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=700
0.00022602081298828 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 699
AND dt_expiration_date >= '2024-11-26 15:23:12'
0.00033187866210938 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 699
0.00059795379638672 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=699
0.00022411346435547 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 698
AND dt_expiration_date >= '2024-11-26 15:23:12'
0.0002288818359375 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 698
0.00054407119750977 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=698
0.00018811225891113 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 697
AND dt_expiration_date >= '2024-11-26 15:23:12'
0.00030398368835449 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 697
0.00050997734069824 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=697
0.00017690658569336 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 696
AND dt_expiration_date >= '2024-11-26 15:23:12'
0.00028610229492188 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 696
0.00068902969360352 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=696
0.00029492378234863 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 695
AND dt_expiration_date >= '2024-11-26 15:23:12'
0.0003209114074707 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 695
0.00063419342041016 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=695
0.0003049373626709 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 694
AND dt_expiration_date >= '2024-11-26 15:23:12'
0.00033211708068848 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 694
0.00060796737670898 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=694
0.00027990341186523 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 693
AND dt_expiration_date >= '2024-11-26 15:23:12'
0.00038886070251465 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 693
0.00061917304992676 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=693
0.0003201961517334 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 692
AND dt_expiration_date >= '2024-11-26 15:23:12'
0.00035309791564941 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 692
0.0005800724029541 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=692
0.00030517578125 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 691
AND dt_expiration_date >= '2024-11-26 15:23:12'
0.00035905838012695 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 691
0.00056695938110352 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=691
0.00025200843811035 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 690
AND dt_expiration_date >= '2024-11-26 15:23:12'
0.00032901763916016 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 690
0.00063991546630859 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=690
0.00062179565429688 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.00043392181396484 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.00073599815368652 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00050806999206543 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.00030899047851562 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.00033879280090332 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00056219100952148 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.00032997131347656 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.00089812278747559 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
0.00018692016601562 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC