Kiwiiz : service & location entre voisins.
Utiliser ma position
Logo recherche

Indiquer un code postal ou une ville Indiquer un code postal

Flèche vers le champ lieu

Poster une annonce

Indiquer un code postal ou une ville Indiquer un code postal

Flèche vers le champ lieu

Service garde rongeur à 93700 Drancy


Service garde rongeur : 0 annonces de garde rongeur entre particuliers à 93700 Drancy Vous souhaitez garder ou faire garder un rongeur (NAC) : rongeur, rat domestique, gerbille, cochon d'inde ou encore chinchilla ... déposez votre annonce pour demander ou proposer la garde de votre animal de compagnie.
 ... voir la suite
Service rongeur

Il y a + de 30j

Il y a + de 30j

Garder vos animaux (15 jours)

120€

18 km · Emerainville
Service garde animaux

Il y a + de 30j

Il y a + de 30j

Propose garde d’animaux

-- €

19 km · Pontault-Combault
Service rongeur

Il y a + de 30j

Il y a + de 30j

Garde de tous vos rongeurs

9€/jour

19 km · Rueil-Malmaison
Service chat

Il y a + de 30j

Il y a + de 30j

Service : Visites de chats

16€/jour

20 km · Sucy-en-Brie
Service promeneur chien

Il y a + de 30j

Il y a + de 30j

Promenades de chiens et visites de chats

15€/heure

20 km · Sucy-en-Brie
Service rongeur

Il y a + de 30j

Il y a + de 30j

Garde à domicile NAC

-- €

20 km · Fresnes-sur-Marne

Proposer mon aide

Louer du matériel ou proposer un service

Faire appel à mes voisins

Besoin d'un objet ou d'un service ?
Service rongeur

Il y a + de 30j

Il y a + de 30j

Garde rongeurs et oiseaux

36€/semaine

19 km · Choisy-le-Roi
Service garde animaux

Il y a + de 30j

Il y a + de 30j

Garde d'animaux

10€/jour

19 km · Cormeilles-en-Parisis
Service chat

Il y a + de 30j

Il y a + de 30j

Garde chats ou rongeurs

10€

19 km · Rueil-Malmaison
Service garde animaux

Il y a + de 30j

Il y a + de 30j

l'arche de noé

10€/jour

19 km · Châtillon
Service garde animaux

Il y a + de 30j

Il y a + de 30j

garde animaux SARTROUVILLE HOUILLES

9€/jour

20 km · Sartrouville
Service rongeur

Il y a + de 30j

Il y a + de 30j

Garde de rongeurs

10€/jour

20 km · Clamart
Service rongeur

Il y a + de 30j

Il y a + de 30j

Service : Garde de rongeur

30€/jour

21 km · Bussy-Saint-Georges
<< <
1
2
Demander un service / jobbing de garde d'animaux ou proposer un service de garde d'animaux entre particuliers.
Poster une annonce

Retour
Fermer

Service › Garde d'animaux

Lancez votre recherche pour voir les annonces.

Trouver

Trouver
Demandes des voisins

Demandes

 créer une annonce
Messagerie

Messages

 Mon profil

Profil

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wall.php

  1. 0.0002

    SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL

  2. 0.0004

    SELECT cate_id FROM category WHERE fami_id='3' AND cate_title_slug='garde-d-animaux'

  3. 0.0001

    SELECT cate_title_slug, cate_title,cate_title_aff FROM category WHERE cate_id=45

  4. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='93'

  5. 0.0002

    SELECT ville_nom FROM villes WHERE ville_cp='93700' AND ville_nom like '%drancy%' ORDER BY ville_population_2012 DESC LIMIT 0,1

  6. 0.0008

    SELECT DISTINCT ssrubr_slug FROM ssrubr WHERE ssrubr_visu=1 AND fami_id IN (3,5) AND ssrubr_slug IS NOT NULL AND ssrubr_slug<>''

  7. 0.0008

    SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%rongeur%' OR ssrubr_title like '%rongeur%' OR ssrubr_slug like '%rongeur%') AND cate_id='45' ORDER BY ssrubr_id LIMIT 0,1

  8. 0.0002

    SHOW TABLES LIKE 'pays'

  9. 0.0003

    SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

  10. 0.0003

    SELECT pays_code, pays_nom, pays_actif, pays_NDD, pays_drapeau, pays_lang, pays_tel, pays_nb_annonces, pays_tel_masque, pays_tel_max, pays_tel_fmt_paires, pays_tel_mode FROM pays ORDER BY pays_nom ASC

  11. 0.0001

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

  12. 0.0026

    SELECT ville_cp, ROUND((((acos(sin((48.9333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.45- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.753435678816 AND ville_latitude_deg<49.113164321184 AND ville_longitude_deg>2.176207276093 AND ville_longitude_deg<2.723792723907 HAVING distance <= 20 ORDER BY distance ASC

  13. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='rongeur'

  14. 0.0012

    SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='45'AND MATCH (wish_title,wish_desc) AGAINST ('+rongeur*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '93700%'

  15. 0.0001

    SELECT * FROM texte WHERE cate_id=45

  16. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='3' AND (ssrubr_keywords='rongeur' OR ssrubr_slug='rongeur' OR (ssrubr_title like '%rongeur%')) AND cate_id='45' ORDER BY ssrubr_id LIMIT 0,1

  17. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='rongeur' AND cate_id='45'

  18. 0.0001

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

  19. 0.0036

    SELECT ville_cp, ROUND((((acos(sin((48.9333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.45- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.753435678816 AND ville_latitude_deg<49.113164321184 AND ville_longitude_deg>2.176207276093 AND ville_longitude_deg<2.723792723907 HAVING distance <= 20 ORDER BY distance ASC

  20. 0.0099

    SELECT ville_cp, ROUND((((acos(sin((48.9333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.45- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.483639197041 AND ville_latitude_deg<49.382960802959 AND ville_longitude_deg>1.7655122878414 AND ville_longitude_deg<3.1344877121586 HAVING distance <= 50 ORDER BY distance ASC

  21. 0.0785

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify, ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.9333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.45- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='45' AND MATCH (wish_desc) AGAINST ('(+rongeur*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (93700,93700,93150,93350,93440,93000,93140,95500,95140,93500,93240,93600,93120,93300,95500,93130,93230,93260,95400,93270,93320,93340,93310,93250,93200,93210,93420,93380,93100,95500,93190,93390,93110,93170,95500,95360,93220,93430,92390,93410,93450,93360,95700,95200,95400,95410,93400,93370,94300,95720,95190,93290,94120,95350,77181,93470,94170,95170,95880,95440,93800,92230,93330,75007,75011,75010,75008,75009,75013,75116,75012,75014,75019,75015,75018,75017,75016,75006,75001,75004,75003,75002,75000,75020,75005,95160,93460,94160,95720,94130,92110,95380,95350,94360,77270,92600,95230,77500,77181,93160,95460,95210,95218,92300,94410,95190,94340,94220,95580,95580,95380,94350,77290,95720,92270,94500,94200,94205,95330,95600,95380,94270,77990,77420,95120,77177,92200,95100,77410,92700,77990,95190,94700,95850,95570,95380,92400,94140,95380,95110,92250,94210,94340,94100,95720,95680,94420,95570,94250,94430,92170,94800,92120,77410,95390,77186,77360,77185,95850,94000,95130,95270,95570,92240,95870,94400,95670,94110,95470,95320,77200,95270,77230,77290,95130,92800,92150,95560,95570,77230,77184,77400,94490,94880,94880,77230,77410,78800,92100,95560,77230,92220,95270,95270,95270,77400,77410,95560,92000,92130,94600,94380,95470,95470,94235,94238,94236,94234,94240,94232,94230,94237,94233,94231,94239,77340,77410,95240,92500,94320,92320,95560,94510,77183,77090,77600,94370,94380,95840,78500,78420,77410,77230,77400,95530,77400,92210,94550,95270,95470,92140) AND type_id=1 GROUP BY wish_id

  22. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 20218 AND W.type_id = 1) OR (W.util_id <> 20218 AND W.type_id = 2)) AND (M.post_util_id = 20218 OR M.dest_util_id = 20218) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  23. 0.0001

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

  24. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 47288 AND W.type_id = 1) OR (W.util_id <> 47288 AND W.type_id = 2)) AND (M.post_util_id = 47288 OR M.dest_util_id = 47288) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  25. 0.0001

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

  26. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 47848 AND W.type_id = 1) OR (W.util_id <> 47848 AND W.type_id = 2)) AND (M.post_util_id = 47848 OR M.dest_util_id = 47848) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  27. 0.0001

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

  28. 0.0003

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 54544 AND W.type_id = 1) OR (W.util_id <> 54544 AND W.type_id = 2)) AND (M.post_util_id = 54544 OR M.dest_util_id = 54544) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  29. 0.0001

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

  30. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 63415 AND W.type_id = 1) OR (W.util_id <> 63415 AND W.type_id = 2)) AND (M.post_util_id = 63415 OR M.dest_util_id = 63415) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  31. 0.0001

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

  32. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 65458 AND W.type_id = 1) OR (W.util_id <> 65458 AND W.type_id = 2)) AND (M.post_util_id = 65458 OR M.dest_util_id = 65458) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  33. 0.0001

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

  34. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 66441 AND W.type_id = 1) OR (W.util_id <> 66441 AND W.type_id = 2)) AND (M.post_util_id = 66441 OR M.dest_util_id = 66441) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  35. 0.0001

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

  36. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 70834 AND W.type_id = 1) OR (W.util_id <> 70834 AND W.type_id = 2)) AND (M.post_util_id = 70834 OR M.dest_util_id = 70834) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  37. 0.0001

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

  38. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 73885 AND W.type_id = 1) OR (W.util_id <> 73885 AND W.type_id = 2)) AND (M.post_util_id = 73885 OR M.dest_util_id = 73885) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  39. 0.0001

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

  40. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 75110 AND W.type_id = 1) OR (W.util_id <> 75110 AND W.type_id = 2)) AND (M.post_util_id = 75110 OR M.dest_util_id = 75110) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  41. 0.0001

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

  42. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 75239 AND W.type_id = 1) OR (W.util_id <> 75239 AND W.type_id = 2)) AND (M.post_util_id = 75239 OR M.dest_util_id = 75239) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  43. 0.0001

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

  44. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 87306 AND W.type_id = 1) OR (W.util_id <> 87306 AND W.type_id = 2)) AND (M.post_util_id = 87306 OR M.dest_util_id = 87306) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  45. 0.0001

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

  46. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 93224 AND W.type_id = 1) OR (W.util_id <> 93224 AND W.type_id = 2)) AND (M.post_util_id = 93224 OR M.dest_util_id = 93224) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  47. 0.0001

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

  48. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 99581 AND W.type_id = 1) OR (W.util_id <> 99581 AND W.type_id = 2)) AND (M.post_util_id = 99581 OR M.dest_util_id = 99581) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  49. 0.0001

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

  50. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 102729 AND W.type_id = 1) OR (W.util_id <> 102729 AND W.type_id = 2)) AND (M.post_util_id = 102729 OR M.dest_util_id = 102729) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  51. 0.0001

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

  52. 0.0003

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 104588 AND W.type_id = 1) OR (W.util_id <> 104588 AND W.type_id = 2)) AND (M.post_util_id = 104588 OR M.dest_util_id = 104588) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  53. 0.0001

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

  54. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 136066 AND W.type_id = 1) OR (W.util_id <> 136066 AND W.type_id = 2)) AND (M.post_util_id = 136066 OR M.dest_util_id = 136066) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  55. 0.0001

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

  56. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 53841 AND W.type_id = 1) OR (W.util_id <> 53841 AND W.type_id = 2)) AND (M.post_util_id = 53841 OR M.dest_util_id = 53841) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  57. 0.0001

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

  58. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 105514 AND W.type_id = 1) OR (W.util_id <> 105514 AND W.type_id = 2)) AND (M.post_util_id = 105514 OR M.dest_util_id = 105514) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  59. 0.0001

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

  60. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 145099 AND W.type_id = 1) OR (W.util_id <> 145099 AND W.type_id = 2)) AND (M.post_util_id = 145099 OR M.dest_util_id = 145099) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  61. 0.0001

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

  62. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 157549 AND W.type_id = 1) OR (W.util_id <> 157549 AND W.type_id = 2)) AND (M.post_util_id = 157549 OR M.dest_util_id = 157549) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  63. 0.0001

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

  64. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 167798 AND W.type_id = 1) OR (W.util_id <> 167798 AND W.type_id = 2)) AND (M.post_util_id = 167798 OR M.dest_util_id = 167798) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  65. 0.0001

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

  66. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 140799 AND W.type_id = 1) OR (W.util_id <> 140799 AND W.type_id = 2)) AND (M.post_util_id = 140799 OR M.dest_util_id = 140799) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  67. 0.0001

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

  68. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 179489 AND W.type_id = 1) OR (W.util_id <> 179489 AND W.type_id = 2)) AND (M.post_util_id = 179489 OR M.dest_util_id = 179489) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  69. 0.0001

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

  70. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 182388 AND W.type_id = 1) OR (W.util_id <> 182388 AND W.type_id = 2)) AND (M.post_util_id = 182388 OR M.dest_util_id = 182388) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  71. 0.0001

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

  72. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 186009 AND W.type_id = 1) OR (W.util_id <> 186009 AND W.type_id = 2)) AND (M.post_util_id = 186009 OR M.dest_util_id = 186009) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  73. 0.0001

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

  74. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 187539 AND W.type_id = 1) OR (W.util_id <> 187539 AND W.type_id = 2)) AND (M.post_util_id = 187539 OR M.dest_util_id = 187539) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  75. 0.0001

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

  76. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 197357 AND W.type_id = 1) OR (W.util_id <> 197357 AND W.type_id = 2)) AND (M.post_util_id = 197357 OR M.dest_util_id = 197357) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  77. 0.0001

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

  78. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 167383 AND W.type_id = 1) OR (W.util_id <> 167383 AND W.type_id = 2)) AND (M.post_util_id = 167383 OR M.dest_util_id = 167383) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  79. 0.0001

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

  80. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 204957 AND W.type_id = 1) OR (W.util_id <> 204957 AND W.type_id = 2)) AND (M.post_util_id = 204957 OR M.dest_util_id = 204957) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  81. 0.0001

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

  82. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 206353 AND W.type_id = 1) OR (W.util_id <> 206353 AND W.type_id = 2)) AND (M.post_util_id = 206353 OR M.dest_util_id = 206353) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  83. 0.0001

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

  84. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 209871 AND W.type_id = 1) OR (W.util_id <> 209871 AND W.type_id = 2)) AND (M.post_util_id = 209871 OR M.dest_util_id = 209871) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  85. 0.0001

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

  86. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 214773 AND W.type_id = 1) OR (W.util_id <> 214773 AND W.type_id = 2)) AND (M.post_util_id = 214773 OR M.dest_util_id = 214773) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  87. 0.0001

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

  88. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 228709 AND W.type_id = 1) OR (W.util_id <> 228709 AND W.type_id = 2)) AND (M.post_util_id = 228709 OR M.dest_util_id = 228709) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  89. 0.0001

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

  90. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 230047 AND W.type_id = 1) OR (W.util_id <> 230047 AND W.type_id = 2)) AND (M.post_util_id = 230047 OR M.dest_util_id = 230047) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  91. 0.0001

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

  92. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 236806 AND W.type_id = 1) OR (W.util_id <> 236806 AND W.type_id = 2)) AND (M.post_util_id = 236806 OR M.dest_util_id = 236806) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  93. 0.0001

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

  94. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 242434 AND W.type_id = 1) OR (W.util_id <> 242434 AND W.type_id = 2)) AND (M.post_util_id = 242434 OR M.dest_util_id = 242434) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  95. 0.0001

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

  96. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 252207 AND W.type_id = 1) OR (W.util_id <> 252207 AND W.type_id = 2)) AND (M.post_util_id = 252207 OR M.dest_util_id = 252207) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  97. 0.0001

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

  98. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 54373 AND W.type_id = 1) OR (W.util_id <> 54373 AND W.type_id = 2)) AND (M.post_util_id = 54373 OR M.dest_util_id = 54373) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  99. 0.0001

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

  100. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 254781 AND W.type_id = 1) OR (W.util_id <> 254781 AND W.type_id = 2)) AND (M.post_util_id = 254781 OR M.dest_util_id = 254781) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  101. 0.0001

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

  102. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 260948 AND W.type_id = 1) OR (W.util_id <> 260948 AND W.type_id = 2)) AND (M.post_util_id = 260948 OR M.dest_util_id = 260948) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  103. 0.0001

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

  104. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 179032 AND W.type_id = 1) OR (W.util_id <> 179032 AND W.type_id = 2)) AND (M.post_util_id = 179032 OR M.dest_util_id = 179032) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  105. 0.0001

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

  106. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 161020 AND W.type_id = 1) OR (W.util_id <> 161020 AND W.type_id = 2)) AND (M.post_util_id = 161020 OR M.dest_util_id = 161020) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  107. 0.0001

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

  108. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 270188 AND W.type_id = 1) OR (W.util_id <> 270188 AND W.type_id = 2)) AND (M.post_util_id = 270188 OR M.dest_util_id = 270188) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  109. 0.0001

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

  110. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 272135 AND W.type_id = 1) OR (W.util_id <> 272135 AND W.type_id = 2)) AND (M.post_util_id = 272135 OR M.dest_util_id = 272135) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  111. 0.0001

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

  112. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 298711 AND W.type_id = 1) OR (W.util_id <> 298711 AND W.type_id = 2)) AND (M.post_util_id = 298711 OR M.dest_util_id = 298711) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  113. 0.0001

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

  114. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 326431 AND W.type_id = 1) OR (W.util_id <> 326431 AND W.type_id = 2)) AND (M.post_util_id = 326431 OR M.dest_util_id = 326431) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  115. 0.0001

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

  116. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 343312 AND W.type_id = 1) OR (W.util_id <> 343312 AND W.type_id = 2)) AND (M.post_util_id = 343312 OR M.dest_util_id = 343312) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  117. 0.0001

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

  118. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 344606 AND W.type_id = 1) OR (W.util_id <> 344606 AND W.type_id = 2)) AND (M.post_util_id = 344606 OR M.dest_util_id = 344606) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  119. 0.0001

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

  120. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 347340 AND W.type_id = 1) OR (W.util_id <> 347340 AND W.type_id = 2)) AND (M.post_util_id = 347340 OR M.dest_util_id = 347340) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  121. 0.0001

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

  122. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 380167 AND W.type_id = 1) OR (W.util_id <> 380167 AND W.type_id = 2)) AND (M.post_util_id = 380167 OR M.dest_util_id = 380167) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  123. 0.0001

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

  124. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 389084 AND W.type_id = 1) OR (W.util_id <> 389084 AND W.type_id = 2)) AND (M.post_util_id = 389084 OR M.dest_util_id = 389084) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  125. 0.0001

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

  126. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 253757 AND W.type_id = 1) OR (W.util_id <> 253757 AND W.type_id = 2)) AND (M.post_util_id = 253757 OR M.dest_util_id = 253757) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  127. 0.0001

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

  128. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 152749 AND W.type_id = 1) OR (W.util_id <> 152749 AND W.type_id = 2)) AND (M.post_util_id = 152749 OR M.dest_util_id = 152749) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  129. 0.0001

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

  130. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 275468 AND W.type_id = 1) OR (W.util_id <> 275468 AND W.type_id = 2)) AND (M.post_util_id = 275468 OR M.dest_util_id = 275468) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  131. 0.0001

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

  132. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 111767 AND W.type_id = 1) OR (W.util_id <> 111767 AND W.type_id = 2)) AND (M.post_util_id = 111767 OR M.dest_util_id = 111767) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  133. 0.0001

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

  134. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 458681 AND W.type_id = 1) OR (W.util_id <> 458681 AND W.type_id = 2)) AND (M.post_util_id = 458681 OR M.dest_util_id = 458681) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  135. 0.0001

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

  136. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 346405 AND W.type_id = 1) OR (W.util_id <> 346405 AND W.type_id = 2)) AND (M.post_util_id = 346405 OR M.dest_util_id = 346405) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  137. 0.0001

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

  138. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 469639 AND W.type_id = 1) OR (W.util_id <> 469639 AND W.type_id = 2)) AND (M.post_util_id = 469639 OR M.dest_util_id = 469639) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  139. 0.0001

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

  140. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 133838 AND W.type_id = 1) OR (W.util_id <> 133838 AND W.type_id = 2)) AND (M.post_util_id = 133838 OR M.dest_util_id = 133838) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  141. 0.0001

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

  142. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 479705 AND W.type_id = 1) OR (W.util_id <> 479705 AND W.type_id = 2)) AND (M.post_util_id = 479705 OR M.dest_util_id = 479705) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  143. 0.0001

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

  144. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 482247 AND W.type_id = 1) OR (W.util_id <> 482247 AND W.type_id = 2)) AND (M.post_util_id = 482247 OR M.dest_util_id = 482247) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  145. 0.0001

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

  146. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 484811 AND W.type_id = 1) OR (W.util_id <> 484811 AND W.type_id = 2)) AND (M.post_util_id = 484811 OR M.dest_util_id = 484811) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  147. 0.0001

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

  148. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 505204 AND W.type_id = 1) OR (W.util_id <> 505204 AND W.type_id = 2)) AND (M.post_util_id = 505204 OR M.dest_util_id = 505204) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  149. 0.0001

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

  150. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 508769 AND W.type_id = 1) OR (W.util_id <> 508769 AND W.type_id = 2)) AND (M.post_util_id = 508769 OR M.dest_util_id = 508769) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  151. 0.0001

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

  152. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 520762 AND W.type_id = 1) OR (W.util_id <> 520762 AND W.type_id = 2)) AND (M.post_util_id = 520762 OR M.dest_util_id = 520762) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  153. 0.0001

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

  154. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 529819 AND W.type_id = 1) OR (W.util_id <> 529819 AND W.type_id = 2)) AND (M.post_util_id = 529819 OR M.dest_util_id = 529819) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

  155. 0.0001

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

  156. 0.0001

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

  157. 0.0022

    SELECT ville_cp, ROUND((((acos(sin((48.9333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.45- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.753435678816 AND ville_latitude_deg<49.113164321184 AND ville_longitude_deg>2.176207276093 AND ville_longitude_deg<2.723792723907 HAVING distance <= 20 ORDER BY distance ASC

  158. 0.0093

    SELECT ville_cp, ROUND((((acos(sin((48.9333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.45- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.483639197041 AND ville_latitude_deg<49.382960802959 AND ville_longitude_deg>1.7655122878414 AND ville_longitude_deg<3.1344877121586 HAVING distance <= 50 ORDER BY distance ASC

  159. 0.0003

    SELECT ssr.ssrubr_id, ssr.ssrubr_slug, ssr.ssrubr_mail, ssr.ssrubr_mail_bis, ssr.ssrubr_keywords, ssr.ssrubr_bt2, ssr.ssrubr_photo, c.cate_title_slug, f.fami_url 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 IN (952,1016,950,1210)

  160. 0.0003

    SELECT util_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id IN (87306,182388,520762,161020,254781,73885,75239,186009,47848,63415,70834,260948)

  161. 0.0001

    SELECT util_id, util_photo FROM util_info WHERE util_id IN (87306,182388,520762,161020,254781,73885,75239,186009,47848,63415,70834,260948)

  162. 0.0002

    SELECT ssrubr_id, ssrubr_title, ssrubr_slug, ssrubr_photo, cate_title_slug FROM ssrubr ss, category c WHERE ss.cate_id=c.cate_id AND ssrubr_visu=1 AND ss.cate_id=45 AND ss.fami_id=3 ORDER BY ssrubr_order LIMIT 6,100

  163. 0.0002

    SELECT ss.fami_id, fami_url, ss.cate_id, cate_title_slug, keywords_title FROM `ssrubr_keywords` sk, ssrubr ss, category c, family f WHERE sk.ssrubr_id=ss.ssrubr_id AND ss.cate_id=c.cate_id AND c.fami_id=f.fami_id AND (ssrubr_slug='rongeur' OR ssrubr_slug like '%rongeur%' OR MATCH (ssrubr_slug) AGAINST ('(+rongeur)')) AND sk.ssrubr_id='952' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10

  164. 0.0016

    SELECT * FROM actu WHERE ssrubr_id='952' AND actu_niveau=0 ORDER BY actu_ordre DESC

  165. 0.0001

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

  166. 0.0002

    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

  167. 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 (45) ORDER BY ssrubr_order ASC

  168. 0.0017

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

  169. 0.0335

    SELECT COUNT(*) AS nbavis FROM note n INNER JOIN util_info dest ON n.dest_util_id=dest.util_id INNER JOIN util_info post ON n.post_util_id=post.util_id INNER JOIN wish w ON n.wish_id=w.wish_id WHERE n.note_visu IN (1,2,3,4) AND n.post_util_id<>'7'

  170. 0.017

    SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)

170 requetes sql en 0.1835

Taille variable Globale : 115.2 KB