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
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
Sauvegarder une annonce
Cette fonctionnalité nécessite d'être inscrit sur notre site.
_______________________________________________________________ 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
