Demandes récentes de voisins

1. 0.0001

   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='materiel-jardinage'

3. 0

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

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

6. 0.0001

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

7. 0.0002

   SHOW TABLES LIKE 'pays'

8. 0.0002

   SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

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

10. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='tracteur tondeuse'

11. 0.0032

    SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='88' AND ssrubr_id='8' AND wish_visu IN (1,6,10)

12. 0.0001

    SELECT * FROM texte WHERE cate_id=88

13. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='tracteur tondeuse' OR ssrubr_slug='tracteur-tondeuse' OR (ssrubr_title like '%tracteur tondeuse%')) AND cate_id='88' ORDER BY ssrubr_id LIMIT 0,1

14. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='tracteur-tondeuse' AND cate_id='88'

15. 0.0082

    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='5' AND cate_id='88' AND ssrubr_id='8' AND type_id='2' AND wish_visu IN (1,6,10) GROUP BY wish_id

16. 0.0015

    SELECT util_id, util_photo, util_prenom, util_nom, stripe_account_id, util_verify FROM util_info WHERE util_id IN (1362,1744,2931,21559,23236,23430,24681,26222,27879,28298,29002,29265,29362,30654,30696,31110,31815,32170,32712,32949,33674,34456,41693,43268,44471,46869,46918,48389,48708,50303,50721,51485,54576,57038,60984,64307,68286,71566,71689,72128,72176,72447,73738,73809,74946,75573,76304,76313,76321,76478,76565,76722,76800,76960,77401,77537,77584,77697,78052,78282,78622,78798,78801,79125,79297,79372,79426,79494,79745,80250,80334,80377,81257,2037,81884,81935,81959,82001,82692,82782,82984,83090,79140,83788,84134,84138,84201,84258,84482,85411,85492,85704,85727,85766,8667,87113,87665,11505,89409,91189,94373,94609,94869,95353,96149,98562,98747,101088,65129,102592,103548,85717,112130,115673,117518,118674,120116,120262,120724,122175,122451,141899,143831,144184,145208,145940,146374,147115,147770,149078,1666,149893,150465,150456,150907,152642,152656,149532,153363,153534,72448,154670,155318,155328,155475,156554,156860,157509,157601,158418,27707,160092,160772,161264,161414,161486,162635,6887,162881,160954,163478,164124,165121,165765,165821,166667,167637,168027,168238,168250,168255,168378,168515,102894,85461,168980,169036,164963,169086,169143,169250,169255,112176,169443,107993,83422,170259,170290,170375,170415,119356,170672,170670,171063,171099,171168,171520,171636,97080,172268,173184,156698,173215,173386,113734,175295,175915,176557,176694,176911,152988,177318,178019,178546,178602,92990,180942,181156,181364,181410,181751,181802,182342,130428,183993,184197,184626,186028,186294,186425,186579,187476,187934,188303,188356,188520,188693,188758,189325,190573,190756,190996,191516,192989,193946,196211,196357,196852,197299,197388,199240,201324,204884,204984,205663,207161,205724,208575,216202,227664,230585,232089,233260,233334,234056,234486,234653,235700,235720,235984,236195,236260,236341,236503,23330,236768,237316,237515,238011,238228,238521,157035,239437,239920,240924,71190,241275,241284,241362,242304,242846,243199,167926,244235,180776,244489,244937,244972,245604,246184,246204,246330,246519,247998,248095,248588,248917,249066,249159,42794,249248,249625,251380,251802,252114,252251,252831,250558,180917,229634,255889,256147,256537,245529,257677,260253,261235,261287,261440,263061,265165,266267,266770,266806,267065,83647,277091,285111,285384,80941,295235,330579,266117,331122,331258,331479,331541,331573,332839,333551,334029,334640,335044,335958,162074,299084,338488,226858,339158,341716,342671,164631,344052,307047,345360,346317,347022,347232,350525,351447,352236,354017,357555,357875,359900,361461,364432,366979,371758,372587,375392,5975,378263,379211,38684,388364,394224,383313,407991,408331,408534,411328,412433,413177,413238,413252,413677,416207,401522,416903,417194,417384,417779,198381,418208,418331,418699,334269,419901,420161,420765,421139,421850,14250,332946,287245,422487,326408,424012,424019,424236,423888,424609,424636,400243,358408,425032,424603,425562,426478,426816,428175,429246,429895,430792,432052,432086,432257,210044,432883,286388,433557,434082,434502,434915,431539,435029,424447,435337,78613,435438,435739,436683,436813,437114,437931,438306,438403,438585,438842,438944,428775,439099,439278,439717,440682,441763,442806,443626,443641,443684,444254,445122,446234,447242,41832,447878,448987,425955,451450,455262,455587,459281,317443,114325,459720,465932,466670,225527,472901,474336,475222,371883,496128,494761,499940,500364,500888,501740,502027,502345,504089,342991,504689,503399,505561,505764,506000,506021,506137,501007,507032,510048,154385,449408,477987,471210,323444,442488,512864,513037,513995,514148,515918,516272,516879,425423,517333,517585,279269,8576,519833,523979,424133,528176,533235,533924,328324,537139,536565,539874,542005,544384,546254,428431)

17. 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 (8)

18. 0.0001

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

19. 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 = 80250 AND W.type_id = 1) OR (W.util_id <> 80250 AND W.type_id = 2)) AND (M.post_util_id = 80250 OR M.dest_util_id = 80250) 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=79745 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 = 79745 AND W.type_id = 1) OR (W.util_id <> 79745 AND W.type_id = 2)) AND (M.post_util_id = 79745 OR M.dest_util_id = 79745) 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=79494 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 = 79494 AND W.type_id = 1) OR (W.util_id <> 79494 AND W.type_id = 2)) AND (M.post_util_id = 79494 OR M.dest_util_id = 79494) 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=79426 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 = 79426 AND W.type_id = 1) OR (W.util_id <> 79426 AND W.type_id = 2)) AND (M.post_util_id = 79426 OR M.dest_util_id = 79426) 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=79372 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 = 79372 AND W.type_id = 1) OR (W.util_id <> 79372 AND W.type_id = 2)) AND (M.post_util_id = 79372 OR M.dest_util_id = 79372) 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=79297 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 = 79297 AND W.type_id = 1) OR (W.util_id <> 79297 AND W.type_id = 2)) AND (M.post_util_id = 79297 OR M.dest_util_id = 79297) 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=79125 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 = 79125 AND W.type_id = 1) OR (W.util_id <> 79125 AND W.type_id = 2)) AND (M.post_util_id = 79125 OR M.dest_util_id = 79125) 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=78801 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 = 78801 AND W.type_id = 1) OR (W.util_id <> 78801 AND W.type_id = 2)) AND (M.post_util_id = 78801 OR M.dest_util_id = 78801) 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=78798 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 = 78798 AND W.type_id = 1) OR (W.util_id <> 78798 AND W.type_id = 2)) AND (M.post_util_id = 78798 OR M.dest_util_id = 78798) 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=78622 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 = 78622 AND W.type_id = 1) OR (W.util_id <> 78622 AND W.type_id = 2)) AND (M.post_util_id = 78622 OR M.dest_util_id = 78622) 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=78282 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 = 78282 AND W.type_id = 1) OR (W.util_id <> 78282 AND W.type_id = 2)) AND (M.post_util_id = 78282 OR M.dest_util_id = 78282) 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=78052 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 = 78052 AND W.type_id = 1) OR (W.util_id <> 78052 AND W.type_id = 2)) AND (M.post_util_id = 78052 OR M.dest_util_id = 78052) 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=77697 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 = 77697 AND W.type_id = 1) OR (W.util_id <> 77697 AND W.type_id = 2)) AND (M.post_util_id = 77697 OR M.dest_util_id = 77697) 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=77584 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 = 77584 AND W.type_id = 1) OR (W.util_id <> 77584 AND W.type_id = 2)) AND (M.post_util_id = 77584 OR M.dest_util_id = 77584) 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=77537 AND note_visu IN (1,3,4)

47. 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 = 77537 AND W.type_id = 1) OR (W.util_id <> 77537 AND W.type_id = 2)) AND (M.post_util_id = 77537 OR M.dest_util_id = 77537) 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=77401 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 = 77401 AND W.type_id = 1) OR (W.util_id <> 77401 AND W.type_id = 2)) AND (M.post_util_id = 77401 OR M.dest_util_id = 77401) 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=76722 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 = 76722 AND W.type_id = 1) OR (W.util_id <> 76722 AND W.type_id = 2)) AND (M.post_util_id = 76722 OR M.dest_util_id = 76722) 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=76960 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 = 76960 AND W.type_id = 1) OR (W.util_id <> 76960 AND W.type_id = 2)) AND (M.post_util_id = 76960 OR M.dest_util_id = 76960) 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=76800 AND note_visu IN (1,3,4)

55. 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 = 76800 AND W.type_id = 1) OR (W.util_id <> 76800 AND W.type_id = 2)) AND (M.post_util_id = 76800 OR M.dest_util_id = 76800) 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=76565 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 = 76565 AND W.type_id = 1) OR (W.util_id <> 76565 AND W.type_id = 2)) AND (M.post_util_id = 76565 OR M.dest_util_id = 76565) 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=76478 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 = 76478 AND W.type_id = 1) OR (W.util_id <> 76478 AND W.type_id = 2)) AND (M.post_util_id = 76478 OR M.dest_util_id = 76478) 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=76321 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 = 76321 AND W.type_id = 1) OR (W.util_id <> 76321 AND W.type_id = 2)) AND (M.post_util_id = 76321 OR M.dest_util_id = 76321) 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=76313 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 = 76313 AND W.type_id = 1) OR (W.util_id <> 76313 AND W.type_id = 2)) AND (M.post_util_id = 76313 OR M.dest_util_id = 76313) 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=76304 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 = 76304 AND W.type_id = 1) OR (W.util_id <> 76304 AND W.type_id = 2)) AND (M.post_util_id = 76304 OR M.dest_util_id = 76304) 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=75573 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 = 75573 AND W.type_id = 1) OR (W.util_id <> 75573 AND W.type_id = 2)) AND (M.post_util_id = 75573 OR M.dest_util_id = 75573) 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=74946 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 = 74946 AND W.type_id = 1) OR (W.util_id <> 74946 AND W.type_id = 2)) AND (M.post_util_id = 74946 OR M.dest_util_id = 74946) 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=73809 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 = 73809 AND W.type_id = 1) OR (W.util_id <> 73809 AND W.type_id = 2)) AND (M.post_util_id = 73809 OR M.dest_util_id = 73809) 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=73738 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 = 73738 AND W.type_id = 1) OR (W.util_id <> 73738 AND W.type_id = 2)) AND (M.post_util_id = 73738 OR M.dest_util_id = 73738) 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=72447 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 = 72447 AND W.type_id = 1) OR (W.util_id <> 72447 AND W.type_id = 2)) AND (M.post_util_id = 72447 OR M.dest_util_id = 72447) 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=72176 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 = 72176 AND W.type_id = 1) OR (W.util_id <> 72176 AND W.type_id = 2)) AND (M.post_util_id = 72176 OR M.dest_util_id = 72176) 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=72128 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 = 72128 AND W.type_id = 1) OR (W.util_id <> 72128 AND W.type_id = 2)) AND (M.post_util_id = 72128 OR M.dest_util_id = 72128) 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=71689 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 = 71689 AND W.type_id = 1) OR (W.util_id <> 71689 AND W.type_id = 2)) AND (M.post_util_id = 71689 OR M.dest_util_id = 71689) 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=71566 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 = 71566 AND W.type_id = 1) OR (W.util_id <> 71566 AND W.type_id = 2)) AND (M.post_util_id = 71566 OR M.dest_util_id = 71566) 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=68286 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 = 68286 AND W.type_id = 1) OR (W.util_id <> 68286 AND W.type_id = 2)) AND (M.post_util_id = 68286 OR M.dest_util_id = 68286) 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=64307 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 = 64307 AND W.type_id = 1) OR (W.util_id <> 64307 AND W.type_id = 2)) AND (M.post_util_id = 64307 OR M.dest_util_id = 64307) 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=60984 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 = 60984 AND W.type_id = 1) OR (W.util_id <> 60984 AND W.type_id = 2)) AND (M.post_util_id = 60984 OR M.dest_util_id = 60984) 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=57038 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 = 57038 AND W.type_id = 1) OR (W.util_id <> 57038 AND W.type_id = 2)) AND (M.post_util_id = 57038 OR M.dest_util_id = 57038) 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=54576 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 = 54576 AND W.type_id = 1) OR (W.util_id <> 54576 AND W.type_id = 2)) AND (M.post_util_id = 54576 OR M.dest_util_id = 54576) 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=51485 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 = 51485 AND W.type_id = 1) OR (W.util_id <> 51485 AND W.type_id = 2)) AND (M.post_util_id = 51485 OR M.dest_util_id = 51485) 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=50721 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 = 50721 AND W.type_id = 1) OR (W.util_id <> 50721 AND W.type_id = 2)) AND (M.post_util_id = 50721 OR M.dest_util_id = 50721) 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=50303 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 = 50303 AND W.type_id = 1) OR (W.util_id <> 50303 AND W.type_id = 2)) AND (M.post_util_id = 50303 OR M.dest_util_id = 50303) 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=48708 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 = 48708 AND W.type_id = 1) OR (W.util_id <> 48708 AND W.type_id = 2)) AND (M.post_util_id = 48708 OR M.dest_util_id = 48708) 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=48389 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 = 48389 AND W.type_id = 1) OR (W.util_id <> 48389 AND W.type_id = 2)) AND (M.post_util_id = 48389 OR M.dest_util_id = 48389) 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=46918 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 = 46918 AND W.type_id = 1) OR (W.util_id <> 46918 AND W.type_id = 2)) AND (M.post_util_id = 46918 OR M.dest_util_id = 46918) 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=46869 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 = 46869 AND W.type_id = 1) OR (W.util_id <> 46869 AND W.type_id = 2)) AND (M.post_util_id = 46869 OR M.dest_util_id = 46869) 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=44471 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 = 44471 AND W.type_id = 1) OR (W.util_id <> 44471 AND W.type_id = 2)) AND (M.post_util_id = 44471 OR M.dest_util_id = 44471) 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=43268 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 = 43268 AND W.type_id = 1) OR (W.util_id <> 43268 AND W.type_id = 2)) AND (M.post_util_id = 43268 OR M.dest_util_id = 43268) 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=41693 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 = 41693 AND W.type_id = 1) OR (W.util_id <> 41693 AND W.type_id = 2)) AND (M.post_util_id = 41693 OR M.dest_util_id = 41693) 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=34456 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 = 34456 AND W.type_id = 1) OR (W.util_id <> 34456 AND W.type_id = 2)) AND (M.post_util_id = 34456 OR M.dest_util_id = 34456) 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=33674 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 = 33674 AND W.type_id = 1) OR (W.util_id <> 33674 AND W.type_id = 2)) AND (M.post_util_id = 33674 OR M.dest_util_id = 33674) 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=32949 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 = 32949 AND W.type_id = 1) OR (W.util_id <> 32949 AND W.type_id = 2)) AND (M.post_util_id = 32949 OR M.dest_util_id = 32949) 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=32712 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 = 32712 AND W.type_id = 1) OR (W.util_id <> 32712 AND W.type_id = 2)) AND (M.post_util_id = 32712 OR M.dest_util_id = 32712) 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=32170 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 = 32170 AND W.type_id = 1) OR (W.util_id <> 32170 AND W.type_id = 2)) AND (M.post_util_id = 32170 OR M.dest_util_id = 32170) 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=31815 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 = 31815 AND W.type_id = 1) OR (W.util_id <> 31815 AND W.type_id = 2)) AND (M.post_util_id = 31815 OR M.dest_util_id = 31815) 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=31110 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 = 31110 AND W.type_id = 1) OR (W.util_id <> 31110 AND W.type_id = 2)) AND (M.post_util_id = 31110 OR M.dest_util_id = 31110) 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=30696 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 = 30696 AND W.type_id = 1) OR (W.util_id <> 30696 AND W.type_id = 2)) AND (M.post_util_id = 30696 OR M.dest_util_id = 30696) 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=30654 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 = 30654 AND W.type_id = 1) OR (W.util_id <> 30654 AND W.type_id = 2)) AND (M.post_util_id = 30654 OR M.dest_util_id = 30654) 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=29362 AND note_visu IN (1,3,4)

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

134. 0.0001

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

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

136. 0.0001

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

137. 0.0001

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

138. 0.0003

     SELECT util_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id IN (80250,79745,79494,79426,79372,79297,79125,78801,78798,78622,78282,78052,77697,77584,77537,77401,76722,76960,76800,76565,76478,76321,76313,76304,75573,74946,73809,73738,72447,72176,72128,71689,71566,68286,64307,60984,57038,54576,51485,50721,50303,48708,48389,46918,46869,44471,43268,41693,34456,33674,32949,32712,32170,31815,31110,30696,30654,29362,29265,29002)

139. 0.0002

     SELECT util_id, util_photo FROM util_info WHERE util_id IN (80250,79745,79494,79426,79372,79297,79125,78801,78798,78622,78282,78052,77697,77584,77537,77401,76722,76960,76800,76565,76478,76321,76313,76304,75573,74946,73809,73738,72447,72176,72128,71689,71566,68286,64307,60984,57038,54576,51485,50721,50303,48708,48389,46918,46869,44471,43268,41693,34456,33674,32949,32712,32170,31815,31110,30696,30654,29362,29265,29002)

140. 0.0003

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

141. 0.0001

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

142. 0

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

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

144. 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 (88) ORDER BY ssrubr_order ASC

145. 0.0009

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

146. 0.0234

     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'

147. 0.0169

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

147 requetes sql en 0.07