Retour
Fermer

›

Lancez votre recherche pour voir les annonces.

Service : Coach Sportif

Retour Service Coach sportif Service coach sportif 78 entre particuliers Service coach sportif 78 entre particuliers

Discuter

Ce voisin propose ce service à Mantes-la-Ville (78711)

40€

Description de l'annonce

Je propose de partager avec vos enfants, jeunes et adolescents ma passion du coaching de footballeurs.
Exercices de renforcement musculaire et entraînement avec et sans ballon à travers des exercices spécifiques.
#coach sportif

Autres annonces du voisin

Tout voir
Service montage video
Service : montage video

Mantes-la-Vil... 78711

Service : montage vidéos
Profil du voisin
Dona A

Mantes-la-Ville 78711

40€/h

Demander un montage
Service secretariat
Service : secretariat

Mantes-la-Vil... 78711

Service : secrétariat
Profil du voisin
Dona A

Mantes-la-Ville 78711

25€/h

Demander un service
Service aide aux courses
Service : aide aux courses

Mantes-la-Vil... 78711

Service : aide aux courses
Profil du voisin
Dona A

Mantes-la-Ville 78711

14€/h

Demander une course
Service aide personne
Service : aide personne

Mantes-la-Vil... 78711

Service : aide a la personne
Profil du voisin
Dona A

Mantes-la-Ville 78711

20€/h

Demander une aide
Service nettoyage
Service : nettoyage

Mantes-la-Vil... 78711

Service de nettoyage
Profil du voisin
Dona A

Mantes-la-Ville 78711

25€/h

Demander un nettoyage
Service traduction
Service : traduction

Mantes-la-Vil... 78711

Service : traduction
Profil du voisin
Dona A

Mantes-la-Ville 78711

35€

Demander une traduction
Service decorateur
Service : decorateur

Mantes-la-Vil... 78711

Décorateur d’intérieur
Profil du voisin
Dona A

Mantes-la-Ville 78711

100€

Demander ce décorateur
Service decorateur
Service : decorateur

Mantes-la-Vil... 78711

Décorateur d’intérieur
Profil du voisin
Dona A

Mantes-la-Ville 78711

100€

Demander ce décorateur
Service aide demenageur
Service : aide demenageur

Mantes-la-Vil... 78711

Service : aide déménageur
Profil du voisin
Dona A

Mantes-la-Ville 78711

25€/h

Demander ce déménageur
Service entretien jardin
Service : entretien jardin

Mantes-la-Vil... 78711

Service : entretien jardin
Profil du voisin
Dona A

Mantes-la-Ville 78711

20€/h

Demander ce jardinier
Service garde de chien
Service : chien

Mantes-la-Vil... 78711

Service : garde chien
Profil du voisin
Dona A

Mantes-la-Ville 78711

15€/jr

Demander ce petsitter
Service montage de meubles
Service : montage de meubles

Mantes-la-Vil... 78711

Service : montage meubles
Profil du voisin
Dona A

Mantes-la-Ville 78711

25€/h

Demander ce monteur
Service soutien scolaire
Service : soutien scolaire

Mantes-la-Vil... 78711

Service : support scolaire
Profil du voisin
Dona A

Mantes-la-Ville 78711

20€/h

Demander du soutien
Service cours de sport
Service : cours de sport

Mantes-la-Vil... 78711

Cours de remise en forme
Profil du voisin
Dona A

Mantes-la-Ville 78711

30€/h

Réserver un cours

Annonces similaires

Tout voir
Service coach sportif
Service : coach sportif

Puteaux 92800

Service : coach de boxe
Profil du voisin
Jean M Voisin vérifié
100% fiable

Puteaux 92800

40€

Faire appel à ce coach
100%
Service coach sportif
Service : coach sportif

Paris 75000

Coach sportif de remise en forme
Profil du voisin
Abdelrahim K

Paris 75000

39€/h

Faire appel à ce coach
Service coach sportif
Service : coach sportif

Paris 75017

Coach sportif - remise en forme
Profil du voisin
Richard M

Paris 75017

50€

Faire appel à ce coach
Service coach sportif
Service : coach sportif

Saint-Cloud 92210

Service : coaching sportif
Profil du voisin
Nadia B

Saint-Cloud 92210

55€

Faire appel à ce coach
Service coach sportif
Service : coach sportif

Rueil-Malmais... 92500

Service : coach sportif
Profil du voisin
Voisin #166399

Rueil-Malmaison 92500

100€

Faire appel à ce coach
Service coach sportif
Service : coach sportif

Boisemont 95000

Service : musculation fitness
Profil du voisin
Arnold D
67% fiable

Boisemont 95000

35€

Faire appel à ce coach
67%
Service coach sportif
Service : coach sportif

Paris 75000

Coaching sportif à la maison ou en sall
Profil du voisin
Jesley B

Paris 75000

60€

Faire appel à ce coach
Service coach sportif
Service : coach sportif

Massy 91300

Coach sportif accompli
Profil du voisin
Jonathan B

Massy 91300

30€

Faire appel à ce coach
Service coach sportif
Service : coach sportif

Paris 75000

Coach sportif à  domicile
Profil du voisin
Bob T

Paris 75000

20€/h

Faire appel à ce coach
Service coach sportif
Service : coach sportif

Puteaux 92800

Renforcement musculaire
Profil du voisin
Julien M

Puteaux 92800

15€

Faire appel à ce coach

Demande un service de coaching sportif entre voisins ou proposer mes services de coaching sportif.

Poster une annonce

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wiiz-annonce.php
  1. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

  2. 0.0001

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom FROM wish w LEFT JOIN util_info ui ON w.util_id=ui.util_id WHERE wish_id='620977'

  3. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'coach-sportif' LIMIT 1

  4. 0.0001

    SELECT c.cate_id, cate_title_aff, cate_title_slug, c.fami_id, f.fami_title, f.fami_url FROM category c, family f WHERE c.fami_id=f.fami_id AND c.fami_id='3' AND c.cate_id='37'

  5. 0.0001

    SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='78'

  6. 0.0002

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='476652' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  7. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 476652

  8. 0.0001

    SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`

  9. 0.0003

    SELECT cate_id as id, cate_title as title, cate_title_slug as slug, fami_id FROM `category` WHERE cate_visu=1 AND fami_id='3' AND cate_cate_id IS NULL ORDER BY cate_order ASC

  10. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (50) ORDER BY ssrubr_order ASC

  11. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (38) ORDER BY ssrubr_order ASC

  12. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (45) ORDER BY ssrubr_order ASC

  13. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (231) ORDER BY ssrubr_order ASC

  14. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (47) ORDER BY ssrubr_order ASC

  15. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (42) ORDER BY ssrubr_order ASC

  16. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (37) ORDER BY ssrubr_order ASC

  17. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (43) ORDER BY ssrubr_order ASC

  18. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (39) ORDER BY ssrubr_order ASC

  19. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (229) ORDER BY ssrubr_order ASC

  20. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (230) ORDER BY ssrubr_order ASC

  21. 0.0001

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 620977

  22. 0.0001

    SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='620977'

  23. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='620977' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')

  24. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 476652 AND util_tel != ''

  25. 0

    SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 476652 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''

  26. 0.0001

    SELECT M.match_step FROM `match` as M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  27. 0.0001

    SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='476652' AND note_visu IN (1,3,4)

  28. 0.0001

    SELECT `empreinte_carbone`,s.prix_leroymerlin, s.prix_loxam, s.prix_kiloutou FROM `ssrubr` as s INNER JOIN wish as w ON w.ssrubr_id = s.ssrubr_id WHERE w.wish_id = '620977'

  29. 0.0002

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish w INNER JOIN util_info ui ON w.util_id = ui.util_id WHERE wish_visu IN (1,6,10) AND w.util_id='476652' AND wish_id<>'620977' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  30. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1005' LIMIT 0,1

  31. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=476652 AND note_visu IN (1,3,4)

  32. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  33. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 476652

  34. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1134' LIMIT 0,1

  35. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  36. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 476652

  37. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='958' LIMIT 0,1

  38. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  39. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 476652

  40. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1020' LIMIT 0,1

  41. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  42. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 476652

  43. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='970' LIMIT 0,1

  44. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  45. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 476652

  46. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1144' LIMIT 0,1

  47. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  48. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 476652

  49. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='586' LIMIT 0,1

  50. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  51. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 476652

  52. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='586' LIMIT 0,1

  53. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  54. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 476652

  55. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='996' LIMIT 0,1

  56. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  57. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 476652

  58. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='527' LIMIT 0,1

  59. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  60. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 476652

  61. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='951' LIMIT 0,1

  62. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  63. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 476652

  64. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='600' LIMIT 0,1

  65. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  66. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 476652

  67. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1024' LIMIT 0,1

  68. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  69. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 476652

  70. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1171' LIMIT 0,1

  71. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  72. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 476652

  73. 0.0001

    SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='78711'

  74. 0.0057

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.9667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((1.71667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.517039197041 AND ville_latitude_deg<49.416360802959 AND ville_longitude_deg>1.0317239280719 AND ville_longitude_deg<2.4016160719281 HAVING distance <= 50 ORDER BY distance ASC

  75. 0.0014

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_visu IN (1,6,10) AND wish_cp IN (78200,78711,78930,78200,78930,78520,78200,78440,78930,78930,78930,78200,78200,78200,78200,78200,78930,78520,78790,78970,78440,78200,78930,78200,78200,78710,78440,78580,78520,78790,78790,78680,78440,78790,78440,78980,78520,78790,78200,78410,78410,78270,78790,78440,78270,78790,78200,78410,78440,78770,78440,78111,78820,78126,78270,78790,78410,78910,95780,95510,78980,78580,95510,78910,78580,78840,78770,95510,78770,78270,78250,78980,78440,78840,78250,78770,78910,78910,95510,78270,95450,78124,78440,78910,78770,78410,78440,78790,95780,78980,78250,78980,78790,78270,78580,78980,95780,78770,78124,78250,78250,78270,78920,95510,78910,78910,78910,78130,78270,28260,27620,78270,95450,95420,95420,95510,78250,78580,28260,78980,78130,27640,78270,27620,78910,78630,78270,78770,78550,28260,95710,78890,95450,78650,95420,78650,78550,27630,27620,78270,78490,28260,28560,78740,78270,78121,95450,95420,95450,78940,27120,95450,28560,95420,78490,78550,78940,78740,95420,95710,95450,78810,78270,95450,28260,78540,78490,78850,78480,27730,95420,78550,28410,78640,78640,27120,95180,78630,95710,95450,27540,78640,27640,95420,78490,78510,78670,78670,95420,95450,95420,27620,95450,78810,27200,28260,78640,95000,27780,27630,78490,78490,95800,27120,27120,27630,28260,78550,95450,27120,27730,28260,95420,78950,78490,78490,27630,95450,27630,27640,78240,78490,78570,27120,78955,95450,78550,78450,27730,95450,95640,95750,95280,95650,78370,95420,78490,95770,95490,27630,95420,78240,27750,27630,78113,27510,28410,95650,95650,78760,28410,28260,27950,27950,27530,27120,78300,28410,27120,95640,95640,28410,78860,28260,27630,60240,78260,78490,78570,27950,27220,95650,27950,78340,27510,78780,60240,27220,95770,95770,27120,95000,27420,78113,60240,28410,78450,95830,27950,27120,95000,78990,78310,28410,27220,27220,60240,27120,27510,60240,27510,78690,78112,95750,27510,27420,95830,60240,27950,27120,78100,27220,95520,27120,27220,78620,27720,27120,28410,78610,78700,95640,78310,28410,78113,60240,27220,27120,78750,27420,27950,27920,27920,95610,78590,95650,78590,78390,78113,78230,78160,27510,27220,27940,28570,78190,27220,27120,95300,78320,78330,28500,95640,28520,28520,60240,78870,27120,60240,60240,95640,27870,95300,27120,78600,78110,27700,27510,95640,60240,95810,27950,78610,78113,95810,27120,95310,78560,27600,28500,78113,78690,27420,27940,27420,78610,78430,27120,27720,27810,78210,27710,78125,28210,27950,95300,27220,27600,78600,60240,78320,27120,28500,27220,78125,27120,60240,27220,78610,28210,78180,78360,60240,27120,78380,78290,27220,27510,27220,27420,78320,60240,95810,60240,78150,27220,60240,78400,28210,60240,95220,27930,27700,27930,95480,78125,78150,27420,95300,60119,28500,78280,60240,78470,95530,27120,95370,78500,27150,60240,95640,78170,27220,78960,27220,78420,95810,27600,27940,95810,27650,95430,28500,27930,28500,27650,28500,27930,27490,78125,27940,95810,27150,27150,28210,78720,27830,27930,28210,78125,95240,60119,27930,28500,27930,60240,28500,60119,27140,27600,78470,78000,95250,27600,78800,27700,60240,27320,27220,27420,28210,27490,27220,92000,27700,28500,78720,60590,78120,60240,60240,28210,28100,78114,27220,92500,95690,92420,92430,27600,95870,92380,95810,27770,27700,27700,27220,28210,95540,78720,27660,27660,27930,95550,95150,27150,78125,28210,60240,60173,95430,95630,95690,95740,27930,27150,28210,28210,28500,27650,78350,78530,95130,78220,27150,28500,27220,27490,95130,78117,60590,28210,78720,27420,27930,92410,78117,95760,60590,27700,27930,78460,78460,27930,27150,27600,95690,60590,27930,95690,78140,27220,95110,78125,95100,78125,60240,28230,27940,60110,92310,60240,27140,92210,60590,60240,95840,95320,92700,92800,92150,60240,27320,28130,27700,60240,92250,78350,27320,27930,91470,27150,92400,27700,60175,92370,27940,78470,95840,95620,27490,95120,27930,60240,60240,91190,28500,28130,27600,95390,60790,92270,27240,27600,28380,27140,60240,28230,28500,78720,27490,27860,28500,27930,28130,27430,27150,95560,27930,95290,92200,27720,91190,28500,27700,95218,95210,95600,27180,27240,27150,92100,27000,95680,78120,27150,60240,60590,91400,28500,60149,92600,92300,91470,27700,60110,28210,28500,92360,92190,27320,28210,60110,28210,28130,95230,27150,78125,95340,27150,95580,95580,27930,60790,27400,92230,60590,28350,91470,78125,27440,60110,27240,95660,28210,60590,27930,93800,92110,78125,27930,27930,95590,27320,28500,27700,92130,95570,27700,27150,28130,95880,91570,27180,91940,27320,91190,91430,27400,95560,60590,27440,78830,95260,91470,92140,60790,91440,78120,91400,27150,60240,28320,60590,27150,27400,60540,60540,27930,27400,60230,60540,91430,27700,60110,95340,27180,60390,95170,27150,28170,28130,27430,92350,92170,95560,95160,93450,92390,28500,91400,95260,78830,27320,92320,60570,27430,27430,27180,95330,95560,93430,93400,27440,60390,95590,91940,28170,92240,95570,28270,92290,27240,27430,27400,28500,60790,27240,27150,28270,27930,27930,92260,92330,95360,95410,27180,27930,27440,27430,27140,60590,28320,27400,95590,27150,92220,28170,27440,27180,95350,60590,27400,60540,27440,91940,28500,78730,78730,91370,28130,92120,27430,60540,93200,93210,28350,95570,27930,28130,60790,27440,60390,28130,78730,27430,27150,28130,75009,75020,75019,75005,75116,75001,75000,75018,75002,75015,75012,75011,75010,75016,75008,75007,75006,75017,75013,75004,75003,75014,91640,93380,27400,27400,28170,95350,60570,27240,60530,60530,27150,60790,60390,60430,91120,28130,95340,91470,95460,27240,94250,27100,27100,27430,27150,28320,78730,60390,95270,28320,60390,27380,95270,60570,27930,93240,91640,27400,94110,27400,27240,92340,95400,95200,27180,27400,60530,91300,95440,27240,93300,93120,27790,92160,60390,28270,91140,95820,28170,78660,27930,95570,91140,27400,27850,27480,27590,94235,94239,94231,94233,94238,94237,94236,94230,94232,94240,94234,60730,27380,60390,27110,60850,95270,60530,91470,60730,27190,60530,27400,27480,91160) AND fami_id='3' AND cate_id='37' AND type_id='1' AND ssrubr_id='1025' AND wish_id<>'620977' AND wish_url='' ORDER BY rand() LIMIT 0,10

  76. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1025' LIMIT 0,1

  77. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=273856 AND note_visu IN (1,3,4)

  78. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 273856 AND W.type_id = 1) OR (W.util_id != 273856 AND W.type_id = 2)) AND (`post_util_id` = 273856 OR `dest_util_id` = 273856) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  79. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 273856

  80. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1025' LIMIT 0,1

  81. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=110248 AND note_visu IN (1,3,4)

  82. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 110248 AND W.type_id = 1) OR (W.util_id != 110248 AND W.type_id = 2)) AND (`post_util_id` = 110248 OR `dest_util_id` = 110248) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  83. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 110248

  84. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1025' LIMIT 0,1

  85. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=128394 AND note_visu IN (1,3,4)

  86. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 128394 AND W.type_id = 1) OR (W.util_id != 128394 AND W.type_id = 2)) AND (`post_util_id` = 128394 OR `dest_util_id` = 128394) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  87. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 128394

  88. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1025' LIMIT 0,1

  89. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=297177 AND note_visu IN (1,3,4)

  90. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 297177 AND W.type_id = 1) OR (W.util_id != 297177 AND W.type_id = 2)) AND (`post_util_id` = 297177 OR `dest_util_id` = 297177) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  91. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 297177

  92. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1025' LIMIT 0,1

  93. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=166399 AND note_visu IN (1,3,4)

  94. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 166399 AND W.type_id = 1) OR (W.util_id != 166399 AND W.type_id = 2)) AND (`post_util_id` = 166399 OR `dest_util_id` = 166399) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  95. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 166399

  96. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1025' LIMIT 0,1

  97. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=340662 AND note_visu IN (1,3,4)

  98. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 340662 AND W.type_id = 1) OR (W.util_id != 340662 AND W.type_id = 2)) AND (`post_util_id` = 340662 OR `dest_util_id` = 340662) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  99. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 340662

  100. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1025' LIMIT 0,1

  101. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=222553 AND note_visu IN (1,3,4)

  102. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 222553 AND W.type_id = 1) OR (W.util_id != 222553 AND W.type_id = 2)) AND (`post_util_id` = 222553 OR `dest_util_id` = 222553) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  103. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 222553

  104. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1025' LIMIT 0,1

  105. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=283985 AND note_visu IN (1,3,4)

  106. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 283985 AND W.type_id = 1) OR (W.util_id != 283985 AND W.type_id = 2)) AND (`post_util_id` = 283985 OR `dest_util_id` = 283985) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  107. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 283985

  108. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1025' LIMIT 0,1

  109. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=58733 AND note_visu IN (1,3,4)

  110. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 58733 AND W.type_id = 1) OR (W.util_id != 58733 AND W.type_id = 2)) AND (`post_util_id` = 58733 OR `dest_util_id` = 58733) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  111. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 58733

  112. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1025' LIMIT 0,1

  113. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=127820 AND note_visu IN (1,3,4)

  114. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 127820 AND W.type_id = 1) OR (W.util_id != 127820 AND W.type_id = 2)) AND (`post_util_id` = 127820 OR `dest_util_id` = 127820) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  115. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 127820

  116. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1025

  117. 0.0008

    SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7

  118. 0

    SELECT count(*) as nbwish FROM wish

  119. 0.0483

    SELECT note.*, post.util_prenom as postp, post.util_nom as postn, dest.util_prenom as destp, dest.util_nom as destn, w.wish_id, w.wish_desc, w.fami_id FROM note, util_info dest, util_info post, wish w WHERE note.wish_id=w.wish_id AND note.post_util_id=post.util_id AND note.dest_util_id=dest.util_id AND note_visu IN (1,2,3,4) AND post_util_id<>'7' ORDER BY note_date DESC, note_hour DESC

119 requetes sql en 0.0677

Taille variable Globale : 58.03 KB