• 0

Wyniki wyszukiwania - strona 62

Zawęź wyszukanie
Wyszukiwanie zaawansowane
Lokal na parterze koło Uniwersytetu i Słodowej
521 000 zł

Lokal na parterze koło Uniwersytetu i Słodowej

81 m26432zł/m2
Mikołajki posiadłość sprzedam
995 000 zł

Mikołajki posiadłość sprzedam

200 m² m24975zł/m2
Energooszczędny Dom MDM Przy Lesie, ul. Osiedle Tygrysie Dachowa
289 000 zł

Energooszczędny Dom MDM Przy Lesie, ul. Osiedle Tygrysie Dachowa

99-230 m22919zł/m2
lokal biurowy na wynajem w Warszawa
7 000 zł

lokal biurowy na wynajem w Warszawa

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

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

104 m2
M2 Górna do wynajecia
1 040 zł

M2 Górna do wynajecia

39.96 m226zł/m2
Dom, 573 m², Warszawa
18 000 zł

Dom, 573 m², Warszawa

573 m231zł/m2
Tomaryny (Mazury Zach.) Leśniczówka + Stodoła + 0,5-3 Ha Działka
748 000 zł

Tomaryny (Mazury Zach.) Leśniczówka + Stodoła + 0,5-3 Ha Działka

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

Śródmieście, 2 pokoje, Kamienica

49 m211061zł/m2

929 ogłoszeń z kategorii: Polska

Dom, 14 203 m², Warszawa
29 600 000 zł

Dom, 14 203 m², Warszawa

14203 m22084zł/m2
Dom Warszawa Ursynów, Kabaty, ul. Villardczyków
2 249 000 zł

Dom Warszawa Ursynów, Kabaty, ul. Villardczyków

250 m28996zł/m2
Hala/Magazyn, 30 000 m², Katowice
58 000 000 zł

Hala/Magazyn, 30 000 m², Katowice

30000 m21933zł/m2
Dom Złotokłos, ul. Centrum
2 990 000 zł

Dom Złotokłos, ul. Centrum

430 m26953zł/m2
Garaż, Dąbrowa Tarnowska
480 000 zł

Garaż, Dąbrowa Tarnowska

425 m21129zł/m2
Na sprzedaż zabytkowa kamienica Plac Piłsudskiego.
12 000 000 €

Na sprzedaż zabytkowa kamienica Plac Piłsudskiego.

3800 m23157zł/m2
Dom Warszawa Ursynów, Rezerwat "Las Kabacki", ul. Tukana
3 900 000 zł

Dom Warszawa Ursynów, Rezerwat "Las Kabacki", ul. Tukana

264 m214772zł/m2
Dom Staszów
12 500 000 zł

Dom Staszów

1410 m28865zł/m2
Działka, 2 600 000 m², Suchy Róg
72 800 000 zł

Działka, 2 600 000 m², Suchy Róg

2600000 m228zł/m2
Hala/Magazyn, 25 500 m², Sosnowiec
45 900 000 zł

Hala/Magazyn, 25 500 m², Sosnowiec

25500 m21800zł/m2
Luksusowa rezydencja 1150 m2 Konstancin-Jeziorna
23 000 000 zł

Luksusowa rezydencja 1150 m2 Konstancin-Jeziorna

1150 m220000zł/m2
Dom Konstancin-Jeziorna, ul. Saneczkowa
3 590 000 zł

Dom Konstancin-Jeziorna, ul. Saneczkowa

300 m211966zł/m2
  Database queries (Total queries: 148 - Total queries time: 0.14715600013733)  
0.001025915145874 SELECT *
FROM (oc_t_preference)
0.0004880428314209 REPLACE INTO oc_t_preference (s_name, s_value, s_section, e_type) VALUES ('version', '121', 'radius_search', 'STRING')
0.00022006034851074 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.00014114379882812 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'page'
LIMIT 1
0.00010991096496582 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'sCountry'
LIMIT 1
9.4175338745117E-5 SELECT s_type
FROM (oc_t_item_custom_attr_fields)
WHERE pk_i_id = 'iPage'
LIMIT 1
0.0067968368530273 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-02-06 12:26:04')
AND ( oc_t_item_location.fk_c_country_code = 'pl' )
ORDER BY dt_pub_date desc
LIMIT 732, 12
0.0064411163330078 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-02-06 12:26:04')
AND ( oc_t_item_location.fk_c_country_code = 'pl' )
ORDER BY dt_pub_date desc
LIMIT 1200000
0.00034618377685547 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '462'
0.00054287910461426 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 = '462'
AND s.fk_i_item_id = '462'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00024104118347168 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '461'
0.00089502334594727 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 = '461'
AND s.fk_i_item_id = '461'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00025606155395508 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '460'
0.00047516822814941 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 = '460'
AND s.fk_i_item_id = '460'
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 = '459'
0.00042581558227539 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 = '459'
AND s.fk_i_item_id = '459'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00046586990356445 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '458'
0.0004580020904541 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 = '458'
AND s.fk_i_item_id = '458'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00028204917907715 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '457'
0.00052189826965332 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 = '457'
AND s.fk_i_item_id = '457'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00024294853210449 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '456'
0.00064301490783691 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 = '456'
AND s.fk_i_item_id = '456'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00024318695068359 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '455'
0.00041389465332031 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 = '455'
AND s.fk_i_item_id = '455'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00022983551025391 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '454'
0.00042080879211426 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 = '454'
AND s.fk_i_item_id = '454'
AND cd.fk_i_category_id = '238'
GROUP BY fk_i_item_id
0.00023412704467773 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '453'
0.00041103363037109 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 = '453'
AND s.fk_i_item_id = '453'
AND cd.fk_i_category_id = '240'
GROUP BY fk_i_item_id
0.00025105476379395 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '452'
0.00066494941711426 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 = '452'
AND s.fk_i_item_id = '452'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00025606155395508 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '451'
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 = '451'
AND s.fk_i_item_id = '451'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
6.9856643676758E-5 SELECT *
FROM (oc_t_country)
WHERE pk_c_code = 'PL'
0.00024104118347168 SELECT *
FROM (oc_t_locale)
WHERE b_enabled = 1
ORDER BY s_name ASC
0.00088095664978027 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.00039815902709961 SELECT *
FROM (oc_t_banner)
WHERE b_id = '5'
0.00067520141601562 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=5
0.00025200843811035 SELECT *
FROM ((SELECT a.*, b.*, c.i_num_items, FIELD(fk_c_locale_code, 'pl_PL') as locale_order
FROM (oc_t_category as a)
INNER JOIN oc_t_category_description as b ON a.pk_i_id = b.fk_i_category_id
LEFT JOIN oc_t_category_stats as c ON a.pk_i_id = c.fk_i_category_id
WHERE a.fk_i_parent_id IS NULL
AND a.b_enabled = '1'
AND b.s_name != ''
ORDER BY locale_order DESC) dummytable)
GROUP BY pk_i_id
ORDER BY i_position ASC
0.00044512748718262 SELECT oc_t_country_stats.fk_c_country_code as country_code, oc_t_country_stats.i_num_items as items, oc_t_country.s_name as country_name, oc_t_country.s_slug as country_slug
FROM (oc_t_country_stats)
JOIN oc_t_country ON oc_t_country_stats.fk_c_country_code = oc_t_country.pk_c_code
WHERE i_num_items > 0
ORDER BY country_name ASC
0.00023698806762695 SELECT *
FROM (oc_t_country)
WHERE s_name = 'Polska'
0.00020599365234375 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.00043511390686035 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.00019001960754395 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.00023889541625977 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.00024199485778809 SELECT *
FROM (oc_t_country)
WHERE s_name = 'Polska'
0.050519227981567 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.00090599060058594 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (306, '2025-02-06 12:26:05',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00054407119750977 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (276, '2025-02-06 12:26:05',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00049781799316406 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (303, '2025-02-06 12:26:05',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00051498413085938 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (346, '2025-02-06 12:26:05',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00054001808166504 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (277, '2025-02-06 12:26:05',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00050997734069824 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (337, '2025-02-06 12:26:05',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00058603286743164 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (340, '2025-02-06 12:26:05',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00047111511230469 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (304, '2025-02-06 12:26:05',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.0004730224609375 INSERT INTO oc_t_item_stats (fk_i_item_id, dt_date, i_num_premium_views) VALUES (311, '2025-02-06 12:26:05',1) ON DUPLICATE KEY UPDATE i_num_premium_views = i_num_premium_views + 1
0.00023388862609863 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '306'
0.0035979747772217 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '306'
AND s.fk_i_item_id = '306'
AND cd.fk_i_category_id = '239'
GROUP BY fk_i_item_id
0.00020098686218262 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '276'
0.0030498504638672 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '276'
AND s.fk_i_item_id = '276'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00022697448730469 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '303'
0.0036830902099609 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '303'
AND s.fk_i_item_id = '303'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00026488304138184 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '346'
0.00351881980896 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '346'
AND s.fk_i_item_id = '346'
AND cd.fk_i_category_id = '243'
GROUP BY fk_i_item_id
0.00025200843811035 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '277'
0.0035371780395508 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.00019288063049316 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '337'
0.0034279823303223 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 = '337'
AND s.fk_i_item_id = '337'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00015807151794434 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '340'
0.0033829212188721 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 = '340'
AND s.fk_i_item_id = '340'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00010991096496582 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '304'
0.0034780502319336 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 = '304'
AND s.fk_i_item_id = '304'
AND cd.fk_i_category_id = '237'
GROUP BY fk_i_item_id
0.00034999847412109 SELECT *
FROM (oc_t_item_description)
WHERE oc_t_item_description.fk_i_item_id = '311'
0.0033421516418457 SELECT oc_t_item_location.*, cd.s_name as s_category_name, SUM(`s`.`i_num_views`) as `i_num_views`, SUM(`s`.`i_num_spam`) as `i_num_spam`, SUM(`s`.`i_num_bad_classified`) as `i_num_bad_classified`, SUM(`s`.`i_num_repeated`) as `i_num_repeated`, SUM(`s`.`i_num_offensive`) as `i_num_offensive`, SUM(`s`.`i_num_expired`) as `i_num_expired`, SUM(`s`.`i_num_premium_views`) as `i_num_premium_views`
FROM (oc_t_item_location, oc_t_category_description as cd, oc_t_item_stats as s)
WHERE oc_t_item_location.fk_i_item_id = '311'
AND s.fk_i_item_id = '311'
AND cd.fk_i_category_id = '236'
GROUP BY fk_i_item_id
0.00033783912658691 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 306
AND dt_expiration_date >= '2025-02-06 12:26:05'
0.00014615058898926 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 306
0.00020480155944824 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'PLN'
0.0002291202545166 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=306
0.0003049373626709 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 276
AND dt_expiration_date >= '2025-02-06 12:26:05'
0.00012683868408203 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 276
0.00020194053649902 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=276
0.00030994415283203 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 303
AND dt_expiration_date >= '2025-02-06 12:26:05'
0.00014090538024902 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 303
0.00014305114746094 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=303
0.00026798248291016 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 346
AND dt_expiration_date >= '2025-02-06 12:26:05'
0.00023508071899414 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 346
0.00020909309387207 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=346
0.00035190582275391 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 277
AND dt_expiration_date >= '2025-02-06 12:26:05'
0.0002598762512207 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 277
0.0006110668182373 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.0003349781036377 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 337
AND dt_expiration_date >= '2025-02-06 12:26:05'
0.00023293495178223 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 337
0.00016999244689941 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=337
0.00033998489379883 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 340
AND dt_expiration_date >= '2025-02-06 12:26:05'
0.0002291202545166 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 340
0.00021791458129883 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=340
0.00031208992004395 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 304
AND dt_expiration_date >= '2025-02-06 12:26:05'
0.00020289421081543 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 304
0.00020503997802734 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=304
0.00032520294189453 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 311
AND dt_expiration_date >= '2025-02-06 12:26:05'
0.00038599967956543 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 311
0.00053000450134277 SELECT *
FROM (oc_t_item)
JOIN oc_t_item_custom_attr_values ON oc_t_item_custom_attr_values.fk_i_item_id=oc_t_item.pk_i_id AND oc_t_item_custom_attr_values.fk_i_field_id=3
WHERE oc_t_item.pk_i_id=311
0.00035309791564941 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 462
AND dt_expiration_date >= '2025-02-06 12:26:05'
0.00040388107299805 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 462
0.00068306922912598 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=462
0.00034713745117188 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 461
AND dt_expiration_date >= '2025-02-06 12:26:05'
0.00043296813964844 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 461
0.00058197975158691 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=461
0.00033903121948242 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 460
AND dt_expiration_date >= '2025-02-06 12:26:05'
0.00034403800964355 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 460
0.00064706802368164 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=460
0.00034403800964355 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 459
AND dt_expiration_date >= '2025-02-06 12:26:05'
0.00046205520629883 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 459
0.00059890747070312 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=459
0.00035500526428223 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 458
AND dt_expiration_date >= '2025-02-06 12:26:05'
0.00036096572875977 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 458
0.00059700012207031 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=458
0.00037097930908203 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 457
AND dt_expiration_date >= '2025-02-06 12:26:05'
0.00039482116699219 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 457
0.00016999244689941 SELECT pk_c_code, s_name, s_description, b_enabled
FROM (oc_t_currency)
WHERE pk_c_code = 'EUR'
0.0011129379272461 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=457
0.00026798248291016 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 456
AND dt_expiration_date >= '2025-02-06 12:26:05'
0.00039911270141602 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 456
0.00061893463134766 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=456
0.00037002563476562 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 455
AND dt_expiration_date >= '2025-02-06 12:26:05'
0.00039196014404297 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 455
0.00058388710021973 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=455
0.0002598762512207 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 454
AND dt_expiration_date >= '2025-02-06 12:26:05'
0.00040102005004883 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 454
0.00055718421936035 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=454
0.00037813186645508 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 453
AND dt_expiration_date >= '2025-02-06 12:26:05'
0.00044488906860352 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 453
0.00076389312744141 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=453
0.00029182434082031 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 452
AND dt_expiration_date >= '2025-02-06 12:26:05'
0.00040102005004883 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 452
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=452
0.00036811828613281 SELECT *
FROM (oc_t_payment_pro_highlight)
WHERE fk_i_item_id = 451
AND dt_expiration_date >= '2025-02-06 12:26:05'
0.00044012069702148 SELECT *
FROM (oc_t_item_resource)
WHERE fk_i_item_id = 451
0.00065302848815918 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=451
0.00067305564880371 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.00036811828613281 SELECT *
FROM (oc_t_banner)
WHERE b_id = '2'
0.0005638599395752 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=2
0.00078296661376953 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.00036191940307617 SELECT *
FROM (oc_t_banner)
WHERE b_id = '3'
0.00045204162597656 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=3
0.00055503845214844 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.00030207633972168 SELECT *
FROM (oc_t_banner)
WHERE b_id = '4'
0.00039196014404297 UPDATE oc_t_banner SET b_views=coalesce(b_views, 0)+1 WHERE b_id=4
9.1075897216797E-5 SELECT *
FROM (oc_t_pages)
WHERE b_indelible = 0
AND b_link = 1
ORDER BY i_order ASC