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

8. 0.0004

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

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

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

    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.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 (963,582,581,975,1132)

14. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=98116 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 = 98116 AND W.type_id = 1) OR (W.util_id <> 98116 AND W.type_id = 2)) AND (M.post_util_id = 98116 OR M.dest_util_id = 98116) 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=41231 AND note_visu IN (1,3,4)

17. 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 = 41231 AND W.type_id = 1) OR (W.util_id <> 41231 AND W.type_id = 2)) AND (M.post_util_id = 41231 OR M.dest_util_id = 41231) 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=97905 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 = 97905 AND W.type_id = 1) OR (W.util_id <> 97905 AND W.type_id = 2)) AND (M.post_util_id = 97905 OR M.dest_util_id = 97905) 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=97809 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 = 97809 AND W.type_id = 1) OR (W.util_id <> 97809 AND W.type_id = 2)) AND (M.post_util_id = 97809 OR M.dest_util_id = 97809) 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=97661 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 = 97661 AND W.type_id = 1) OR (W.util_id <> 97661 AND W.type_id = 2)) AND (M.post_util_id = 97661 OR M.dest_util_id = 97661) 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=97597 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 = 97597 AND W.type_id = 1) OR (W.util_id <> 97597 AND W.type_id = 2)) AND (M.post_util_id = 97597 OR M.dest_util_id = 97597) 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=97461 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 = 97461 AND W.type_id = 1) OR (W.util_id <> 97461 AND W.type_id = 2)) AND (M.post_util_id = 97461 OR M.dest_util_id = 97461) 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=81237 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 = 81237 AND W.type_id = 1) OR (W.util_id <> 81237 AND W.type_id = 2)) AND (M.post_util_id = 81237 OR M.dest_util_id = 81237) 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=96893 AND note_visu IN (1,3,4)

31. 0.0001

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

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

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

37. 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 = 4123 AND W.type_id = 1) OR (W.util_id <> 4123 AND W.type_id = 2)) AND (M.post_util_id = 4123 OR M.dest_util_id = 4123) 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=96292 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 = 96292 AND W.type_id = 1) OR (W.util_id <> 96292 AND W.type_id = 2)) AND (M.post_util_id = 96292 OR M.dest_util_id = 96292) 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=96237 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 = 96237 AND W.type_id = 1) OR (W.util_id <> 96237 AND W.type_id = 2)) AND (M.post_util_id = 96237 OR M.dest_util_id = 96237) 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=93393 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 = 93393 AND W.type_id = 1) OR (W.util_id <> 93393 AND W.type_id = 2)) AND (M.post_util_id = 93393 OR M.dest_util_id = 93393) 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=96072 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 = 96072 AND W.type_id = 1) OR (W.util_id <> 96072 AND W.type_id = 2)) AND (M.post_util_id = 96072 OR M.dest_util_id = 96072) 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=96059 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 = 96059 AND W.type_id = 1) OR (W.util_id <> 96059 AND W.type_id = 2)) AND (M.post_util_id = 96059 OR M.dest_util_id = 96059) 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=95769 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 = 95769 AND W.type_id = 1) OR (W.util_id <> 95769 AND W.type_id = 2)) AND (M.post_util_id = 95769 OR M.dest_util_id = 95769) 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=95197 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 = 95197 AND W.type_id = 1) OR (W.util_id <> 95197 AND W.type_id = 2)) AND (M.post_util_id = 95197 OR M.dest_util_id = 95197) 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=95080 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 = 95080 AND W.type_id = 1) OR (W.util_id <> 95080 AND W.type_id = 2)) AND (M.post_util_id = 95080 OR M.dest_util_id = 95080) 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=94929 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 = 94929 AND W.type_id = 1) OR (W.util_id <> 94929 AND W.type_id = 2)) AND (M.post_util_id = 94929 OR M.dest_util_id = 94929) 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=94672 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 = 94672 AND W.type_id = 1) OR (W.util_id <> 94672 AND W.type_id = 2)) AND (M.post_util_id = 94672 OR M.dest_util_id = 94672) 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=94491 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 = 94491 AND W.type_id = 1) OR (W.util_id <> 94491 AND W.type_id = 2)) AND (M.post_util_id = 94491 OR M.dest_util_id = 94491) 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=94343 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 = 94343 AND W.type_id = 1) OR (W.util_id <> 94343 AND W.type_id = 2)) AND (M.post_util_id = 94343 OR M.dest_util_id = 94343) 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=94389 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 = 94389 AND W.type_id = 1) OR (W.util_id <> 94389 AND W.type_id = 2)) AND (M.post_util_id = 94389 OR M.dest_util_id = 94389) 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=93954 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 = 93954 AND W.type_id = 1) OR (W.util_id <> 93954 AND W.type_id = 2)) AND (M.post_util_id = 93954 OR M.dest_util_id = 93954) 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=93650 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 = 93650 AND W.type_id = 1) OR (W.util_id <> 93650 AND W.type_id = 2)) AND (M.post_util_id = 93650 OR M.dest_util_id = 93650) 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=93450 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 = 93450 AND W.type_id = 1) OR (W.util_id <> 93450 AND W.type_id = 2)) AND (M.post_util_id = 93450 OR M.dest_util_id = 93450) 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=93392 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 = 93392 AND W.type_id = 1) OR (W.util_id <> 93392 AND W.type_id = 2)) AND (M.post_util_id = 93392 OR M.dest_util_id = 93392) 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=93355 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 = 93355 AND W.type_id = 1) OR (W.util_id <> 93355 AND W.type_id = 2)) AND (M.post_util_id = 93355 OR M.dest_util_id = 93355) 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=93267 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 = 93267 AND W.type_id = 1) OR (W.util_id <> 93267 AND W.type_id = 2)) AND (M.post_util_id = 93267 OR M.dest_util_id = 93267) 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=93137 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 = 93137 AND W.type_id = 1) OR (W.util_id <> 93137 AND W.type_id = 2)) AND (M.post_util_id = 93137 OR M.dest_util_id = 93137) 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=93122 AND note_visu IN (1,3,4)

79. 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 = 93122 AND W.type_id = 1) OR (W.util_id <> 93122 AND W.type_id = 2)) AND (M.post_util_id = 93122 OR M.dest_util_id = 93122) 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=81043 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 = 81043 AND W.type_id = 1) OR (W.util_id <> 81043 AND W.type_id = 2)) AND (M.post_util_id = 81043 OR M.dest_util_id = 81043) 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=44564 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 = 44564 AND W.type_id = 1) OR (W.util_id <> 44564 AND W.type_id = 2)) AND (M.post_util_id = 44564 OR M.dest_util_id = 44564) 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=74531 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 = 74531 AND W.type_id = 1) OR (W.util_id <> 74531 AND W.type_id = 2)) AND (M.post_util_id = 74531 OR M.dest_util_id = 74531) 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=92615 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 = 92615 AND W.type_id = 1) OR (W.util_id <> 92615 AND W.type_id = 2)) AND (M.post_util_id = 92615 OR M.dest_util_id = 92615) 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=92483 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 = 92483 AND W.type_id = 1) OR (W.util_id <> 92483 AND W.type_id = 2)) AND (M.post_util_id = 92483 OR M.dest_util_id = 92483) 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=92052 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 = 92052 AND W.type_id = 1) OR (W.util_id <> 92052 AND W.type_id = 2)) AND (M.post_util_id = 92052 OR M.dest_util_id = 92052) 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=91855 AND note_visu IN (1,3,4)

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

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

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

103. 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 = 91261 AND W.type_id = 1) OR (W.util_id <> 91261 AND W.type_id = 2)) AND (M.post_util_id = 91261 OR M.dest_util_id = 91261) 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=91195 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 = 91195 AND W.type_id = 1) OR (W.util_id <> 91195 AND W.type_id = 2)) AND (M.post_util_id = 91195 OR M.dest_util_id = 91195) 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=91083 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 = 91083 AND W.type_id = 1) OR (W.util_id <> 91083 AND W.type_id = 2)) AND (M.post_util_id = 91083 OR M.dest_util_id = 91083) 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=91049 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 = 91049 AND W.type_id = 1) OR (W.util_id <> 91049 AND W.type_id = 2)) AND (M.post_util_id = 91049 OR M.dest_util_id = 91049) 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=90875 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 = 90875 AND W.type_id = 1) OR (W.util_id <> 90875 AND W.type_id = 2)) AND (M.post_util_id = 90875 OR M.dest_util_id = 90875) 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=90874 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 = 90874 AND W.type_id = 1) OR (W.util_id <> 90874 AND W.type_id = 2)) AND (M.post_util_id = 90874 OR M.dest_util_id = 90874) 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=90349 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 = 90349 AND W.type_id = 1) OR (W.util_id <> 90349 AND W.type_id = 2)) AND (M.post_util_id = 90349 OR M.dest_util_id = 90349) 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=89903 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 = 89903 AND W.type_id = 1) OR (W.util_id <> 89903 AND W.type_id = 2)) AND (M.post_util_id = 89903 OR M.dest_util_id = 89903) 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=7577 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 = 7577 AND W.type_id = 1) OR (W.util_id <> 7577 AND W.type_id = 2)) AND (M.post_util_id = 7577 OR M.dest_util_id = 7577) 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=89058 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 = 89058 AND W.type_id = 1) OR (W.util_id <> 89058 AND W.type_id = 2)) AND (M.post_util_id = 89058 OR M.dest_util_id = 89058) 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=89244 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 = 89244 AND W.type_id = 1) OR (W.util_id <> 89244 AND W.type_id = 2)) AND (M.post_util_id = 89244 OR M.dest_util_id = 89244) 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=88931 AND note_visu IN (1,3,4)

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

128. 0.0001

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

129. 0.0001

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

130. 0.0001

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

131. 0.0001

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

132. 0.0001

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

133. 0.0001

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

134. 0.0003

     SELECT util_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id IN (98116,41231,97905,97809,97661,97597,97461,81237,96893,56251,7232,4123,96292,96237,93393,96072,96059,95769,95197,95080,94929,94672,94491,94343,94389,93954,93650,93450,93392,93355,93267,93137,93122,81043,44564,74531,92615,92483,92052,91855,91751,91712,91648,91501,91261,91195,91083,91049,90875,90874,90349,89903,7577,89058,89244,88931,88586,88515,88483,88472)

135. 0.0002

     SELECT util_id, util_photo FROM util_info WHERE util_id IN (98116,41231,97905,97809,97661,97597,97461,81237,96893,56251,7232,4123,96292,96237,93393,96072,96059,95769,95197,95080,94929,94672,94491,94343,94389,93954,93650,93450,93392,93355,93267,93137,93122,81043,44564,74531,92615,92483,92052,91855,91751,91712,91648,91501,91261,91195,91083,91049,90875,90874,90349,89903,7577,89058,89244,88931,88586,88515,88483,88472)

136. 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='0' AND keywords_visu=1 ORDER BY keywords_nb DESC, keywords_id ASC LIMIT 0,10

137. 0.0001

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

138. 0

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

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

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

141. 0.0009

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

142. 0.0311

     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'

143. 0.3879

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

143 requetes sql en 0.5826