Location broyeur papier bureau à 75001 Paris

1. 0.0002

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

2. 0.0001

   SELECT cate_id FROM category WHERE fami_id='5' AND cate_title_slug='objet'

3. 0

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

4. 0

   SELECT filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('75' USING utf8mb4) COLLATE utf8mb4_general_ci

5. 0.0001

   SELECT ville_nom FROM villes WHERE ville_cp='75001' AND ville_nom like '%paris%' 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 '%broyeur%papier%bureau%' OR ssrubr_title like '%broyeur%papier%bureau%' OR ssrubr_slug like '%broyeur%papier%bureau%') AND cate_id='92' ORDER BY ssrubr_id LIMIT 0,1

8. 0.0001

   SELECT cate_title_form, cate_title FROM category WHERE cate_title='broyeur%papier%bureau' OR cate_title_aff='broyeur%papier%bureau' LIMIT 0,1

9. 0.0001

   SHOW TABLES LIKE 'pays'

10. 0.0002

    SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

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

12. 0.0001

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

13. 0.0027

    SELECT ville_cp, ROUND((((acos(sin((48.86*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.86*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.34445- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.680135678816 AND ville_latitude_deg<49.039864321184 AND ville_longitude_deg>2.0710584569437 AND ville_longitude_deg<2.6178415430563 HAVING distance <= 20 ORDER BY distance ASC

14. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='broyeur papier bureau'

15. 0.0014

    SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='92' AND wish_visu IN (1,6,10) AND wish_cp like '75001%'

16. 0.0001

    SELECT * FROM texte WHERE cate_id=92

17. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='broyeur papier bureau' OR ssrubr_slug='broyeur-papier-bureau' OR (ssrubr_title like '%broyeur papier bureau%')) AND cate_id='92' ORDER BY ssrubr_id LIMIT 0,1

18. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='broyeur-papier-bureau' AND cate_id='92'

19. 0.0001

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

20. 0.0008

    SELECT ville_cp, ROUND((((acos(sin((48.86*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.86*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.34445- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.797047487586 AND ville_latitude_deg<48.922952512414 AND ville_longitude_deg>2.2487630978401 AND ville_longitude_deg<2.4401369021599 HAVING distance <= 7 ORDER BY distance ASC

21. 0.0077

    SELECT ville_cp, ROUND((((acos(sin((48.86*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.86*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.34445- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.410339197041 AND ville_latitude_deg<49.309660802959 AND ville_longitude_deg>1.6609652486165 AND ville_longitude_deg<3.0279347513835 HAVING distance <= 50 ORDER BY distance ASC

22. 0.0859

    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.86*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.86*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.34445- 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='5' AND cate_id='92' AND wish_visu IN (1,6,10) AND wish_cp IN (75001,75007,75002,75000,75001,75017,75006,75116,75020,75018,75015,75019,75003,75004,75014,75013,75012,75011,75010,75009,75008,75016,75005,92170,93400,93310,94250,94270,92120,93170,92110,94205,94200,92240,93500,94160,92200,92300,93100,94300,94110,94800,93120,93300,93230,93260,92600,94220,92220,92130,92100,92400,92320,92800,92150,93450,92390,92250,93200,93210,92270,94140,94233,94235,94231,94232,94236,94237,94234,94230,94239,94238,94240,92140,92230,93000,93130,94700,92700,94400,92360,92190,92210,94410,92260,92330,92340,93350,93140,94340,93110,94120,92350,93800,94550,93240,94130,94320,92500,93430,93700,93150,93440,94170,92000,92310,94600,93250,92290,92410,95360,92380,93380,95880,95100,94150,78800,94000,95870,94260,92370,93360,92160,95218,95210,92420,92430,94390,94310,94360,95140,94100,94210,94340,78420,93320,93340,91370,94500,95500,78140,95410,95110,95170,93330,93220,95230,91320,94430,78170,78400,94380,78220,95400,91300,95120,94290,94460,94350,91570,78500,78290,78380,78360,95160,95350,95500,95400,95200,95580,95580,95130,91550,93270,94190,93600,95600,93460,93190,93390,93160,91200,78150,78350,78430,95530,94480,78000,93370,78560,91430,78150,94420,78110,94380,94370,95240,94490,94880,94880,91120,78600,94450,95350,95130,94470,91430,95440,91560,91420,95500,95680,78600,95370,91160,91380,93410,93420,95390,78230,91270,93470,77181,95500,95720,78530,78350,91160,77420,95320,77500,91140,78160,78870,91400,78750,95330,95460,91230,94510,95190,91330,78100,91260,95720) AND type_id=1 GROUP BY wish_id

23. 0.0006

    SELECT util_id, util_photo, util_prenom, util_nom, stripe_account_id, util_verify FROM util_info WHERE util_id IN (16120,24956,48059,41964,58569,60508,70037,74318,75496,68073,85145,93477,93709,102612,105325,60908,107232,111102,115356,115889,114726,119587,124932,131191,131937,132661,94354,74981,143192,100243,148274,151332,153352,154049,155497,159498,108668,168062,170211,165262,180265,183397,184170,188975,182724,196385,173886,204283,206004,206852,210093,214971,212528,216476,218999,220066,228734,229761,114884,236651,237943,241522,251346,252091,208924,262128,262908,265882,266147,277021,108696,285141,286315,286482,290143,295263,303665,308284,267798,116561,272982,311384,316888,316981,322543,323954,273803,196741,236652,311956,335412,339026,339609,312637,341195,186004,345825,341504,352168,355393,215115,357165,360066,369168,378370,379779,382884,99073,388154,392125,393133,393883,395887,396128,396104,396942,94304,389084,400389,408903,202226,412044,412220,418330,313652,45286,422171,430284,430405,430680,367942,309056,401274,445785,92365,457990,463638,311741,58133,472304,474670,471981,480854,489081,495548,115760,497562,503171,504047,505318,384664,71031,509999,195222,510536,400482,421715,517280,197534,357876,523362,525869,526258,526634,327103,531659,532702,457703,533543,534673,534232,538843,540938,44634,542989,544462,544713,545214,546142,546212,546466,546509,546878,547267,547490,539359,548007,428269,541151)

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

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

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

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

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

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

46. 0.0007

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

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

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

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

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

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

58. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 111102 AND W.type_id = 1) OR (W.util_id <> 111102 AND W.type_id = 2)) AND (M.post_util_id = 111102 OR M.dest_util_id = 111102) 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=111102 AND note_visu IN (1,3,4)

60. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 115356 AND W.type_id = 1) OR (W.util_id <> 115356 AND W.type_id = 2)) AND (M.post_util_id = 115356 OR M.dest_util_id = 115356) 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=115356 AND note_visu IN (1,3,4)

62. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 115889 AND W.type_id = 1) OR (W.util_id <> 115889 AND W.type_id = 2)) AND (M.post_util_id = 115889 OR M.dest_util_id = 115889) 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=115889 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 = 114726 AND W.type_id = 1) OR (W.util_id <> 114726 AND W.type_id = 2)) AND (M.post_util_id = 114726 OR M.dest_util_id = 114726) 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=114726 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 = 119587 AND W.type_id = 1) OR (W.util_id <> 119587 AND W.type_id = 2)) AND (M.post_util_id = 119587 OR M.dest_util_id = 119587) 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=119587 AND note_visu IN (1,3,4)

68. 0.0002

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 124932 AND W.type_id = 1) OR (W.util_id <> 124932 AND W.type_id = 2)) AND (M.post_util_id = 124932 OR M.dest_util_id = 124932) 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=124932 AND note_visu IN (1,3,4)

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

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

76. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 94354 AND W.type_id = 1) OR (W.util_id <> 94354 AND W.type_id = 2)) AND (M.post_util_id = 94354 OR M.dest_util_id = 94354) 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=94354 AND note_visu IN (1,3,4)

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

82. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 100243 AND W.type_id = 1) OR (W.util_id <> 100243 AND W.type_id = 2)) AND (M.post_util_id = 100243 OR M.dest_util_id = 100243) 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=100243 AND note_visu IN (1,3,4)

84. 0.0001

    SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 148274 AND W.type_id = 1) OR (W.util_id <> 148274 AND W.type_id = 2)) AND (M.post_util_id = 148274 OR M.dest_util_id = 148274) 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=148274 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 = 151332 AND W.type_id = 1) OR (W.util_id <> 151332 AND W.type_id = 2)) AND (M.post_util_id = 151332 OR M.dest_util_id = 151332) 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=151332 AND note_visu IN (1,3,4)

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

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

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

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

96. 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 = 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 <> ''

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

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

100. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 170211 AND W.type_id = 1) OR (W.util_id <> 170211 AND W.type_id = 2)) AND (M.post_util_id = 170211 OR M.dest_util_id = 170211) 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=170211 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 = 165262 AND W.type_id = 1) OR (W.util_id <> 165262 AND W.type_id = 2)) AND (M.post_util_id = 165262 OR M.dest_util_id = 165262) 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=165262 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 = 180265 AND W.type_id = 1) OR (W.util_id <> 180265 AND W.type_id = 2)) AND (M.post_util_id = 180265 OR M.dest_util_id = 180265) 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=180265 AND note_visu IN (1,3,4)

106. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 183397 AND W.type_id = 1) OR (W.util_id <> 183397 AND W.type_id = 2)) AND (M.post_util_id = 183397 OR M.dest_util_id = 183397) 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=183397 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 = 184170 AND W.type_id = 1) OR (W.util_id <> 184170 AND W.type_id = 2)) AND (M.post_util_id = 184170 OR M.dest_util_id = 184170) 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=184170 AND note_visu IN (1,3,4)

110. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 188975 AND W.type_id = 1) OR (W.util_id <> 188975 AND W.type_id = 2)) AND (M.post_util_id = 188975 OR M.dest_util_id = 188975) 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=188975 AND note_visu IN (1,3,4)

112. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 182724 AND W.type_id = 1) OR (W.util_id <> 182724 AND W.type_id = 2)) AND (M.post_util_id = 182724 OR M.dest_util_id = 182724) 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=182724 AND note_visu IN (1,3,4)

114. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 196385 AND W.type_id = 1) OR (W.util_id <> 196385 AND W.type_id = 2)) AND (M.post_util_id = 196385 OR M.dest_util_id = 196385) 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=196385 AND note_visu IN (1,3,4)

116. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 173886 AND W.type_id = 1) OR (W.util_id <> 173886 AND W.type_id = 2)) AND (M.post_util_id = 173886 OR M.dest_util_id = 173886) 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=173886 AND note_visu IN (1,3,4)

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

120. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 206004 AND W.type_id = 1) OR (W.util_id <> 206004 AND W.type_id = 2)) AND (M.post_util_id = 206004 OR M.dest_util_id = 206004) 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=206004 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 = 206852 AND W.type_id = 1) OR (W.util_id <> 206852 AND W.type_id = 2)) AND (M.post_util_id = 206852 OR M.dest_util_id = 206852) 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=206852 AND note_visu IN (1,3,4)

124. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 210093 AND W.type_id = 1) OR (W.util_id <> 210093 AND W.type_id = 2)) AND (M.post_util_id = 210093 OR M.dest_util_id = 210093) 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=210093 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 = 214971 AND W.type_id = 1) OR (W.util_id <> 214971 AND W.type_id = 2)) AND (M.post_util_id = 214971 OR M.dest_util_id = 214971) 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=214971 AND note_visu IN (1,3,4)

128. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 212528 AND W.type_id = 1) OR (W.util_id <> 212528 AND W.type_id = 2)) AND (M.post_util_id = 212528 OR M.dest_util_id = 212528) 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=212528 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 = 216476 AND W.type_id = 1) OR (W.util_id <> 216476 AND W.type_id = 2)) AND (M.post_util_id = 216476 OR M.dest_util_id = 216476) 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=216476 AND note_visu IN (1,3,4)

132. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 218999 AND W.type_id = 1) OR (W.util_id <> 218999 AND W.type_id = 2)) AND (M.post_util_id = 218999 OR M.dest_util_id = 218999) 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=218999 AND note_visu IN (1,3,4)

134. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 220066 AND W.type_id = 1) OR (W.util_id <> 220066 AND W.type_id = 2)) AND (M.post_util_id = 220066 OR M.dest_util_id = 220066) 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=220066 AND note_visu IN (1,3,4)

136. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 228734 AND W.type_id = 1) OR (W.util_id <> 228734 AND W.type_id = 2)) AND (M.post_util_id = 228734 OR M.dest_util_id = 228734) 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=228734 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 = 229761 AND W.type_id = 1) OR (W.util_id <> 229761 AND W.type_id = 2)) AND (M.post_util_id = 229761 OR M.dest_util_id = 229761) 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=229761 AND note_visu IN (1,3,4)

140. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 114884 AND W.type_id = 1) OR (W.util_id <> 114884 AND W.type_id = 2)) AND (M.post_util_id = 114884 OR M.dest_util_id = 114884) 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=114884 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 = 236651 AND W.type_id = 1) OR (W.util_id <> 236651 AND W.type_id = 2)) AND (M.post_util_id = 236651 OR M.dest_util_id = 236651) 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=236651 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 = 237943 AND W.type_id = 1) OR (W.util_id <> 237943 AND W.type_id = 2)) AND (M.post_util_id = 237943 OR M.dest_util_id = 237943) 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=237943 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 = 241522 AND W.type_id = 1) OR (W.util_id <> 241522 AND W.type_id = 2)) AND (M.post_util_id = 241522 OR M.dest_util_id = 241522) 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=241522 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 = 251346 AND W.type_id = 1) OR (W.util_id <> 251346 AND W.type_id = 2)) AND (M.post_util_id = 251346 OR M.dest_util_id = 251346) 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=251346 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 = 252091 AND W.type_id = 1) OR (W.util_id <> 252091 AND W.type_id = 2)) AND (M.post_util_id = 252091 OR M.dest_util_id = 252091) 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=252091 AND note_visu IN (1,3,4)

152. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 208924 AND W.type_id = 1) OR (W.util_id <> 208924 AND W.type_id = 2)) AND (M.post_util_id = 208924 OR M.dest_util_id = 208924) 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=208924 AND note_visu IN (1,3,4)

154. 0.0001

     SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 262128 AND W.type_id = 1) OR (W.util_id <> 262128 AND W.type_id = 2)) AND (M.post_util_id = 262128 OR M.dest_util_id = 262128) 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=262128 AND note_visu IN (1,3,4)

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

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

162. 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 = 277021 AND W.type_id = 1) OR (W.util_id <> 277021 AND W.type_id = 2)) AND (M.post_util_id = 277021 OR M.dest_util_id = 277021) 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=277021 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 = 108696 AND W.type_id = 1) OR (W.util_id <> 108696 AND W.type_id = 2)) AND (M.post_util_id = 108696 OR M.dest_util_id = 108696) 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=108696 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 = 285141 AND W.type_id = 1) OR (W.util_id <> 285141 AND W.type_id = 2)) AND (M.post_util_id = 285141 OR M.dest_util_id = 285141) 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=285141 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 = 286315 AND W.type_id = 1) OR (W.util_id <> 286315 AND W.type_id = 2)) AND (M.post_util_id = 286315 OR M.dest_util_id = 286315) 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=286315 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 = 286482 AND W.type_id = 1) OR (W.util_id <> 286482 AND W.type_id = 2)) AND (M.post_util_id = 286482 OR M.dest_util_id = 286482) 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=286482 AND note_visu IN (1,3,4)

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

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

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

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

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

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

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

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

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

194. 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 = 323954 AND W.type_id = 1) OR (W.util_id <> 323954 AND W.type_id = 2)) AND (M.post_util_id = 323954 OR M.dest_util_id = 323954) 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=323954 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 = 273803 AND W.type_id = 1) OR (W.util_id <> 273803 AND W.type_id = 2)) AND (M.post_util_id = 273803 OR M.dest_util_id = 273803) 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=273803 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 = 196741 AND W.type_id = 1) OR (W.util_id <> 196741 AND W.type_id = 2)) AND (M.post_util_id = 196741 OR M.dest_util_id = 196741) 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=196741 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 = 236652 AND W.type_id = 1) OR (W.util_id <> 236652 AND W.type_id = 2)) AND (M.post_util_id = 236652 OR M.dest_util_id = 236652) 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=236652 AND note_visu IN (1,3,4)

202. 0.0007

     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 = 311956 AND W.type_id = 1) OR (W.util_id <> 311956 AND W.type_id = 2)) AND (M.post_util_id = 311956 OR M.dest_util_id = 311956) 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=311956 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 = 335412 AND W.type_id = 1) OR (W.util_id <> 335412 AND W.type_id = 2)) AND (M.post_util_id = 335412 OR M.dest_util_id = 335412) 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=335412 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 = 339026 AND W.type_id = 1) OR (W.util_id <> 339026 AND W.type_id = 2)) AND (M.post_util_id = 339026 OR M.dest_util_id = 339026) 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=339026 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 = 339609 AND W.type_id = 1) OR (W.util_id <> 339609 AND W.type_id = 2)) AND (M.post_util_id = 339609 OR M.dest_util_id = 339609) 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=339609 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 = 312637 AND W.type_id = 1) OR (W.util_id <> 312637 AND W.type_id = 2)) AND (M.post_util_id = 312637 OR M.dest_util_id = 312637) 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=312637 AND note_visu IN (1,3,4)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

259. 0.0001

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

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

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

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

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

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

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

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

288. 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 = 401274 AND W.type_id = 1) OR (W.util_id <> 401274 AND W.type_id = 2)) AND (M.post_util_id = 401274 OR M.dest_util_id = 401274) 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=401274 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 = 445785 AND W.type_id = 1) OR (W.util_id <> 445785 AND W.type_id = 2)) AND (M.post_util_id = 445785 OR M.dest_util_id = 445785) 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=445785 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 = 92365 AND W.type_id = 1) OR (W.util_id <> 92365 AND W.type_id = 2)) AND (M.post_util_id = 92365 OR M.dest_util_id = 92365) 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=92365 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 = 457990 AND W.type_id = 1) OR (W.util_id <> 457990 AND W.type_id = 2)) AND (M.post_util_id = 457990 OR M.dest_util_id = 457990) 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=457990 AND note_visu IN (1,3,4)

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

302. 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 = 472304 AND W.type_id = 1) OR (W.util_id <> 472304 AND W.type_id = 2)) AND (M.post_util_id = 472304 OR M.dest_util_id = 472304) 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=472304 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 = 474670 AND W.type_id = 1) OR (W.util_id <> 474670 AND W.type_id = 2)) AND (M.post_util_id = 474670 OR M.dest_util_id = 474670) 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=474670 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 = 471981 AND W.type_id = 1) OR (W.util_id <> 471981 AND W.type_id = 2)) AND (M.post_util_id = 471981 OR M.dest_util_id = 471981) 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=471981 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 = 480854 AND W.type_id = 1) OR (W.util_id <> 480854 AND W.type_id = 2)) AND (M.post_util_id = 480854 OR M.dest_util_id = 480854) 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=480854 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 = 489081 AND W.type_id = 1) OR (W.util_id <> 489081 AND W.type_id = 2)) AND (M.post_util_id = 489081 OR M.dest_util_id = 489081) 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=489081 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 = 495548 AND W.type_id = 1) OR (W.util_id <> 495548 AND W.type_id = 2)) AND (M.post_util_id = 495548 OR M.dest_util_id = 495548) 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=495548 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 = 115760 AND W.type_id = 1) OR (W.util_id <> 115760 AND W.type_id = 2)) AND (M.post_util_id = 115760 OR M.dest_util_id = 115760) 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=115760 AND note_visu IN (1,3,4)

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

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

321. 0.0001

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

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

323. 0.0001

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

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

325. 0.0001

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

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

327. 0.0001

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

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

329. 0.0001

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

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

331. 0.0001

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

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

333. 0.0001

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

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

335. 0.0001

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

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

337. 0.0001

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

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

339. 0.0001

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

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

341. 0.0001

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

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

343. 0.0001

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

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

345. 0.0001

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

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

347. 0.0001

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

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

349. 0.0001

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

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

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

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

353. 0.0001

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

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

355. 0.0001

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

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

357. 0.0001

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

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

359. 0.0001

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

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

361. 0.0001

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

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

363. 0.0001

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

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

365. 0.0001

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

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

367. 0.0001

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

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

369. 0.0001

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

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

371. 0.0001

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

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

373. 0.0001

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

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

375. 0.0001

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

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

377. 0.0001

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

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

379. 0.0001

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

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

381. 0.0001

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

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

383. 0.0001

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

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

385. 0.0001

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

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

387. 0.0001

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

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

389. 0.0001

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

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

391. 0.0001

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

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

393. 0.0001

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

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

395. 0.0001

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

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

397. 0.0001

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

398. 0.0003

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

399. 0.0001

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

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

401. 0.0001

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

402. 0.0001

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

403. 0.0008

     SELECT ville_cp, ROUND((((acos(sin((48.86*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.86*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.34445- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.797047487586 AND ville_latitude_deg<48.922952512414 AND ville_longitude_deg>2.2487630978401 AND ville_longitude_deg<2.4401369021599 HAVING distance <= 7 ORDER BY distance ASC

404. 0.0082

     SELECT ville_cp, ROUND((((acos(sin((48.86*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.86*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.34445- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.410339197041 AND ville_latitude_deg<49.309660802959 AND ville_longitude_deg>1.6609652486165 AND ville_longitude_deg<3.0279347513835 HAVING distance <= 50 ORDER BY distance ASC

405. 0.0002

     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 (1149,721,816,815,823,827,822,828,825,1176,998,824,826)

406. 0.0002

     SELECT util_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id IN (457703,471981,357876,379779,115356,197534,412220,184170,74981,401274,93477,539359,412044,303665,68073,532702,509999,382884,262128,251346,153352,548007,546466,545214,544713,526634,504047,489081,472304,396942,393883,393133,378370,357165,355393,322543,316981,262908,114884,218999,196385,183397,168062,159498,132661,131937)

407. 0.0002

     SELECT util_id, util_photo FROM util_info WHERE util_id IN (457703,471981,357876,379779,115356,197534,412220,184170,74981,401274,93477,539359,412044,303665,68073,532702,509999,382884,262128,251346,153352,548007,546466,545214,544713,526634,504047,489081,472304,396942,393883,393133,378370,357165,355393,322543,316981,262908,114884,218999,196385,183397,168062,159498,132661,131937)

408. 0.0002

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

409. 0.0001

     SELECT ss.ssrubr_id, ss.ssrubr_slug, ss.ssrubr_title, ss.ssrubr_keywords, ss.ssrubr_mail, c.cate_title_slug FROM ssrubr ss INNER JOIN category c ON ss.cate_id = c.cate_id WHERE ss.ssrubr_slug = 'broyeur-papier-bureau' AND ss.cate_id = 92 LIMIT 1

410. 0.0002

     SELECT ss.ssrubr_id, ss.ssrubr_slug, ss.ssrubr_title, ss.ssrubr_keywords, ss.ssrubr_mail, c.cate_title_slug FROM ssrubr ss INNER JOIN category c ON ss.cate_id = c.cate_id WHERE ss.ssrubr_visu = 1 AND ss.fami_id = 5 AND ss.cate_id = 92 ORDER BY ss.ssrubr_order ASC, ss.ssrubr_id ASC LIMIT 10

411. 0.0001

     SELECT ss.ssrubr_id, ss.ssrubr_slug, ss.ssrubr_title, ss.ssrubr_keywords, ss.ssrubr_mail, c.cate_title_slug FROM ssrubr ss INNER JOIN category c ON ss.cate_id = c.cate_id WHERE ss.ssrubr_slug = 'broyeur-papier-bureau' AND ss.cate_id = 92 LIMIT 1

412. 0.0001

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

413. 0

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

414. 0.0001

     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='5' AND cate_cate_id IS NULL ORDER BY cate_order ASC

415. 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 (92) ORDER BY ssrubr_order ASC

416. 0.0009

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

417. 0.0264

     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'

418. 0.018

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

418 requetes sql en 0.1988