Service etudiant à 92150 Suresnes

1. 0.0003

   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.0001

   SELECT cate_id FROM category WHERE fami_id='3' AND cate_title_slug='babysitting'

3. 0.0001

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

4. 0.0001

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='92'

5. 0.0001

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

6. 0.0005

   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.0001

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

8. 0.0001

   SHOW TABLES LIKE 'pays'

9. 0.0002

   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='92150'

12. 0.003

    SELECT ville_cp, ROUND((((acos(sin((48.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.23333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.686835678816 AND ville_latitude_deg<49.046564321184 AND ville_longitude_deg>1.9599018543365 AND ville_longitude_deg<2.5067581456635 HAVING distance <= 20 ORDER BY distance ASC

13. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='étudiant'

14. 0.0006

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

15. 0.0001

    SELECT * FROM texte WHERE cate_id=39

16. 0.0001

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

17. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='etudiant' AND cate_id='39'

18. 0.0001

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

19. 0.0021

    SELECT ville_cp, ROUND((((acos(sin((48.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.23333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.686835678816 AND ville_latitude_deg<49.046564321184 AND ville_longitude_deg>1.9599018543365 AND ville_longitude_deg<2.5067581456635 HAVING distance <= 20 ORDER BY distance ASC

20. 0.0089

    SELECT ville_cp, ROUND((((acos(sin((48.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.23333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.417039197041 AND ville_latitude_deg<49.316360802959 AND ville_longitude_deg>1.5497537413096 AND ville_longitude_deg<2.9169062586904 HAVING distance <= 50 ORDER BY distance ASC

21. 0.0599

    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.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.23333- 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='39' AND MATCH (wish_desc) AGAINST ('(+étudiant*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (92150,92800,92150,92210,92500,92200,92400,92250,92100,92000,92380,92300,92410,92430,92420,92700,78800,92310,92270,92130,92110,92170,92600,78170,78400,92190,92360,78420,78290,78380,92240,95870,92370,92140,75020,75000,75019,75116,75018,75001,75003,75004,75005,75006,75007,75008,75009,75010,75011,75012,75013,75014,75015,75016,75017,75002,93400,92120,78360,78140,92320,78430,78560,92230,92220,78220,78150,94250,78110,78150,95100,92350,78500,92330,92260,93450,92390,78000,94110,78230,93800,78160,78600,78600,78750,78870,95110,94270,92290,78100,95218,95530,95210,93200,93210,94234,94240,94230,94232,94231,94233,94237,94239,94236,94235,94238,92340,78350,78620,94800,93300,93120,94200,94205,78112,78590,93310,95880,93500,93430,95130,91570,95120,95240,91370,78530,78350,93170,95370,95230,92160,94160,78590,95360,94550,78210,94260,93240,78330,94220,93100,93260,93230,94300,93380,95130,95170,91430,91430,78240,95600,91300,93350,78300,94400,94140,95410,94150,78117,95580,95580,95220,91400,94320,78860,78700,78240,93000,78450,93440,94700,78260,78280,95160,91320,91120,95320,95250,95390,95680,93130,78955,95480,94410,95140,94600,93140,93150,93700,78390,95350,78117,78570,94390,94310,94340,91190,93110,95500,78450,94120,78180,95200,95400,95550,95150,91140,95400,94130,78960,91160,95350,91190,91400,78630,78340,91440,91380,91160,78780,78114,95610,91550,78670,78670,94000,78190,78810,78570,93250,94170,95330,91420,95440) 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 = 4253 AND W.type_id = 1) OR (W.util_id <> 4253 AND W.type_id = 2)) AND (M.post_util_id = 4253 OR M.dest_util_id = 4253) 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=4253 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 = 6986 AND W.type_id = 1) OR (W.util_id <> 6986 AND W.type_id = 2)) AND (M.post_util_id = 6986 OR M.dest_util_id = 6986) 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=6986 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 = 7259 AND W.type_id = 1) OR (W.util_id <> 7259 AND W.type_id = 2)) AND (M.post_util_id = 7259 OR M.dest_util_id = 7259) 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=7259 AND note_visu IN (1,3,4)

28. 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 = 7702 AND W.type_id = 1) OR (W.util_id <> 7702 AND W.type_id = 2)) AND (M.post_util_id = 7702 OR M.dest_util_id = 7702) 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=7702 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 = 8699 AND W.type_id = 1) OR (W.util_id <> 8699 AND W.type_id = 2)) AND (M.post_util_id = 8699 OR M.dest_util_id = 8699) 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=8699 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 = 9317 AND W.type_id = 1) OR (W.util_id <> 9317 AND W.type_id = 2)) AND (M.post_util_id = 9317 OR M.dest_util_id = 9317) 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=9317 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 = 15701 AND W.type_id = 1) OR (W.util_id <> 15701 AND W.type_id = 2)) AND (M.post_util_id = 15701 OR M.dest_util_id = 15701) 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=15701 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 = 17296 AND W.type_id = 1) OR (W.util_id <> 17296 AND W.type_id = 2)) AND (M.post_util_id = 17296 OR M.dest_util_id = 17296) 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=17296 AND note_visu IN (1,3,4)

38. 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 = 18572 AND W.type_id = 1) OR (W.util_id <> 18572 AND W.type_id = 2)) AND (M.post_util_id = 18572 OR M.dest_util_id = 18572) 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=18572 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 = 36348 AND W.type_id = 1) OR (W.util_id <> 36348 AND W.type_id = 2)) AND (M.post_util_id = 36348 OR M.dest_util_id = 36348) 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=36348 AND note_visu IN (1,3,4)

42. 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 = 55233 AND W.type_id = 1) OR (W.util_id <> 55233 AND W.type_id = 2)) AND (M.post_util_id = 55233 OR M.dest_util_id = 55233) 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=55233 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 = 56777 AND W.type_id = 1) OR (W.util_id <> 56777 AND W.type_id = 2)) AND (M.post_util_id = 56777 OR M.dest_util_id = 56777) 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=56777 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 = 58001 AND W.type_id = 1) OR (W.util_id <> 58001 AND W.type_id = 2)) AND (M.post_util_id = 58001 OR M.dest_util_id = 58001) 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=58001 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 = 62932 AND W.type_id = 1) OR (W.util_id <> 62932 AND W.type_id = 2)) AND (M.post_util_id = 62932 OR M.dest_util_id = 62932) 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=62932 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 = 69590 AND W.type_id = 1) OR (W.util_id <> 69590 AND W.type_id = 2)) AND (M.post_util_id = 69590 OR M.dest_util_id = 69590) 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=69590 AND note_visu IN (1,3,4)

52. 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 = 70068 AND W.type_id = 1) OR (W.util_id <> 70068 AND W.type_id = 2)) AND (M.post_util_id = 70068 OR M.dest_util_id = 70068) 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=70068 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 = 70789 AND W.type_id = 1) OR (W.util_id <> 70789 AND W.type_id = 2)) AND (M.post_util_id = 70789 OR M.dest_util_id = 70789) 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=70789 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 = 71256 AND W.type_id = 1) OR (W.util_id <> 71256 AND W.type_id = 2)) AND (M.post_util_id = 71256 OR M.dest_util_id = 71256) 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=71256 AND note_visu IN (1,3,4)

58. 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 = 73563 AND W.type_id = 1) OR (W.util_id <> 73563 AND W.type_id = 2)) AND (M.post_util_id = 73563 OR M.dest_util_id = 73563) 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=73563 AND note_visu IN (1,3,4)

60. 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 = 75167 AND W.type_id = 1) OR (W.util_id <> 75167 AND W.type_id = 2)) AND (M.post_util_id = 75167 OR M.dest_util_id = 75167) 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=75167 AND note_visu IN (1,3,4)

62. 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 = 75329 AND W.type_id = 1) OR (W.util_id <> 75329 AND W.type_id = 2)) AND (M.post_util_id = 75329 OR M.dest_util_id = 75329) 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=75329 AND note_visu IN (1,3,4)

64. 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 = 78597 AND W.type_id = 1) OR (W.util_id <> 78597 AND W.type_id = 2)) AND (M.post_util_id = 78597 OR M.dest_util_id = 78597) 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=78597 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 = 80577 AND W.type_id = 1) OR (W.util_id <> 80577 AND W.type_id = 2)) AND (M.post_util_id = 80577 OR M.dest_util_id = 80577) 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=80577 AND note_visu IN (1,3,4)

68. 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 = 75335 AND W.type_id = 1) OR (W.util_id <> 75335 AND W.type_id = 2)) AND (M.post_util_id = 75335 OR M.dest_util_id = 75335) 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=75335 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 = 82997 AND W.type_id = 1) OR (W.util_id <> 82997 AND W.type_id = 2)) AND (M.post_util_id = 82997 OR M.dest_util_id = 82997) 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=82997 AND note_visu IN (1,3,4)

72. 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 = 84178 AND W.type_id = 1) OR (W.util_id <> 84178 AND W.type_id = 2)) AND (M.post_util_id = 84178 OR M.dest_util_id = 84178) 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=84178 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 = 84854 AND W.type_id = 1) OR (W.util_id <> 84854 AND W.type_id = 2)) AND (M.post_util_id = 84854 OR M.dest_util_id = 84854) 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=84854 AND note_visu IN (1,3,4)

76. 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 = 86547 AND W.type_id = 1) OR (W.util_id <> 86547 AND W.type_id = 2)) AND (M.post_util_id = 86547 OR M.dest_util_id = 86547) 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=86547 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 = 87650 AND W.type_id = 1) OR (W.util_id <> 87650 AND W.type_id = 2)) AND (M.post_util_id = 87650 OR M.dest_util_id = 87650) 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=87650 AND note_visu IN (1,3,4)

80. 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 = 87718 AND W.type_id = 1) OR (W.util_id <> 87718 AND W.type_id = 2)) AND (M.post_util_id = 87718 OR M.dest_util_id = 87718) 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=87718 AND note_visu IN (1,3,4)

82. 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 = 64540 AND W.type_id = 1) OR (W.util_id <> 64540 AND W.type_id = 2)) AND (M.post_util_id = 64540 OR M.dest_util_id = 64540) 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=64540 AND note_visu IN (1,3,4)

84. 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 = 88621 AND W.type_id = 1) OR (W.util_id <> 88621 AND W.type_id = 2)) AND (M.post_util_id = 88621 OR M.dest_util_id = 88621) 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=88621 AND note_visu IN (1,3,4)

86. 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 = 93661 AND W.type_id = 1) OR (W.util_id <> 93661 AND W.type_id = 2)) AND (M.post_util_id = 93661 OR M.dest_util_id = 93661) 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=93661 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 = 95320 AND W.type_id = 1) OR (W.util_id <> 95320 AND W.type_id = 2)) AND (M.post_util_id = 95320 OR M.dest_util_id = 95320) 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=95320 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 = 95663 AND W.type_id = 1) OR (W.util_id <> 95663 AND W.type_id = 2)) AND (M.post_util_id = 95663 OR M.dest_util_id = 95663) 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=95663 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 = 96210 AND W.type_id = 1) OR (W.util_id <> 96210 AND W.type_id = 2)) AND (M.post_util_id = 96210 OR M.dest_util_id = 96210) 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=96210 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 = 97401 AND W.type_id = 1) OR (W.util_id <> 97401 AND W.type_id = 2)) AND (M.post_util_id = 97401 OR M.dest_util_id = 97401) 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=97401 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 = 98373 AND W.type_id = 1) OR (W.util_id <> 98373 AND W.type_id = 2)) AND (M.post_util_id = 98373 OR M.dest_util_id = 98373) 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=98373 AND note_visu IN (1,3,4)

98. 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 = 102917 AND W.type_id = 1) OR (W.util_id <> 102917 AND W.type_id = 2)) AND (M.post_util_id = 102917 OR M.dest_util_id = 102917) 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=102917 AND note_visu IN (1,3,4)

100. 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 = 103716 AND W.type_id = 1) OR (W.util_id <> 103716 AND W.type_id = 2)) AND (M.post_util_id = 103716 OR M.dest_util_id = 103716) 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=103716 AND note_visu IN (1,3,4)

102. 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 = 105466 AND W.type_id = 1) OR (W.util_id <> 105466 AND W.type_id = 2)) AND (M.post_util_id = 105466 OR M.dest_util_id = 105466) 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=105466 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 = 107421 AND W.type_id = 1) OR (W.util_id <> 107421 AND W.type_id = 2)) AND (M.post_util_id = 107421 OR M.dest_util_id = 107421) 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=107421 AND note_visu IN (1,3,4)

106. 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 = 108180 AND W.type_id = 1) OR (W.util_id <> 108180 AND W.type_id = 2)) AND (M.post_util_id = 108180 OR M.dest_util_id = 108180) 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=108180 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 = 108810 AND W.type_id = 1) OR (W.util_id <> 108810 AND W.type_id = 2)) AND (M.post_util_id = 108810 OR M.dest_util_id = 108810) 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=108810 AND note_visu IN (1,3,4)

110. 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 = 109922 AND W.type_id = 1) OR (W.util_id <> 109922 AND W.type_id = 2)) AND (M.post_util_id = 109922 OR M.dest_util_id = 109922) 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=109922 AND note_visu IN (1,3,4)

112. 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 = 108668 AND W.type_id = 1) OR (W.util_id <> 108668 AND W.type_id = 2)) AND (M.post_util_id = 108668 OR M.dest_util_id = 108668) 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=108668 AND note_visu IN (1,3,4)

114. 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 = 111276 AND W.type_id = 1) OR (W.util_id <> 111276 AND W.type_id = 2)) AND (M.post_util_id = 111276 OR M.dest_util_id = 111276) 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=111276 AND note_visu IN (1,3,4)

116. 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 = 111898 AND W.type_id = 1) OR (W.util_id <> 111898 AND W.type_id = 2)) AND (M.post_util_id = 111898 OR M.dest_util_id = 111898) 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=111898 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 = 111967 AND W.type_id = 1) OR (W.util_id <> 111967 AND W.type_id = 2)) AND (M.post_util_id = 111967 OR M.dest_util_id = 111967) 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=111967 AND note_visu IN (1,3,4)

120. 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 = 114246 AND W.type_id = 1) OR (W.util_id <> 114246 AND W.type_id = 2)) AND (M.post_util_id = 114246 OR M.dest_util_id = 114246) 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=114246 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 = 115399 AND W.type_id = 1) OR (W.util_id <> 115399 AND W.type_id = 2)) AND (M.post_util_id = 115399 OR M.dest_util_id = 115399) 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=115399 AND note_visu IN (1,3,4)

124. 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 = 115783 AND W.type_id = 1) OR (W.util_id <> 115783 AND W.type_id = 2)) AND (M.post_util_id = 115783 OR M.dest_util_id = 115783) 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=115783 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 = 116234 AND W.type_id = 1) OR (W.util_id <> 116234 AND W.type_id = 2)) AND (M.post_util_id = 116234 OR M.dest_util_id = 116234) 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=116234 AND note_visu IN (1,3,4)

128. 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 = 118972 AND W.type_id = 1) OR (W.util_id <> 118972 AND W.type_id = 2)) AND (M.post_util_id = 118972 OR M.dest_util_id = 118972) 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=118972 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 = 119641 AND W.type_id = 1) OR (W.util_id <> 119641 AND W.type_id = 2)) AND (M.post_util_id = 119641 OR M.dest_util_id = 119641) 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=119641 AND note_visu IN (1,3,4)

132. 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 = 120810 AND W.type_id = 1) OR (W.util_id <> 120810 AND W.type_id = 2)) AND (M.post_util_id = 120810 OR M.dest_util_id = 120810) 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=120810 AND note_visu IN (1,3,4)

134. 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 = 127330 AND W.type_id = 1) OR (W.util_id <> 127330 AND W.type_id = 2)) AND (M.post_util_id = 127330 OR M.dest_util_id = 127330) 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=127330 AND note_visu IN (1,3,4)

136. 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 = 129009 AND W.type_id = 1) OR (W.util_id <> 129009 AND W.type_id = 2)) AND (M.post_util_id = 129009 OR M.dest_util_id = 129009) 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=129009 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 = 130425 AND W.type_id = 1) OR (W.util_id <> 130425 AND W.type_id = 2)) AND (M.post_util_id = 130425 OR M.dest_util_id = 130425) 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=130425 AND note_visu IN (1,3,4)

140. 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 = 133322 AND W.type_id = 1) OR (W.util_id <> 133322 AND W.type_id = 2)) AND (M.post_util_id = 133322 OR M.dest_util_id = 133322) 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=133322 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 = 134420 AND W.type_id = 1) OR (W.util_id <> 134420 AND W.type_id = 2)) AND (M.post_util_id = 134420 OR M.dest_util_id = 134420) 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=134420 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 = 134970 AND W.type_id = 1) OR (W.util_id <> 134970 AND W.type_id = 2)) AND (M.post_util_id = 134970 OR M.dest_util_id = 134970) 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=134970 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 = 135052 AND W.type_id = 1) OR (W.util_id <> 135052 AND W.type_id = 2)) AND (M.post_util_id = 135052 OR M.dest_util_id = 135052) 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=135052 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 = 135162 AND W.type_id = 1) OR (W.util_id <> 135162 AND W.type_id = 2)) AND (M.post_util_id = 135162 OR M.dest_util_id = 135162) 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=135162 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 = 139264 AND W.type_id = 1) OR (W.util_id <> 139264 AND W.type_id = 2)) AND (M.post_util_id = 139264 OR M.dest_util_id = 139264) 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=139264 AND note_visu IN (1,3,4)

152. 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 = 141426 AND W.type_id = 1) OR (W.util_id <> 141426 AND W.type_id = 2)) AND (M.post_util_id = 141426 OR M.dest_util_id = 141426) 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=141426 AND note_visu IN (1,3,4)

154. 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 = 142514 AND W.type_id = 1) OR (W.util_id <> 142514 AND W.type_id = 2)) AND (M.post_util_id = 142514 OR M.dest_util_id = 142514) 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=142514 AND note_visu IN (1,3,4)

156. 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 = 145745 AND W.type_id = 1) OR (W.util_id <> 145745 AND W.type_id = 2)) AND (M.post_util_id = 145745 OR M.dest_util_id = 145745) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

157. 0.0001

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

158. 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 = 147658 AND W.type_id = 1) OR (W.util_id <> 147658 AND W.type_id = 2)) AND (M.post_util_id = 147658 OR M.dest_util_id = 147658) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

159. 0.0001

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

160. 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 = 148662 AND W.type_id = 1) OR (W.util_id <> 148662 AND W.type_id = 2)) AND (M.post_util_id = 148662 OR M.dest_util_id = 148662) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

161. 0.0001

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

162. 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 = 154658 AND W.type_id = 1) OR (W.util_id <> 154658 AND W.type_id = 2)) AND (M.post_util_id = 154658 OR M.dest_util_id = 154658) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

163. 0.0001

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

164. 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 = 43778 AND W.type_id = 1) OR (W.util_id <> 43778 AND W.type_id = 2)) AND (M.post_util_id = 43778 OR M.dest_util_id = 43778) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

165. 0.0001

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

166. 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 = 159074 AND W.type_id = 1) OR (W.util_id <> 159074 AND W.type_id = 2)) AND (M.post_util_id = 159074 OR M.dest_util_id = 159074) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

167. 0.0001

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

168. 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 = 159989 AND W.type_id = 1) OR (W.util_id <> 159989 AND W.type_id = 2)) AND (M.post_util_id = 159989 OR M.dest_util_id = 159989) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

169. 0.0001

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

170. 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 = 160221 AND W.type_id = 1) OR (W.util_id <> 160221 AND W.type_id = 2)) AND (M.post_util_id = 160221 OR M.dest_util_id = 160221) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

171. 0.0001

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

172. 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 = 169267 AND W.type_id = 1) OR (W.util_id <> 169267 AND W.type_id = 2)) AND (M.post_util_id = 169267 OR M.dest_util_id = 169267) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

173. 0.0001

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

174. 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 = 171572 AND W.type_id = 1) OR (W.util_id <> 171572 AND W.type_id = 2)) AND (M.post_util_id = 171572 OR M.dest_util_id = 171572) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

175. 0.0001

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

176. 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 = 91275 AND W.type_id = 1) OR (W.util_id <> 91275 AND W.type_id = 2)) AND (M.post_util_id = 91275 OR M.dest_util_id = 91275) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

177. 0.0001

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

178. 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 = 172883 AND W.type_id = 1) OR (W.util_id <> 172883 AND W.type_id = 2)) AND (M.post_util_id = 172883 OR M.dest_util_id = 172883) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

179. 0.0001

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

180. 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 = 131387 AND W.type_id = 1) OR (W.util_id <> 131387 AND W.type_id = 2)) AND (M.post_util_id = 131387 OR M.dest_util_id = 131387) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

181. 0.0001

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

182. 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 = 177027 AND W.type_id = 1) OR (W.util_id <> 177027 AND W.type_id = 2)) AND (M.post_util_id = 177027 OR M.dest_util_id = 177027) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

183. 0.0001

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

184. 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 = 185957 AND W.type_id = 1) OR (W.util_id <> 185957 AND W.type_id = 2)) AND (M.post_util_id = 185957 OR M.dest_util_id = 185957) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

185. 0.0001

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

186. 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 = 186713 AND W.type_id = 1) OR (W.util_id <> 186713 AND W.type_id = 2)) AND (M.post_util_id = 186713 OR M.dest_util_id = 186713) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

187. 0.0001

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

188. 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 = 190705 AND W.type_id = 1) OR (W.util_id <> 190705 AND W.type_id = 2)) AND (M.post_util_id = 190705 OR M.dest_util_id = 190705) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

189. 0.0001

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

190. 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 = 194365 AND W.type_id = 1) OR (W.util_id <> 194365 AND W.type_id = 2)) AND (M.post_util_id = 194365 OR M.dest_util_id = 194365) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

191. 0.0001

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

192. 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 = 201733 AND W.type_id = 1) OR (W.util_id <> 201733 AND W.type_id = 2)) AND (M.post_util_id = 201733 OR M.dest_util_id = 201733) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

193. 0.0001

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

194. 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 = 205660 AND W.type_id = 1) OR (W.util_id <> 205660 AND W.type_id = 2)) AND (M.post_util_id = 205660 OR M.dest_util_id = 205660) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

195. 0.0001

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

196. 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 = 206223 AND W.type_id = 1) OR (W.util_id <> 206223 AND W.type_id = 2)) AND (M.post_util_id = 206223 OR M.dest_util_id = 206223) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

197. 0.0001

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

198. 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 = 207652 AND W.type_id = 1) OR (W.util_id <> 207652 AND W.type_id = 2)) AND (M.post_util_id = 207652 OR M.dest_util_id = 207652) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

199. 0.0001

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

200. 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 = 210018 AND W.type_id = 1) OR (W.util_id <> 210018 AND W.type_id = 2)) AND (M.post_util_id = 210018 OR M.dest_util_id = 210018) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

201. 0.0001

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

202. 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 = 210875 AND W.type_id = 1) OR (W.util_id <> 210875 AND W.type_id = 2)) AND (M.post_util_id = 210875 OR M.dest_util_id = 210875) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

203. 0.0001

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

204. 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 = 215934 AND W.type_id = 1) OR (W.util_id <> 215934 AND W.type_id = 2)) AND (M.post_util_id = 215934 OR M.dest_util_id = 215934) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

205. 0.0001

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

206. 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 = 216355 AND W.type_id = 1) OR (W.util_id <> 216355 AND W.type_id = 2)) AND (M.post_util_id = 216355 OR M.dest_util_id = 216355) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

207. 0.0001

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

208. 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 = 218691 AND W.type_id = 1) OR (W.util_id <> 218691 AND W.type_id = 2)) AND (M.post_util_id = 218691 OR M.dest_util_id = 218691) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

209. 0.0001

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

210. 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 = 207295 AND W.type_id = 1) OR (W.util_id <> 207295 AND W.type_id = 2)) AND (M.post_util_id = 207295 OR M.dest_util_id = 207295) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

211. 0.0001

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

212. 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 = 125158 AND W.type_id = 1) OR (W.util_id <> 125158 AND W.type_id = 2)) AND (M.post_util_id = 125158 OR M.dest_util_id = 125158) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

213. 0.0001

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

214. 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 = 198612 AND W.type_id = 1) OR (W.util_id <> 198612 AND W.type_id = 2)) AND (M.post_util_id = 198612 OR M.dest_util_id = 198612) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

215. 0.0001

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

216. 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 = 230319 AND W.type_id = 1) OR (W.util_id <> 230319 AND W.type_id = 2)) AND (M.post_util_id = 230319 OR M.dest_util_id = 230319) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

217. 0.0001

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

218. 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 = 232455 AND W.type_id = 1) OR (W.util_id <> 232455 AND W.type_id = 2)) AND (M.post_util_id = 232455 OR M.dest_util_id = 232455) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

219. 0.0001

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

220. 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 = 236474 AND W.type_id = 1) OR (W.util_id <> 236474 AND W.type_id = 2)) AND (M.post_util_id = 236474 OR M.dest_util_id = 236474) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

221. 0.0001

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

222. 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 = 240382 AND W.type_id = 1) OR (W.util_id <> 240382 AND W.type_id = 2)) AND (M.post_util_id = 240382 OR M.dest_util_id = 240382) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

223. 0.0001

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

224. 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 = 246995 AND W.type_id = 1) OR (W.util_id <> 246995 AND W.type_id = 2)) AND (M.post_util_id = 246995 OR M.dest_util_id = 246995) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

225. 0.0001

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

226. 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 <> ''

227. 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)

228. 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 = 253794 AND W.type_id = 1) OR (W.util_id <> 253794 AND W.type_id = 2)) AND (M.post_util_id = 253794 OR M.dest_util_id = 253794) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

229. 0.0001

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

230. 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 = 262178 AND W.type_id = 1) OR (W.util_id <> 262178 AND W.type_id = 2)) AND (M.post_util_id = 262178 OR M.dest_util_id = 262178) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

231. 0.0001

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

232. 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 = 264916 AND W.type_id = 1) OR (W.util_id <> 264916 AND W.type_id = 2)) AND (M.post_util_id = 264916 OR M.dest_util_id = 264916) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

233. 0.0001

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

234. 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 = 272588 AND W.type_id = 1) OR (W.util_id <> 272588 AND W.type_id = 2)) AND (M.post_util_id = 272588 OR M.dest_util_id = 272588) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

235. 0.0001

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

236. 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 = 272917 AND W.type_id = 1) OR (W.util_id <> 272917 AND W.type_id = 2)) AND (M.post_util_id = 272917 OR M.dest_util_id = 272917) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

237. 0.0001

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

238. 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 = 274409 AND W.type_id = 1) OR (W.util_id <> 274409 AND W.type_id = 2)) AND (M.post_util_id = 274409 OR M.dest_util_id = 274409) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

239. 0.0001

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

240. 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 = 283455 AND W.type_id = 1) OR (W.util_id <> 283455 AND W.type_id = 2)) AND (M.post_util_id = 283455 OR M.dest_util_id = 283455) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

241. 0.0001

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

242. 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 = 317831 AND W.type_id = 1) OR (W.util_id <> 317831 AND W.type_id = 2)) AND (M.post_util_id = 317831 OR M.dest_util_id = 317831) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

243. 0.0001

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

244. 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 = 322412 AND W.type_id = 1) OR (W.util_id <> 322412 AND W.type_id = 2)) AND (M.post_util_id = 322412 OR M.dest_util_id = 322412) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

245. 0.0001

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

246. 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 = 323305 AND W.type_id = 1) OR (W.util_id <> 323305 AND W.type_id = 2)) AND (M.post_util_id = 323305 OR M.dest_util_id = 323305) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

247. 0.0001

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

248. 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 = 325212 AND W.type_id = 1) OR (W.util_id <> 325212 AND W.type_id = 2)) AND (M.post_util_id = 325212 OR M.dest_util_id = 325212) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

249. 0.0001

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

250. 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 = 330221 AND W.type_id = 1) OR (W.util_id <> 330221 AND W.type_id = 2)) AND (M.post_util_id = 330221 OR M.dest_util_id = 330221) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

251. 0.0001

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

252. 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 = 334668 AND W.type_id = 1) OR (W.util_id <> 334668 AND W.type_id = 2)) AND (M.post_util_id = 334668 OR M.dest_util_id = 334668) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

253. 0.0001

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

254. 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 = 351963 AND W.type_id = 1) OR (W.util_id <> 351963 AND W.type_id = 2)) AND (M.post_util_id = 351963 OR M.dest_util_id = 351963) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

255. 0.0001

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

256. 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 = 356408 AND W.type_id = 1) OR (W.util_id <> 356408 AND W.type_id = 2)) AND (M.post_util_id = 356408 OR M.dest_util_id = 356408) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

257. 0.0001

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

258. 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 = 281445 AND W.type_id = 1) OR (W.util_id <> 281445 AND W.type_id = 2)) AND (M.post_util_id = 281445 OR M.dest_util_id = 281445) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

259. 0.0001

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

260. 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 = 364831 AND W.type_id = 1) OR (W.util_id <> 364831 AND W.type_id = 2)) AND (M.post_util_id = 364831 OR M.dest_util_id = 364831) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

261. 0.0001

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

262. 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 = 372382 AND W.type_id = 1) OR (W.util_id <> 372382 AND W.type_id = 2)) AND (M.post_util_id = 372382 OR M.dest_util_id = 372382) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

263. 0.0001

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

264. 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 = 374958 AND W.type_id = 1) OR (W.util_id <> 374958 AND W.type_id = 2)) AND (M.post_util_id = 374958 OR M.dest_util_id = 374958) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

265. 0.0001

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

266. 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 = 406342 AND W.type_id = 1) OR (W.util_id <> 406342 AND W.type_id = 2)) AND (M.post_util_id = 406342 OR M.dest_util_id = 406342) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

267. 0.0001

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

268. 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 = 418120 AND W.type_id = 1) OR (W.util_id <> 418120 AND W.type_id = 2)) AND (M.post_util_id = 418120 OR M.dest_util_id = 418120) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

269. 0.0001

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

270. 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 <> ''

271. 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)

272. 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 = 422402 AND W.type_id = 1) OR (W.util_id <> 422402 AND W.type_id = 2)) AND (M.post_util_id = 422402 OR M.dest_util_id = 422402) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

273. 0.0001

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

274. 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 = 424922 AND W.type_id = 1) OR (W.util_id <> 424922 AND W.type_id = 2)) AND (M.post_util_id = 424922 OR M.dest_util_id = 424922) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

275. 0.0001

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

276. 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 = 453002 AND W.type_id = 1) OR (W.util_id <> 453002 AND W.type_id = 2)) AND (M.post_util_id = 453002 OR M.dest_util_id = 453002) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

277. 0.0001

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

278. 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 = 456736 AND W.type_id = 1) OR (W.util_id <> 456736 AND W.type_id = 2)) AND (M.post_util_id = 456736 OR M.dest_util_id = 456736) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

279. 0.0001

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

280. 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 = 458229 AND W.type_id = 1) OR (W.util_id <> 458229 AND W.type_id = 2)) AND (M.post_util_id = 458229 OR M.dest_util_id = 458229) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

281. 0.0001

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

282. 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 = 443520 AND W.type_id = 1) OR (W.util_id <> 443520 AND W.type_id = 2)) AND (M.post_util_id = 443520 OR M.dest_util_id = 443520) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

283. 0.0001

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

284. 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 = 469349 AND W.type_id = 1) OR (W.util_id <> 469349 AND W.type_id = 2)) AND (M.post_util_id = 469349 OR M.dest_util_id = 469349) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

285. 0.0001

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

286. 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 = 312234 AND W.type_id = 1) OR (W.util_id <> 312234 AND W.type_id = 2)) AND (M.post_util_id = 312234 OR M.dest_util_id = 312234) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

287. 0.0001

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

288. 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 = 479437 AND W.type_id = 1) OR (W.util_id <> 479437 AND W.type_id = 2)) AND (M.post_util_id = 479437 OR M.dest_util_id = 479437) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

289. 0.0001

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

290. 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 = 481848 AND W.type_id = 1) OR (W.util_id <> 481848 AND W.type_id = 2)) AND (M.post_util_id = 481848 OR M.dest_util_id = 481848) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

291. 0.0001

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

292. 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 = 481966 AND W.type_id = 1) OR (W.util_id <> 481966 AND W.type_id = 2)) AND (M.post_util_id = 481966 OR M.dest_util_id = 481966) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

293. 0.0001

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

294. 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 = 458052 AND W.type_id = 1) OR (W.util_id <> 458052 AND W.type_id = 2)) AND (M.post_util_id = 458052 OR M.dest_util_id = 458052) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

295. 0.0001

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

296. 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 = 459078 AND W.type_id = 1) OR (W.util_id <> 459078 AND W.type_id = 2)) AND (M.post_util_id = 459078 OR M.dest_util_id = 459078) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

297. 0.0001

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

298. 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 = 378156 AND W.type_id = 1) OR (W.util_id <> 378156 AND W.type_id = 2)) AND (M.post_util_id = 378156 OR M.dest_util_id = 378156) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

299. 0.0001

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

300. 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 = 493944 AND W.type_id = 1) OR (W.util_id <> 493944 AND W.type_id = 2)) AND (M.post_util_id = 493944 OR M.dest_util_id = 493944) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

301. 0.0001

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

302. 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 = 488580 AND W.type_id = 1) OR (W.util_id <> 488580 AND W.type_id = 2)) AND (M.post_util_id = 488580 OR M.dest_util_id = 488580) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

303. 0.0001

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

304. 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 = 497836 AND W.type_id = 1) OR (W.util_id <> 497836 AND W.type_id = 2)) AND (M.post_util_id = 497836 OR M.dest_util_id = 497836) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

305. 0.0001

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

306. 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 = 512503 AND W.type_id = 1) OR (W.util_id <> 512503 AND W.type_id = 2)) AND (M.post_util_id = 512503 OR M.dest_util_id = 512503) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

307. 0.0001

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

308. 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 = 508334 AND W.type_id = 1) OR (W.util_id <> 508334 AND W.type_id = 2)) AND (M.post_util_id = 508334 OR M.dest_util_id = 508334) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

309. 0.0001

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

310. 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 = 78708 AND W.type_id = 1) OR (W.util_id <> 78708 AND W.type_id = 2)) AND (M.post_util_id = 78708 OR M.dest_util_id = 78708) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

311. 0.0001

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

312. 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 <> ''

313. 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)

314. 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 = 526634 AND W.type_id = 1) OR (W.util_id <> 526634 AND W.type_id = 2)) AND (M.post_util_id = 526634 OR M.dest_util_id = 526634) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

315. 0.0001

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

316. 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 = 541177 AND W.type_id = 1) OR (W.util_id <> 541177 AND W.type_id = 2)) AND (M.post_util_id = 541177 OR M.dest_util_id = 541177) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

317. 0.0001

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

318. 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 = 541391 AND W.type_id = 1) OR (W.util_id <> 541391 AND W.type_id = 2)) AND (M.post_util_id = 541391 OR M.dest_util_id = 541391) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''

319. 0.0001

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

320. 0.0001

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

321. 0.003

     SELECT ville_cp, ROUND((((acos(sin((48.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.23333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.686835678816 AND ville_latitude_deg<49.046564321184 AND ville_longitude_deg>1.9599018543365 AND ville_longitude_deg<2.5067581456635 HAVING distance <= 20 ORDER BY distance ASC

322. 0.0089

     SELECT ville_cp, ROUND((((acos(sin((48.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.23333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.417039197041 AND ville_latitude_deg<49.316360802959 AND ville_longitude_deg>1.5497537413096 AND ville_longitude_deg<2.9169062586904 HAVING distance <= 50 ORDER BY distance ASC

323. 0.0001

     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 (1031,939,1008)

324. 0.0002

     SELECT util_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id IN (253794,240382,216355,206223,185957,147658,139264,114246,111967,111276,58001,36348,18572,4253,78597,108668,378156,131387,236474,107421,87650,281445,323305,96210,70789,159989,459078,356408,115783,111898,497836,479437,458229,159074,71256,493944,103716,82997,80577,9317,312234,75329,64540,115399,119641,109922,334668,210875,93661,418120,210018,205660,154658,456736,84854)

325. 0.0002

     SELECT util_id, util_photo FROM util_info WHERE util_id IN (253794,240382,216355,206223,185957,147658,139264,114246,111967,111276,58001,36348,18572,4253,78597,108668,378156,131387,236474,107421,87650,281445,323305,96210,70789,159989,459078,356408,115783,111898,497836,479437,458229,159074,71256,493944,103716,82997,80577,9317,312234,75329,64540,115399,119641,109922,334668,210875,93661,418120,210018,205660,154658,456736,84854)

326. 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=39 AND ss.fami_id=3 ORDER BY ssrubr_order LIMIT 6,100

327. 0.0001

     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='étudiant' OR ssrubr_slug like '%étudiant%' OR MATCH (ssrubr_slug) AGAINST ('(+étudiant)')) AND sk.ssrubr_id='939' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10

328. 0.0001

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

329. 0.0001

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

330. 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

331. 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 (39) ORDER BY ssrubr_order ASC

332. 0.0009

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

333. 0.026

     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'

334. 0.0191

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

334 requetes sql en 0.1746