1. Total Exec : 1679384082162.7 ms
2 .Total Exec : 1679384082163.1 ms
2.Total Exec : 1679384082164.6 ms
3. Total Exec : 1679384082164.6 ms
4. Total Exec : 1679384082164.7 ms
5. Total Exec : 1679384082164.7 ms
6. Total Exec : 1679384082166 ms
Chevaux Pur Sang à vendre Lorraine | Equirodi France

Chevaux Pur Sang à vendre Lorraine

4 annonces

Filtrer

Type de cheval

    Localisation

      Prix

      Plus

      Nouveau

      Magnifique hongre 5 ans potentiel cso cross

      5 500 €

      Beau cheval avec du cadre et de l'os avec un super mental. Adorable aux soins et à l'attache. Sociable avec ses congénères. Charge et voyage...

      • Cheval à vendre
      • Hongre
      • Pur Sang
      • Bai
      • 5 ans
      France.png
      Meurthe-et-Moselle
      Professionnel
      Nouveau

      Adorable ps 3 ans sport ou loisir bon potentiel cso

      5 500 €

      Adorable et belle  jument PS 3 ans  Jument ayant suivi un programme de reconversion (désensibilisation, travail au sol, monté, extérieur,...

      • Cheval à vendre
      • Jument
      • Pur Sang
      • Bai
      • 3 ans
      France.png
      Meurthe-et-Moselle
      Professionnel

      Jument ps

      < 5 000 €

      A vendre jument PS allant sur ses 11 ans, elle toise 1m60 Jument extra, vraiment un amour à pieds  Je recherche dans l’idéal une famille...

      • Cheval à vendre
      • Jument
      • Pur Sang
      • Bai
      • 11 ans
      • 160 cm
      France.png
      Vosges
      Particulier
      4 annonces de chevaux trouvées pour Chevaux Pur Sang à vendre Lorraine. Consultez les annonces de Chevaux Pur Sang à vendre Lorraine et achetez un cheval sur equirodi.com. Un cheval à vendre ? Déposer votre annonce en quelques minutes
      Equirodi vous recommande
      StarterreDemeures équestresCheval LibertéLa GéeHTI


      _______________________________________________________________
      connect
      0.38313865661621 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.13518333435059 ms

      _______________________________________________________________
      SELECT `counties`.`id_counties` FROM `counties` WHERE (name_county = '{#fr_county_103#}')
      0.087976455688477 ms

      _______________________________________________________________
      SELECT `counties`.`id_counties`, `counties`.`id_countries` FROM `counties` WHERE (id_counties = '103')
      0.085830688476562 ms

      _______________________________________________________________
      SELECT `breeds`.`id_breeds` FROM `breeds` WHERE (name_breed = '{#breed_197#}')
      0.054121017456055 ms

      _______________________________________________________________
      SELECT id_breeds, name_breed FROM breeds WHERE id_breeds IN ('197')
      0.054121017456055 ms

      _______________________________________________________________
      SELECT id_breeds, name_breed FROM breeds WHERE id_breeds IN ('197')
      0.016212463378906 ms

      _______________________________________________________________
      SELECT department_code,name,counties FROM `cities` WHERE counties IN ('1081')
      0.017881393432617 ms

      _______________________________________________________________
      SELECT `sites_partners_has_types_ads`.`id_sites_partners` FROM `sites_partners_has_types_ads` WHERE (id_types_ads = "13")
      0.017166137695312 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 `counties` ON departments.id_counties = counties.id_counties 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=1 LEFT OUTER JOIN `stallions_list` AS `sl` ON ah.id_stallions_list = sl.id_stallions_list WHERE ( a.id_sites = 1 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 (b.id_breeds = 197 ) AND (counties.id_counties = 103 ) ORDER BY a.addate DESC LIMIT 0,19
      2.9499530792236 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 `counties` ON departments.id_counties = counties.id_counties 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=1 LEFT OUTER JOIN `stallions_list` AS `sl` ON ah.id_stallions_list = sl.id_stallions_list WHERE ( a.id_sites = 1 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 (b.id_breeds = 197 ) AND (counties.id_counties = 103 )
      1.9478797912598 ms

      _______________________________________________________________
      SELECT `sites_partners_has_types_ads`.`id_sites_partners` FROM `sites_partners_has_types_ads` WHERE (id_types_ads = "13")
      0.058889389038086 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 `counties` ON departments.id_counties = counties.id_counties 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=1 LEFT OUTER JOIN `stallions_list` AS `sl` ON ah.id_stallions_list = sl.id_stallions_list WHERE ( a.id_sites = 1 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 (b.id_breeds = 197 ) AND (counties.id_counties = 103 ) ORDER BY a.addate DESC LIMIT 0,19
      6.5078735351562 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 `counties` ON departments.id_counties = counties.id_counties 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=1 LEFT OUTER JOIN `stallions_list` AS `sl` ON ah.id_stallions_list = sl.id_stallions_list WHERE ( a.id_sites = 1 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 (b.id_breeds = 197 ) AND (counties.id_counties = 103 )
      5.9049129486084 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:34:42') AND (start <= '2023-03-21 8:34:42') AND (format = 12) AND (banner.active = 1) AND (banner_has_sites.id_s = 1) AND (banner_has_categories.id_c IN (1, 3))
      0.22697448730469 ms














      -- Total Exec : 1679384082195.7 ms
      -- Total SQL : 18.448114395142 ms