1. Total Exec : 1679384103898.9 ms
2 .Total Exec : 1679384103901 ms
2.Total Exec : 1679384103907.3 ms
3. Total Exec : 1679384103907.5 ms
4. Total Exec : 1679384103907.6 ms
5. Total Exec : 1679384103907.7 ms
6. Total Exec : 1679384103914.8 ms
Cavalli Baio scuro in vendita | Equirodi Italia
Chiudere

Cavalli Baio scuro in vendita (66 annunci)

Filtro +

Ricerca

Tipo di cavallo

Regione

Prezzo

Più

IN VETRINA - Annunci cavalli in vendita

AQPS - Castrone - 6 anni

Bouches-du-Rhône (Francia)

10 000 € / 15 000 €

Purosangue - Castrone - 3 anni

Yvelines (Francia)

4 000 €

Sella Francese - Fattrice - 16 anni

Moselle (Francia)

10 000 €

Cavallo baio 9 anni bravissimo in campo e in passeggiat

5 500 €

1 / 3
Vendo bellissimo cavallo castrone baio di 9 anni. 100% razza irlandese, altezza al garrese circa 1,70 mt, sano e molto tranquillo. Bravissimo e...
  • Cavalli in vendita
  • Razza : Cavallo da Sport Irlandese
  • Sesso : Castrone
  • Colore : Baio scuro
  • Età : 10 anni
Italy.png Italia Vercelli Privato
20 / 03 / 2023
Réf : 786270

Giumenta esclusiva.

6 450 € (Prezzo da discutere)

1 / 3
Buongiorno a tutti. Giumenta esclusiva, 1,64 cm. È molto amichevole e intelligente. Va d'accordo anche con altri...
  • Cavalli in vendita
  • Razza : Cavallo da Sport Ungherese
  • Sesso : Cavalla
  • Colore : Baio scuro
  • Età : 7 anni
Hungary.png Ungheria Privato
27 / 02 / 2023
Réf : 780932

Vendo cavalla da dressage

30 000 € (Prezzo da discutere)

1 / 4
Bella fattrice con potenziale, in allenamento di dressage. 3 andature molto buone. Un cavallo dinamico con potenziale. Paddock. Salutare. Facile da...
  • Cavalli in vendita
  • Razza : Cavallo da Sport Germano
  • Sesso : Cavalla
  • Colore : Baio scuro
  • Età : 7 anni
Poland.png Polonia Privato
23 / 02 / 2023
Réf : 780692

Cavallo da salto ostacoli

1 / 2
Vendesi S.I. femmina anno 2014, baio, h168, figlia di Landor S x Sandro. Curriculum in categorie fino alle C140, indicata per il 1^ grado e...
  • Cavalli in vendita
  • Razza : Cavallo da Sella Italiano
  • Sesso : Cavalla
  • Colore : Baio scuro
  • Età : 9 anni
Italy.png Italia Catania Privato
18 / 01 / 2023
Réf : 771934

Larima - cavallo da salto 130

15 000 €

Eccezionale cavallina da salto, addestrata perfettamente per gare fino a 130. Importante genealogia documentata. Per cortesia contatatemi...
  • Cavalli in vendita
  • Razza : Holsteiner
  • Sesso : Cavalla
  • Colore : Baio scuro
  • Età : 14 anni
  • Taglia : 168 cm
Italy.png Italia Padova Privato
16 / 01 / 2023
Réf : 748097

Cavalla super top in vendita

(Su richiesta)

1 / 6
Spartacus x Indoctro femmina del 2012 ha vinto di tutto,ha saltato gare internazionali 135/140 con risultati super.. cavalla dal cuore...
  • Cavalli in vendita
  • Razza : Oldenburger
  • Sesso : Cavalla
  • Colore : Baio scuro
  • Età : 11 anni
Italy.png Italia Palermo Privato
30 / 12 / 2022
Réf : 768235

Femmina 2012 stakkatol x continue

1 €

1 / 4
STAKKEZZA, stupenda cavalla di qualità e mezzi. Altezza 169 cm. Fine da montare, facile sui salti. Esperienza fino a 135...
  • Cavalli in vendita
  • Razza : Oldenburger
  • Sesso : Cavalla
  • Colore : Baio scuro
  • Età : 11 anni
Italy.png Italia Monza e Brianza Privato
27 / 12 / 2022
Réf : 767835

Cavalla kwpn di 10 anni

5 000 € / 7 000 € (Prezzo da discutere)

1 / 6
Bella cavalla KWPN olandese, età 10 anni, buona genealogia con documenti, domata a monta inglese, educata elegante, andature ampie ed...
  • Cavalli in vendita
  • Razza : KWPN Cavallo da Sport Neerlandese
  • Sesso : Cavalla
  • Colore : Baio scuro
  • Età : 11 anni
  • Taglia : 163 cm
Italy.png Italia Venezia Privato
26 / 08 / 2022
Réf : 731133

Casall 7 yo

30 000 € / 50 000 € (Prezzo da discutere)

1 / 3
Ottima genealogia, attualmente impegnata in gare addestrative dedicate alla normale tabella di crescita (7 anni stagione 2022/2023). Cavalla con...
  • Cavalli in vendita
  • Razza : Holsteiner
  • Per : CASALL
  • Sesso : Cavalla
  • Colore : Baio scuro
  • Età : 7 anni
  • Taglia : 168 cm
Italy.png Italia Pisa Privato
05 / 05 / 2022
Réf : 712411

Cavallo santo stefano "allround"

10 000 € / 15 000 € (Prezzo da discutere)

1 / 3
Cavallo da altissima genealogia tedesca (Holstein/Hanover) con passaporto italiano, S.I. Adatto per salto ostacoli e dressage. Elegante,...
  • Cavalli in vendita
  • Razza : Cavallo da Sport Germano
  • Per : Corde Santo Stefano
  • Sesso : Stallone
  • Colore : Baio scuro
  • Età : 15 anni
  • Taglia : 163 cm
Italy.png Italia Pesaro e Urbino
04 / 02 / 2016
Réf : 259507

Lusitano in vendita 2020 baio scuro , guadalquivir phm

18 000 €

1 / 11
Quozak du Dojo, un puledro che avrà 3 anni a maggio, baio marrone, intero, 1m67, con molta forza e una mente molto buona. Avrà un'altezza superiore...
  • Cavalli in vendita
  • Razza : Lusitano
  • Per : GUADALQUIVIR PHM
  • Sesso : Intero
  • Colore : Baio scuro
  • Età : 3 anni
  • Taglia : 167 cm
France.png Francia Ardèche Professionista
20 / 03 / 2023
Réf : 777621

Kwpn cavallo da sport neerlandese in vendita 2012 baio scuro , roi du soleil

7 000 €

Bellissima puledra di 11 anni, di ottimo aspetto in vendita, figlia del re del sole e madre beyonce di Painted Black, non può raggiungere il...
  • Cavalli in vendita
  • Razza : KWPN Cavallo da Sport Neerlandese
  • Per : roi du soleil
  • Sesso : Cavalla
  • Colore : Baio scuro
  • Età : 11 anni
  • Taglia : 161 cm
France.png Francia Maine-et-Loire Professionista
20 / 03 / 2023
Réf : 781579

Pre andaluso in vendita 2019 baio scuro , zalamero xl

16 000 €

1 / 5
Jonsnow è un bellissimo e piccante maschio PRE di 4 anni nato nell'allevamento di Gressac. Jonsnow ha gambe e ossa superbe, una bella...
  • Cavalli in vendita
  • Razza : PRE Andaluso
  • Per : ZALAMERO XL
  • Sesso : Castrone
  • Colore : Baio scuro
  • Età : 4 anni
France.png Francia Gard Professionista249735_20190318120849.png
20 / 03 / 2023
Réf : 781410

Sella francese in vendita 2022 baio scuro

7 000 €

1 / 3
In vendita Filly del 2022 Da giovani de la pomme x quick star Gestito Aggiornato su tutto Telaio e...
  • Cavalli in vendita
  • Razza : Sella Francese
  • Sesso : Puledra
  • Colore : Baio scuro
  • Età : Foal
France.png Francia Moselle Professionista
20 / 03 / 2023
Réf : 776717

Kwpn cavallo da sport neerlandese in vendita 2011 baio scuro , eldorado van de zeshoek

20 000 €

1 / 4
Impact è uno stallone KWPN tardivo, estremamente ben educato e facile da cavalcare. Ha un ottimo pedigree (160 di rendimento da entrambi i...
  • Cavalli in vendita
  • Razza : KWPN Cavallo da Sport Neerlandese
  • Per : Eldorado van de zeshoek
  • Sesso : Intero
  • Colore : Baio scuro
  • Età : 12 anni
  • Taglia : 170 cm
France.png Francia Rhône Privato
20 / 03 / 2023
Réf : 774366

Sella francese in vendita 2011 baio scuro

20 000 €

1 / 3
Brigano Merze castrone di 12 anni Baia scura 1m66 Sella francese Da Olimbos Merze (Kannan) e da Le condeen Bel cavallo, molto ben...
  • Cavalli in vendita
  • Razza : Sella Francese
  • Sesso : Castrone
  • Colore : Baio scuro
  • Età : 12 anni
  • Taglia : 166 cm
France.png Francia Yvelines Privato
20 / 03 / 2023
Réf : 771565

Zangersheide in vendita 2011 baio scuro

14 000 € (Prezzo da discutere)

1 / 11
  • Cavalli in vendita
  • Razza : Zangersheide
  • Sesso : Castrone
  • Colore : Baio scuro
  • Età : 12 anni
France.png Francia Essonne Privato
20 / 03 / 2023
Réf : 782575

Sella francese in vendita 2022 baio scuro , quel homme de hus

12 000 € (Fare un'offerta)

1 / 10
MIO GRADILIS è una combinazione del sangue dell'indicibile QUEL HOMME DE HUS (QUIDAM DE REVEL) e di OPIUM DE TALMA (CARTHAGO) su una...
  • Cavalli in vendita
  • Razza : Sella Francese
  • Per : Quel homme de Hus
  • Sesso : Puledro
  • Colore : Baio scuro
  • Età : Foal
  • Taglia : 135 cm
France.png Francia Hérault Professionista
20 / 03 / 2023
Réf : 777093

Altre razze di cavalli in vendita 2019 baio scuro

5 000 €

1 / 4
Vendo un cavallo molto bello, JEROBOAM DE LACOSTE, castrone baio marrone, 1,55 cm, ideale per club o amatori, estremamente bello, rodato, va ai 3...
  • Cavalli in vendita
  • Razza : Altre Razze di Cavalli
  • Sesso : Castrone
  • Colore : Baio scuro
  • Età : 4 anni
France.png Francia Gironde Professionista
20 / 03 / 2023
Réf : 757648
Ricevi i nuovi annunci per la tua ricerca

66 annunci di cavalli trovati per Cavalli Baio scuro in vendita. Guarda gli annunci di Cavalli Baio scuro in vendita e compra un cavallo su equirodi.it. un cavallo da vendere ? Pubblica il tuo annuncio in qualche minuto qui



_______________________________________________________________
connect
0.97393989562988 ms

_______________________________________________________________
SELECT distinct members.id_members, account_url FROM members LEFT JOIN members_has_packages_pro_new ON members_has_packages_pro_new.id_members = members.id_members WHERE account_url != '' AND members_has_packages_pro_new.status = 1
0.49614906311035 ms

_______________________________________________________________
SELECT `colors`.`id_colors` FROM `colors` WHERE (name_colors = '{#color_8#}')
0.25582313537598 ms

_______________________________________________________________
SELECT id_colors, name_colors FROM colors WHERE id_colors IN ('8')
0.25105476379395 ms

_______________________________________________________________
SELECT `sites_partners_has_types_ads`.`id_sites_partners` FROM `sites_partners_has_types_ads` WHERE (id_types_ads = "13")
0.2448558807373 ms

_______________________________________________________________
SELECT DISTINCT countries.flag, name_pricelist, a.title, a.id_members, a.lang,lat,lon,a.addate, a.date_active, a.photo as photo_0, a.total_photos, a.total_videos, a.option_8 as option_frame, a.option_9 as option_highlight,a.option_11 as option_urgent, `ah`.`id_ad`, `ah`.`yearofbirth`, `ah`.`sire`, `ah`.`price`, `ah`.`price2`,`prl`.`price1` as `interval_min`, `prl`.`price2` AS `interval_max`, `hs`.`name_horse_sex`,`b`.`name_breed`,`c`.`name_colors`, `sl`.`name_stallions_list`,`tt`.`name_types_transactions`, p.name_packages,s.currency_text,name_country,name_department,code_department, members_status.name_members_status, members.photo, members.account_url, a.adpostcode, a.adcity, hh.value as height, hu.name_height_units as height_unit, al.description, coalesce(least(`ah`.`price`, `ah`.`price2`, `prl`.`price1`, `prl`.`price2`), `ah`.`price`, `ah`.`price2`, `prl`.`price1`, `prl`.`price2`) as compare_price FROM `ad_horses` AS `ah` JOIN `ads` AS `a` ON ah.id_ad = a.id_ad AND ah.id_types_equines = 1 AND a.id_types_ads = 13 AND a.id_status IN(101,201,301) AND deleted = 0 LEFT OUTER JOIN `breeds` AS `b` ON ah.id_breeds = b.id_breeds LEFT OUTER JOIN `prices_range_list` AS `prl` ON ah.id_prices_range_list = prl.id_prices_range_list LEFT OUTER JOIN `horse_sex` AS `hs` ON ah.id_horse_sex = hs.id_horse_sex LEFT OUTER JOIN `colors` AS `c` ON ah.id_colors = c.id_colors LEFT OUTER JOIN `types_transactions` AS `tt` ON ah.id_types_transactions = tt.id_types_transactions LEFT OUTER JOIN `sites` AS `s` ON a.id_sites = s.id_sites LEFT OUTER JOIN `packages` AS `p` ON a.id_packages = p.id_packages LEFT OUTER JOIN `departments` ON a.id_departments = departments.id_departments LEFT OUTER JOIN `countries` ON a.id_countries = countries.id_countries LEFT OUTER JOIN members ON a.id_members = members.id_members LEFT OUTER JOIN members_status ON members.id_members_status = members_status.id_members_status LEFT OUTER JOIN horse_height AS hh ON ah.id_horse_height = hh.id_horse_height LEFT OUTER JOIN pricelist AS pl ON ah.id_pricelist = pl.id_pricelist LEFT OUTER JOIN height_units AS hu ON hh.id_height_units = hu.id_height_units LEFT OUTER JOIN ads_langage AS al ON ah.id_ad = al.id_ad and al.id_langages=6 LEFT OUTER JOIN `stallions_list` AS `sl` ON ah.id_stallions_list = sl.id_stallions_list WHERE ( a.id_sites = 7 OR a.option_19 = 1 ) AND (a.id_sites_partners = 1 OR (a.id_sites_partners IN (1,3) AND a.option_14 = 1 )) AND (ah.id_colors = 8 ) ORDER BY (NULLIF(a.id_sites, 7)), a.addate DESC LIMIT 0,19
23.025035858154 ms

_______________________________________________________________
SELECT DISTINCT ah.id_ad, members.id_members_status, a.option_6, a.option_11, a.id_status, members.id_members, members.organizationname, members.firstname, substring( members.lastname, 1, 1 ) AS lastname, members.city, members.postcode, coalesce(least(`ah`.`price`, `ah`.`price2`, `prl`.`price1`, `prl`.`price2`),`ah`.`price`, `ah`.`price2`, `prl`.`price1`, `prl`.`price2`) as compare_price FROM `ad_horses` AS `ah` JOIN `ads` AS `a` ON ah.id_ad = a.id_ad AND ah.id_types_equines = 1 AND a.id_types_ads = 13 AND a.id_status IN(101,201,301) AND deleted = 0 LEFT OUTER JOIN `breeds` AS `b` ON ah.id_breeds = b.id_breeds LEFT OUTER JOIN `prices_range_list` AS `prl` ON ah.id_prices_range_list = prl.id_prices_range_list LEFT OUTER JOIN `horse_sex` AS `hs` ON ah.id_horse_sex = hs.id_horse_sex LEFT OUTER JOIN `colors` AS `c` ON ah.id_colors = c.id_colors LEFT OUTER JOIN `types_transactions` AS `tt` ON ah.id_types_transactions = tt.id_types_transactions LEFT OUTER JOIN `sites` AS `s` ON a.id_sites = s.id_sites LEFT OUTER JOIN `packages` AS `p` ON a.id_packages = p.id_packages LEFT OUTER JOIN `departments` ON a.id_departments = departments.id_departments LEFT OUTER JOIN `countries` ON a.id_countries = countries.id_countries LEFT OUTER JOIN members ON a.id_members = members.id_members LEFT OUTER JOIN members_status ON members.id_members_status = members_status.id_members_status LEFT OUTER JOIN horse_height AS hh ON ah.id_horse_height = hh.id_horse_height LEFT OUTER JOIN pricelist AS pl ON ah.id_pricelist = pl.id_pricelist LEFT OUTER JOIN height_units AS hu ON hh.id_height_units = hu.id_height_units LEFT OUTER JOIN ads_langage AS al ON ah.id_ad = al.id_ad and al.id_langages=6 LEFT OUTER JOIN `stallions_list` AS `sl` ON ah.id_stallions_list = sl.id_stallions_list WHERE ( a.id_sites = 7 OR a.option_19 = 1 ) AND (a.id_sites_partners = 1 OR (a.id_sites_partners IN (1,3) AND a.option_14 = 1 )) AND (ah.id_colors = 8 )
15.082120895386 ms

_______________________________________________________________
SELECT `ads`.`lang` FROM `ads` WHERE (id_ad = 777621)
0.13589859008789 ms

_______________________________________________________________
SELECT breeds.name_breed AS breed, tt.name_types_transactions AS transaction, colors.name_colors AS color, ah.yearofbirth, sl.name_stallions_list AS stallion, hs.name_horse_sex AS sex, ah.yearofbirth, d.name_department AS dpt, cou.name_country AS country, counties.name_county AS county FROM ad_horses AS ah LEFT JOIN horse_sex AS hs ON ah.id_horse_sex = hs.id_horse_sex LEFT JOIN breeds ON ah.id_breeds = breeds.id_breeds LEFT JOIN types_transactions AS tt ON ah.id_types_transactions = tt.id_types_transactions LEFT JOIN colors ON ah.id_colors = colors.id_colors LEFT JOIN stallions_list AS sl ON ah.id_stallions_list = sl.id_stallions_list LEFT JOIN ads ON ah.id_ad = ads.id_ad LEFT OUTER JOIN departments AS d ON ads.id_departments = d.id_departments LEFT JOIN countries AS cou ON cou.id_countries = ads.id_countries LEFT OUTER JOIN counties AS counties ON counties.id_counties = d.id_counties WHERE ah.id_ad = 777621
1.2009143829346 ms

_______________________________________________________________
SELECT `ads`.`lang` FROM `ads` WHERE (id_ad = 781579)
0.17499923706055 ms

_______________________________________________________________
SELECT breeds.name_breed AS breed, tt.name_types_transactions AS transaction, colors.name_colors AS color, ah.yearofbirth, sl.name_stallions_list AS stallion, hs.name_horse_sex AS sex, ah.yearofbirth, d.name_department AS dpt, cou.name_country AS country, counties.name_county AS county FROM ad_horses AS ah LEFT JOIN horse_sex AS hs ON ah.id_horse_sex = hs.id_horse_sex LEFT JOIN breeds ON ah.id_breeds = breeds.id_breeds LEFT JOIN types_transactions AS tt ON ah.id_types_transactions = tt.id_types_transactions LEFT JOIN colors ON ah.id_colors = colors.id_colors LEFT JOIN stallions_list AS sl ON ah.id_stallions_list = sl.id_stallions_list LEFT JOIN ads ON ah.id_ad = ads.id_ad LEFT OUTER JOIN departments AS d ON ads.id_departments = d.id_departments LEFT JOIN countries AS cou ON cou.id_countries = ads.id_countries LEFT OUTER JOIN counties AS counties ON counties.id_counties = d.id_counties WHERE ah.id_ad = 781579
0.99587440490723 ms

_______________________________________________________________
SELECT `ads`.`lang` FROM `ads` WHERE (id_ad = 781410)
0.14781951904297 ms

_______________________________________________________________
SELECT breeds.name_breed AS breed, tt.name_types_transactions AS transaction, colors.name_colors AS color, ah.yearofbirth, sl.name_stallions_list AS stallion, hs.name_horse_sex AS sex, ah.yearofbirth, d.name_department AS dpt, cou.name_country AS country, counties.name_county AS county FROM ad_horses AS ah LEFT JOIN horse_sex AS hs ON ah.id_horse_sex = hs.id_horse_sex LEFT JOIN breeds ON ah.id_breeds = breeds.id_breeds LEFT JOIN types_transactions AS tt ON ah.id_types_transactions = tt.id_types_transactions LEFT JOIN colors ON ah.id_colors = colors.id_colors LEFT JOIN stallions_list AS sl ON ah.id_stallions_list = sl.id_stallions_list LEFT JOIN ads ON ah.id_ad = ads.id_ad LEFT OUTER JOIN departments AS d ON ads.id_departments = d.id_departments LEFT JOIN countries AS cou ON cou.id_countries = ads.id_countries LEFT OUTER JOIN counties AS counties ON counties.id_counties = d.id_counties WHERE ah.id_ad = 781410
0.3058910369873 ms

_______________________________________________________________
SELECT `ads`.`lang` FROM `ads` WHERE (id_ad = 776717)
0.12302398681641 ms

_______________________________________________________________
SELECT breeds.name_breed AS breed, tt.name_types_transactions AS transaction, colors.name_colors AS color, ah.yearofbirth, sl.name_stallions_list AS stallion, hs.name_horse_sex AS sex, ah.yearofbirth, d.name_department AS dpt, cou.name_country AS country, counties.name_county AS county FROM ad_horses AS ah LEFT JOIN horse_sex AS hs ON ah.id_horse_sex = hs.id_horse_sex LEFT JOIN breeds ON ah.id_breeds = breeds.id_breeds LEFT JOIN types_transactions AS tt ON ah.id_types_transactions = tt.id_types_transactions LEFT JOIN colors ON ah.id_colors = colors.id_colors LEFT JOIN stallions_list AS sl ON ah.id_stallions_list = sl.id_stallions_list LEFT JOIN ads ON ah.id_ad = ads.id_ad LEFT OUTER JOIN departments AS d ON ads.id_departments = d.id_departments LEFT JOIN countries AS cou ON cou.id_countries = ads.id_countries LEFT OUTER JOIN counties AS counties ON counties.id_counties = d.id_counties WHERE ah.id_ad = 776717
0.28395652770996 ms

_______________________________________________________________
SELECT `ads`.`lang` FROM `ads` WHERE (id_ad = 774366)
0.12302398681641 ms

_______________________________________________________________
SELECT breeds.name_breed AS breed, tt.name_types_transactions AS transaction, colors.name_colors AS color, ah.yearofbirth, sl.name_stallions_list AS stallion, hs.name_horse_sex AS sex, ah.yearofbirth, d.name_department AS dpt, cou.name_country AS country, counties.name_county AS county FROM ad_horses AS ah LEFT JOIN horse_sex AS hs ON ah.id_horse_sex = hs.id_horse_sex LEFT JOIN breeds ON ah.id_breeds = breeds.id_breeds LEFT JOIN types_transactions AS tt ON ah.id_types_transactions = tt.id_types_transactions LEFT JOIN colors ON ah.id_colors = colors.id_colors LEFT JOIN stallions_list AS sl ON ah.id_stallions_list = sl.id_stallions_list LEFT JOIN ads ON ah.id_ad = ads.id_ad LEFT OUTER JOIN departments AS d ON ads.id_departments = d.id_departments LEFT JOIN countries AS cou ON cou.id_countries = ads.id_countries LEFT OUTER JOIN counties AS counties ON counties.id_counties = d.id_counties WHERE ah.id_ad = 774366
0.29110908508301 ms

_______________________________________________________________
SELECT `ads`.`lang` FROM `ads` WHERE (id_ad = 771565)
0.12493133544922 ms

_______________________________________________________________
SELECT breeds.name_breed AS breed, tt.name_types_transactions AS transaction, colors.name_colors AS color, ah.yearofbirth, sl.name_stallions_list AS stallion, hs.name_horse_sex AS sex, ah.yearofbirth, d.name_department AS dpt, cou.name_country AS country, counties.name_county AS county FROM ad_horses AS ah LEFT JOIN horse_sex AS hs ON ah.id_horse_sex = hs.id_horse_sex LEFT JOIN breeds ON ah.id_breeds = breeds.id_breeds LEFT JOIN types_transactions AS tt ON ah.id_types_transactions = tt.id_types_transactions LEFT JOIN colors ON ah.id_colors = colors.id_colors LEFT JOIN stallions_list AS sl ON ah.id_stallions_list = sl.id_stallions_list LEFT JOIN ads ON ah.id_ad = ads.id_ad LEFT OUTER JOIN departments AS d ON ads.id_departments = d.id_departments LEFT JOIN countries AS cou ON cou.id_countries = ads.id_countries LEFT OUTER JOIN counties AS counties ON counties.id_counties = d.id_counties WHERE ah.id_ad = 771565
0.28181076049805 ms

_______________________________________________________________
SELECT `ads`.`lang` FROM `ads` WHERE (id_ad = 782575)
0.12087821960449 ms

_______________________________________________________________
SELECT breeds.name_breed AS breed, tt.name_types_transactions AS transaction, colors.name_colors AS color, ah.yearofbirth, sl.name_stallions_list AS stallion, hs.name_horse_sex AS sex, ah.yearofbirth, d.name_department AS dpt, cou.name_country AS country, counties.name_county AS county FROM ad_horses AS ah LEFT JOIN horse_sex AS hs ON ah.id_horse_sex = hs.id_horse_sex LEFT JOIN breeds ON ah.id_breeds = breeds.id_breeds LEFT JOIN types_transactions AS tt ON ah.id_types_transactions = tt.id_types_transactions LEFT JOIN colors ON ah.id_colors = colors.id_colors LEFT JOIN stallions_list AS sl ON ah.id_stallions_list = sl.id_stallions_list LEFT JOIN ads ON ah.id_ad = ads.id_ad LEFT OUTER JOIN departments AS d ON ads.id_departments = d.id_departments LEFT JOIN countries AS cou ON cou.id_countries = ads.id_countries LEFT OUTER JOIN counties AS counties ON counties.id_counties = d.id_counties WHERE ah.id_ad = 782575
0.29397010803223 ms

_______________________________________________________________
SELECT `ads`.`lang` FROM `ads` WHERE (id_ad = 777093)
0.12707710266113 ms

_______________________________________________________________
SELECT breeds.name_breed AS breed, tt.name_types_transactions AS transaction, colors.name_colors AS color, ah.yearofbirth, sl.name_stallions_list AS stallion, hs.name_horse_sex AS sex, ah.yearofbirth, d.name_department AS dpt, cou.name_country AS country, counties.name_county AS county FROM ad_horses AS ah LEFT JOIN horse_sex AS hs ON ah.id_horse_sex = hs.id_horse_sex LEFT JOIN breeds ON ah.id_breeds = breeds.id_breeds LEFT JOIN types_transactions AS tt ON ah.id_types_transactions = tt.id_types_transactions LEFT JOIN colors ON ah.id_colors = colors.id_colors LEFT JOIN stallions_list AS sl ON ah.id_stallions_list = sl.id_stallions_list LEFT JOIN ads ON ah.id_ad = ads.id_ad LEFT OUTER JOIN departments AS d ON ads.id_departments = d.id_departments LEFT JOIN countries AS cou ON cou.id_countries = ads.id_countries LEFT OUTER JOIN counties AS counties ON counties.id_counties = d.id_counties WHERE ah.id_ad = 777093
0.29110908508301 ms

_______________________________________________________________
SELECT `ads`.`lang` FROM `ads` WHERE (id_ad = 757648)
0.08082389831543 ms

_______________________________________________________________
SELECT breeds.name_breed AS breed, tt.name_types_transactions AS transaction, colors.name_colors AS color, ah.yearofbirth, sl.name_stallions_list AS stallion, hs.name_horse_sex AS sex, ah.yearofbirth, d.name_department AS dpt, cou.name_country AS country, counties.name_county AS county FROM ad_horses AS ah LEFT JOIN horse_sex AS hs ON ah.id_horse_sex = hs.id_horse_sex LEFT JOIN breeds ON ah.id_breeds = breeds.id_breeds LEFT JOIN types_transactions AS tt ON ah.id_types_transactions = tt.id_types_transactions LEFT JOIN colors ON ah.id_colors = colors.id_colors LEFT JOIN stallions_list AS sl ON ah.id_stallions_list = sl.id_stallions_list LEFT JOIN ads ON ah.id_ad = ads.id_ad LEFT OUTER JOIN departments AS d ON ads.id_departments = d.id_departments LEFT JOIN countries AS cou ON cou.id_countries = ads.id_countries LEFT OUTER JOIN counties AS counties ON counties.id_counties = d.id_counties WHERE ah.id_ad = 757648
0.32591819763184 ms

_______________________________________________________________
SELECT `sites_partners_has_types_ads`.`id_sites_partners` FROM `sites_partners_has_types_ads` WHERE (id_types_ads = "13")
0.02288818359375 ms

_______________________________________________________________
SELECT DISTINCT countries.flag, name_pricelist, a.title, a.id_members, a.lang,lat,lon,a.addate, a.date_active, a.photo as photo_0, a.total_photos, a.total_videos, a.option_8 as option_frame, a.option_9 as option_highlight,a.option_11 as option_urgent, `ah`.`id_ad`, `ah`.`yearofbirth`, `ah`.`sire`, `ah`.`price`, `ah`.`price2`,`prl`.`price1` as `interval_min`, `prl`.`price2` AS `interval_max`, `hs`.`name_horse_sex`,`b`.`name_breed`,`c`.`name_colors`, `sl`.`name_stallions_list`,`tt`.`name_types_transactions`, p.name_packages,s.currency_text,name_country,name_department,code_department, members_status.name_members_status, members.photo, members.account_url, a.adpostcode, a.adcity, hh.value as height, hu.name_height_units as height_unit, al.description, coalesce(least(`ah`.`price`, `ah`.`price2`, `prl`.`price1`, `prl`.`price2`), `ah`.`price`, `ah`.`price2`, `prl`.`price1`, `prl`.`price2`) as compare_price FROM `ad_horses` AS `ah` JOIN `ads` AS `a` ON ah.id_ad = a.id_ad AND ah.id_types_equines = 1 AND a.id_types_ads = 13 AND a.id_status IN(101,201,301) AND deleted = 0 LEFT OUTER JOIN `breeds` AS `b` ON ah.id_breeds = b.id_breeds LEFT OUTER JOIN `prices_range_list` AS `prl` ON ah.id_prices_range_list = prl.id_prices_range_list LEFT OUTER JOIN `horse_sex` AS `hs` ON ah.id_horse_sex = hs.id_horse_sex LEFT OUTER JOIN `colors` AS `c` ON ah.id_colors = c.id_colors LEFT OUTER JOIN `types_transactions` AS `tt` ON ah.id_types_transactions = tt.id_types_transactions LEFT OUTER JOIN `sites` AS `s` ON a.id_sites = s.id_sites LEFT OUTER JOIN `packages` AS `p` ON a.id_packages = p.id_packages LEFT OUTER JOIN `departments` ON a.id_departments = departments.id_departments LEFT OUTER JOIN `countries` ON a.id_countries = countries.id_countries LEFT OUTER JOIN members ON a.id_members = members.id_members LEFT OUTER JOIN members_status ON members.id_members_status = members_status.id_members_status LEFT OUTER JOIN horse_height AS hh ON ah.id_horse_height = hh.id_horse_height LEFT OUTER JOIN pricelist AS pl ON ah.id_pricelist = pl.id_pricelist LEFT OUTER JOIN height_units AS hu ON hh.id_height_units = hu.id_height_units LEFT OUTER JOIN ads_langage AS al ON ah.id_ad = al.id_ad and al.id_langages=6 LEFT OUTER JOIN `stallions_list` AS `sl` ON ah.id_stallions_list = sl.id_stallions_list WHERE ( a.id_sites = 7 OR a.option_19 = 1 ) AND (a.id_sites_partners = 1 OR (a.id_sites_partners IN (1,3) AND a.option_14 = 1 )) AND ( a.option_6 = 1 ) AND (ah.id_colors = 8 ) ORDER BY (NULLIF(a.id_sites, 7)), a.addate DESC LIMIT 0,19
6.6370964050293 ms

_______________________________________________________________
SELECT DISTINCT ah.id_ad, members.id_members_status, a.option_6, a.option_11, a.id_status, members.id_members, members.organizationname, members.firstname, substring( members.lastname, 1, 1 ) AS lastname, members.city, members.postcode, coalesce(least(`ah`.`price`, `ah`.`price2`, `prl`.`price1`, `prl`.`price2`),`ah`.`price`, `ah`.`price2`, `prl`.`price1`, `prl`.`price2`) as compare_price FROM `ad_horses` AS `ah` JOIN `ads` AS `a` ON ah.id_ad = a.id_ad AND ah.id_types_equines = 1 AND a.id_types_ads = 13 AND a.id_status IN(101,201,301) AND deleted = 0 LEFT OUTER JOIN `breeds` AS `b` ON ah.id_breeds = b.id_breeds LEFT OUTER JOIN `prices_range_list` AS `prl` ON ah.id_prices_range_list = prl.id_prices_range_list LEFT OUTER JOIN `horse_sex` AS `hs` ON ah.id_horse_sex = hs.id_horse_sex LEFT OUTER JOIN `colors` AS `c` ON ah.id_colors = c.id_colors LEFT OUTER JOIN `types_transactions` AS `tt` ON ah.id_types_transactions = tt.id_types_transactions LEFT OUTER JOIN `sites` AS `s` ON a.id_sites = s.id_sites LEFT OUTER JOIN `packages` AS `p` ON a.id_packages = p.id_packages LEFT OUTER JOIN `departments` ON a.id_departments = departments.id_departments LEFT OUTER JOIN `countries` ON a.id_countries = countries.id_countries LEFT OUTER JOIN members ON a.id_members = members.id_members LEFT OUTER JOIN members_status ON members.id_members_status = members_status.id_members_status LEFT OUTER JOIN horse_height AS hh ON ah.id_horse_height = hh.id_horse_height LEFT OUTER JOIN pricelist AS pl ON ah.id_pricelist = pl.id_pricelist LEFT OUTER JOIN height_units AS hu ON hh.id_height_units = hu.id_height_units LEFT OUTER JOIN ads_langage AS al ON ah.id_ad = al.id_ad and al.id_langages=6 LEFT OUTER JOIN `stallions_list` AS `sl` ON ah.id_stallions_list = sl.id_stallions_list WHERE ( a.id_sites = 7 OR a.option_19 = 1 ) AND (a.id_sites_partners = 1 OR (a.id_sites_partners IN (1,3) AND a.option_14 = 1 )) AND ( a.option_6 = 1 ) AND (ah.id_colors = 8 )
6.0570240020752 ms

_______________________________________________________________
SELECT `ads`.`lang` FROM `ads` WHERE (id_ad = 785030)
0.085115432739258 ms

_______________________________________________________________
SELECT breeds.name_breed AS breed, tt.name_types_transactions AS transaction, colors.name_colors AS color, ah.yearofbirth, sl.name_stallions_list AS stallion, hs.name_horse_sex AS sex, ah.yearofbirth, d.name_department AS dpt, cou.name_country AS country, counties.name_county AS county FROM ad_horses AS ah LEFT JOIN horse_sex AS hs ON ah.id_horse_sex = hs.id_horse_sex LEFT JOIN breeds ON ah.id_breeds = breeds.id_breeds LEFT JOIN types_transactions AS tt ON ah.id_types_transactions = tt.id_types_transactions LEFT JOIN colors ON ah.id_colors = colors.id_colors LEFT JOIN stallions_list AS sl ON ah.id_stallions_list = sl.id_stallions_list LEFT JOIN ads ON ah.id_ad = ads.id_ad LEFT OUTER JOIN departments AS d ON ads.id_departments = d.id_departments LEFT JOIN countries AS cou ON cou.id_countries = ads.id_countries LEFT OUTER JOIN counties AS counties ON counties.id_counties = d.id_counties WHERE ah.id_ad = 785030
0.55098533630371 ms

_______________________________________________________________
SELECT `ads`.`lang` FROM `ads` WHERE (id_ad = 783932)
0.11992454528809 ms

_______________________________________________________________
SELECT breeds.name_breed AS breed, tt.name_types_transactions AS transaction, colors.name_colors AS color, ah.yearofbirth, sl.name_stallions_list AS stallion, hs.name_horse_sex AS sex, ah.yearofbirth, d.name_department AS dpt, cou.name_country AS country, counties.name_county AS county FROM ad_horses AS ah LEFT JOIN horse_sex AS hs ON ah.id_horse_sex = hs.id_horse_sex LEFT JOIN breeds ON ah.id_breeds = breeds.id_breeds LEFT JOIN types_transactions AS tt ON ah.id_types_transactions = tt.id_types_transactions LEFT JOIN colors ON ah.id_colors = colors.id_colors LEFT JOIN stallions_list AS sl ON ah.id_stallions_list = sl.id_stallions_list LEFT JOIN ads ON ah.id_ad = ads.id_ad LEFT OUTER JOIN departments AS d ON ads.id_departments = d.id_departments LEFT JOIN countries AS cou ON cou.id_countries = ads.id_countries LEFT OUTER JOIN counties AS counties ON counties.id_counties = d.id_counties WHERE ah.id_ad = 783932
0.50902366638184 ms

_______________________________________________________________
SELECT `ads`.`lang` FROM `ads` WHERE (id_ad = 721378)
0.1220703125 ms

_______________________________________________________________
SELECT breeds.name_breed AS breed, tt.name_types_transactions AS transaction, colors.name_colors AS color, ah.yearofbirth, sl.name_stallions_list AS stallion, hs.name_horse_sex AS sex, ah.yearofbirth, d.name_department AS dpt, cou.name_country AS country, counties.name_county AS county FROM ad_horses AS ah LEFT JOIN horse_sex AS hs ON ah.id_horse_sex = hs.id_horse_sex LEFT JOIN breeds ON ah.id_breeds = breeds.id_breeds LEFT JOIN types_transactions AS tt ON ah.id_types_transactions = tt.id_types_transactions LEFT JOIN colors ON ah.id_colors = colors.id_colors LEFT JOIN stallions_list AS sl ON ah.id_stallions_list = sl.id_stallions_list LEFT JOIN ads ON ah.id_ad = ads.id_ad LEFT OUTER JOIN departments AS d ON ads.id_departments = d.id_departments LEFT JOIN countries AS cou ON cou.id_countries = ads.id_countries LEFT OUTER JOIN counties AS counties ON counties.id_counties = d.id_counties WHERE ah.id_ad = 721378
0.28300285339355 ms

_______________________________________________________________
SELECT `banner`.`id`, `banner`.`img`, `banner`.`img_large`, `banner`.`title`, `banner`.`description`, `banner`.`cta_text` FROM `banner` LEFT JOIN `banner_has_sites` ON banner.id = banner_has_sites.id_b LEFT JOIN `banner_has_categories` ON banner.id = banner_has_categories.id_b WHERE (end >= '2023-03-21 8:35:03') AND (start <= '2023-03-21 8:35:03') AND (format = 12) AND (banner.active = 1) AND (banner_has_sites.id_s = 6) AND (banner_has_categories.id_c IN (1, 3))
0.29301643371582 ms

_______________________________________________________________
SELECT `banner`.`id`, `banner`.`img`, `banner`.`img_large`, `banner`.`title`, `banner`.`description`, `banner`.`url`, `banner`.`displayurl`, `banner`.`phone`, `banner`.`displayphone`, `members`.`username` FROM `banner` LEFT JOIN `members` ON banner.id_members = members.id_members LEFT JOIN `banner_has_sites` ON banner.id = banner_has_sites.id_b LEFT JOIN `banner_has_categories` ON banner.id = banner_has_categories.id_b WHERE (end > '2023-03-21 8:35:03') AND (start <= '2023-03-21 8:35:03') AND (format = 1) AND (banner.active = 1) AND (banner_has_sites.id_s = 6) AND (banner_has_categories.id_c IN (1, 3))
0.3209114074707 ms














-- Total Exec : 1679384103990.6 ms
-- Total SQL : 60.7590675354 ms