Demandes récentes de voisins

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='3' AND cate_title_slug='depanneur-reparateur'

3. 0

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

4. 0.0001

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

5. 0.0001

   SHOW TABLES LIKE 'pays'

6. 0.0002

   SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

7. 0.0002

   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

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

9. 0.0236

   SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='231' AND wish_visu IN (1,6,10)

10. 0.0001

    SELECT * FROM texte WHERE cate_id=231

11. 0.0712

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='231' AND type_id='2' AND wish_visu IN (1,6,10) GROUP BY wish_id

12. 0.0015

    SELECT util_id, util_photo, util_prenom, util_nom, stripe_account_id, util_verify FROM util_info WHERE util_id IN (2012,2165,3862,3914,4385,4921,5000,5290,5338,6110,6379,6464,7563,7644,7687,8249,8493,8852,9283,9393,9649,9723,9831,10543,10943,11077,10874,11862,13096,13272,13846,13961,5977,14504,14678,14692,14761,10274,15393,15533,15896,6261,16740,16910,17251,17259,17877,18237,18940,19279,19575,784,10320,20787,21154,21478,7631,21726,21860,23475,24033,24189,24310,24660,24769,25462,25526,25620,25961,26150,26362,26885,26940,26813,27040,19026,27949,24565,28184,28381,28435,28929,29134,29191,13145,29500,30266,30385,30487,30606,30729,31644,31937,32307,32383,32397,32401,32671,15043,32923,32962,33054,33411,33664,33702,33728,33963,34219,34329,34333,34623,29367,34823,34994,7917,35075,35295,35346,35378,36135,36271,36286,36472,37520,36301,38439,38576,39079,39131,39430,39463,39585,39595,1672,40023,40103,40628,40990,41145,33533,41744,42418,42795,42859,42933,43031,43209,43329,43662,43998,44042,44705,45098,45231,45422,44827,46279,19496,29264,46439,46495,46529,46884,46939,42382,47321,21754,47384,47148,47458,48035,48085,48195,48380,48931,48393,49040,49186,3110,49619,49726,49761,49943,50084,50375,49783,41044,50834,50845,50869,50899,50908,50602,51187,51337,23307,52175,52320,52468,52520,52540,52577,29265,52650,52658,52751,52926,52946,53465,18486,53551,53558,53561,53962,54107,54193,54674,54944,55072,55175,55208,55222,52876,55348,55480,55515,56348,48249,56601,56678,35945,56798,56869,56877,57075,57159,42343,57627,57781,57845,57882,58029,58094,58306,58463,58550,24713,58575,58709,58719,58748,58929,58995,59024,59087,59124,59169,59217,59277,59278,59881,59967,60174,60415,60489,60546,60550,61383,61780,61989,62109,62162,62341,62477,62515,62519,62537,62605,62665,62711,1919,63323,63333,63434,63529,63646,64073,64133,64167,64105,64300,64396,64595,64771,64858,65254,65422,65438,65518,65586,65640,65847,65883,65891,66195,66275,66434,66494,66721,66794,66842,67056,67254,67258,67303,67497,67540,67600,59650,68228,68277,68280,68289,68870,68964,69066,69181,69219,69295,69537,69599,69776,31423,70183,70204,70574,70661,71163,71290,71877,72109,72557,72566,72631,72688,72850,73044,73632,73717,73932,74046,74062,37763,74515,74593,74598,74865,75285,75317,75484,75877,76392,76396,76867,76895,77209,77285,6178,77468,77516,77576,77581,77695,50326,33740,20687,4432,78739,78771,79240,79308,79371,65006,6259,79723,79809,54194,4116,80498,80547,80579,26592,80696,80737,81011,81027,81046,81233,81519,81577,81600,81638,81708,81903,81920,82109,6928,82165,82188,82197,82224,82386,82408,82566,74387,82636,82770,82834,82890,82956,83195,83301,79893,83459,3044,83940,84006,84081,84159,84409,84654,84872,84886,85184,85218,85287,85293,85335,43393,82848,85604,85803,27308,44254,85979,4470,86295,86458,86467,86664,86836,86904,87085,87172,87206,87204,87353,87435,87552,83791,87642,36077,64276,86439,87754,88169,72477,55381,88384,88393,88472,88483,88515,88586,88931,89244,89058,7577,89903,90349,90874,90875,91049,91083,91195,91261,91501,91648,91712,91751,91855,92052,92483,92615,74531,44564,81043,93122,93137,93267,93355,93392,93450,93650,93954,94389,94343,94491,94672,94929,95080,95197,95769,96059,96072,93393,96237,96292,4123,7232,56251,96893,81237,97461,97597,97661,41231,97809,97905,98116,83730,98983,71498,48215,99647,99654,99671,99941,100044,100062,100393,100347,63320,100889,101293,75132,101371,101460,101572,101975,102323,102413,102523,93344,102663,102944,103149,103258,103553,103862,103929,104124,104313,104324,104390,104542,104693,105045,102733,105470,74660,105959,92970,106262,106304,106328,106884,106968,107028,107106,107502,107784,107834,107805,108351,108447,83251,108677)

13. 0.0001

    SELECT ssr.ssrubr_id, ssr.ssrubr_slug, ssr.ssrubr_mail, ssr.ssrubr_mail_bis, ssr.ssrubr_keywords, ssr.ssrubr_bt2, ssr.ssrubr_photo, c.cate_title_slug, f.fami_url FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id IN (581,963,582,975)

14. 0.0001

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

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

16. 0.0001

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

17. 0.0001

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

18. 0.0001

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

19. 0.0001

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

20. 0.0001

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

21. 0.0001

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

22. 0.0001

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

23. 0.0001

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

24. 0.0001

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

25. 0.0001

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

26. 0.0001

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

27. 0.0001

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

28. 0.0001

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

29. 0.0001

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

30. 0.0001

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

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

32. 0.0001

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

33. 0.0001

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

34. 0.0001

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

35. 0.0001

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

36. 0.0001

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

37. 0.0001

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

38. 0.0001

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

39. 0.0001

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

40. 0.0001

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

41. 0.0001

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

42. 0.0001

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

43. 0.0001

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

44. 0.0001

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

45. 0.0001

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

46. 0.0001

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

47. 0.0001

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

48. 0.0001

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

49. 0.0001

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

50. 0.0001

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

51. 0.0001

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

52. 0.0001

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

53. 0.0001

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

54. 0.0001

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

55. 0.0001

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

56. 0.0001

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

57. 0.0001

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

58. 0.0001

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

59. 0.0001

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

60. 0.0001

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

61. 0.0001

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

62. 0.0001

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

63. 0.0001

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

64. 0.0001

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

65. 0.0001

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

66. 0.0001

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

67. 0.0001

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

68. 0.0001

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

69. 0.0001

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

70. 0.0001

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

71. 0.0001

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

72. 0.0001

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

73. 0.0001

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

74. 0.0001

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

75. 0.0001

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

76. 0.0001

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

77. 0.0001

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

78. 0.0001

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

79. 0.0001

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

80. 0.0001

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

81. 0.0001

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

82. 0.0001

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

83. 0.0001

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

84. 0.0001

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

85. 0.0001

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

86. 0.0001

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

87. 0.0001

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

88. 0.0001

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

89. 0.0001

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

90. 0.0001

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

91. 0.0001

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

92. 0.0001

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

93. 0.0001

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

94. 0.0001

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

95. 0.0001

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

96. 0.0001

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

97. 0.0001

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

98. 0.0001

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

99. 0.0001

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

100. 0.0001

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

101. 0.0001

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

102. 0.0001

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

103. 0.0001

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

104. 0.0001

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

105. 0.0001

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

106. 0.0001

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

107. 0.0001

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

108. 0.0001

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

109. 0.0001

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

110. 0.0001

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

111. 0.0001

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

112. 0.0001

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

113. 0.0001

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

114. 0.0001

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

115. 0.0001

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

116. 0.0001

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

117. 0.0001

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

118. 0.0001

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

119. 0.0001

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

120. 0.0001

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

121. 0.0001

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

122. 0.0001

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

123. 0.0001

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

124. 0.0001

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

125. 0.0001

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

126. 0.0001

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

127. 0.0001

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

128. 0.0002

     SELECT util_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id IN (7631,21478,10320,21154,20787,784,8249,19575,19279,18940,6261,18237,17877,17259,17251,16910,16740,15533,15896,15393,10274,14761,14692,14678,14504,5977,13961,13846,13272,13096,11862,10874,11077,10943,10543,9831,9723,9649,9393,9283,8852,8493,7687,7644,7563,6464,6379,6110,5338,5290,5000,4921,4385,3914,3862,2165,2012)

129. 0.0001

     SELECT util_id, util_photo FROM util_info WHERE util_id IN (7631,21478,10320,21154,20787,784,8249,19575,19279,18940,6261,18237,17877,17259,17251,16910,16740,15533,15896,15393,10274,14761,14692,14678,14504,5977,13961,13846,13272,13096,11862,10874,11077,10943,10543,9831,9723,9649,9393,9283,8852,8493,7687,7644,7563,6464,6379,6110,5338,5290,5000,4921,4385,3914,3862,2165,2012)

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

131. 0.0001

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

132. 0

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

133. 0.0002

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

134. 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 (231) ORDER BY ssrubr_order ASC

135. 0.0012

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

136. 0.021

     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'

137. 0.0168

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

137 requetes sql en 0.1495