Service extension de cils à 94200 Ivry-sur-seine

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='coiffure-esthetique'

3. 0.0001

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

4. 0.0001

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='94'

5. 0.0001

   SELECT ville_nom FROM villes WHERE ville_cp='94200' AND ville_nom like '%ivry%sur%seine%' ORDER BY ville_population_2012 DESC LIMIT 0,1

6. 0.0007

   SELECT DISTINCT ssrubr_slug FROM ssrubr WHERE ssrubr_visu=1 AND fami_id IN (3,5) AND ssrubr_slug IS NOT NULL AND ssrubr_slug<>''

7. 0.0002

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

8. 0.0002

   SHOW TABLES LIKE 'pays'

9. 0.0002

   SHOW COLUMNS FROM pays LIKE 'pays_tel_%'

10. 0.0003

    SELECT pays_code, pays_nom, pays_actif, pays_NDD, pays_drapeau, pays_lang, pays_tel, pays_nb_annonces, pays_tel_masque, pays_tel_max, pays_tel_fmt_paires, pays_tel_mode FROM pays ORDER BY pays_nom ASC

11. 0.0001

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

12. 0.0025

    SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.636835678816 AND ville_latitude_deg<48.996564321184 AND ville_longitude_deg>2.1101746819952 AND ville_longitude_deg<2.6564853180048 HAVING distance <= 20 ORDER BY distance ASC

13. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='extension cil; extension de cils'

14. 0.0006

    SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='43'AND MATCH (wish_title,wish_desc) AGAINST ('+extension cil; extension de cils*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '94200%'

15. 0.0001

    SELECT * FROM texte WHERE cate_id=43

16. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='3' AND (ssrubr_keywords='extension cil; extension de cils' OR ssrubr_slug='extension-cil;-extension-de-cils' OR (ssrubr_title like '%extension cil; extension de cils%')) AND cate_id='43' ORDER BY ssrubr_id LIMIT 0,1

17. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='extension-de-cils' AND cate_id='43'

18. 0.0001

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

19. 0.0023

    SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.636835678816 AND ville_latitude_deg<48.996564321184 AND ville_longitude_deg>2.1101746819952 AND ville_longitude_deg<2.6564853180048 HAVING distance <= 20 ORDER BY distance ASC

20. 0.0074

    SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.367039197041 AND ville_latitude_deg<49.266360802959 AND ville_longitude_deg>1.7004358163378 AND ville_longitude_deg<3.0662241836622 HAVING distance <= 50 ORDER BY distance ASC

21. 0.0442

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify, ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='43' AND MATCH (wish_desc) AGAINST ('(+extension +cil; +extension +de +cils*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (94200,94205,94200,94270,94800,94220,94160,94140,94250,94400,94700,94110,92120,94300,94240,94237,94238,94239,94235,94234,94233,94232,94231,94230,94236,94410,94320,75020,75012,75116,75019,75018,75008,75009,75010,75011,75013,75014,75015,75016,75017,75007,75006,75004,75005,75003,75002,75001,75000,94600,93170,94550,94340,92240,92170,92220,93100,92340,94000,93310,94390,94310,94130,92320,94150,94120,92330,92260,93260,93230,92130,94340,94100,94210,92140,94260,93110,94380,94170,92350,93500,93130,94290,94460,92160,94500,94360,92100,94430,93400,91320,92290,92360,92190,93000,94190,93140,92110,93120,93300,91200,91550,93360,92200,93250,91370,94480,93330,92300,94450,91300,91560,94470,92150,92800,94370,94380,94350,92210,92600,94490,94880,94880,93210,93200,92400,93350,91270,93220,94420,92310,93320,93340,92250,92390,93450,91420,92370,93700,93150,91230,93160,92270,91330,92410,91570,92230,91380,91160,93460,78140,92700,91120,93240,91260,92380,93440,91210,94510,92500,91430,94440,92420,92430,91800,91160,94440,93800,78220,93430,91140,77420,92000,93370,91430,77340,93390,93190,91170,93380,78350,91390,91600,95140,95360,93270,95500,91360,77184,91160,77185,95880,91360,78800,94440,78170,77500,95100,93600,91860,95870,94520,94520,95210,95218,91160,78420,77181,93470,91400,78000,77170,91800,91140,91350,78400,93410,77186,95400,95410,91130,91000,95170,78150,78290,78380,78350,78530,95500,91450,95110,77150,95230,91700,91400,78150,77680,77177,77200,93420,91480) AND type_id=1 GROUP BY wish_id

22. 0.0002

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

23. 0.0001

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

24. 0.0002

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

25. 0.0001

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

26. 0.0001

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

27. 0.0001

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

28. 0.0001

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

29. 0.0001

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

30. 0.0002

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

31. 0.0001

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

32. 0.0001

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

33. 0.0001

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

34. 0.0001

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

35. 0.0001

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

36. 0.0002

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

37. 0.0001

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

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

39. 0.0001

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

40. 0.0001

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

41. 0.0001

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

42. 0.0001

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

43. 0.0001

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

44. 0.0001

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

45. 0.0001

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

46. 0.0001

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

47. 0.0001

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

48. 0.0001

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

49. 0.0001

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

50. 0.0001

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

51. 0.0001

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

52. 0.0001

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

53. 0.0001

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

54. 0.0001

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

55. 0.0001

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

56. 0.0001

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

57. 0.0001

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

58. 0.0001

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

59. 0.0001

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

60. 0.0001

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

61. 0.0001

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

62. 0.0001

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

63. 0.0001

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

64. 0.0002

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

65. 0.0001

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

66. 0.0001

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

67. 0.0001

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

68. 0.0001

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

69. 0.0001

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

70. 0.0001

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

71. 0.0001

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

72. 0.0001

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

73. 0.0001

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

74. 0.0001

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

75. 0.0001

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

76. 0.0001

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

77. 0.0001

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

78. 0.0001

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

79. 0.0001

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

80. 0.0001

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

81. 0.0001

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

82. 0.0001

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

83. 0.0001

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

84. 0.0001

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

85. 0.0001

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

86. 0.0001

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

87. 0.0001

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

88. 0.0001

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

89. 0.0001

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

90. 0.0001

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

91. 0.0001

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

92. 0.0001

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

93. 0.0001

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

94. 0.0001

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

95. 0.0001

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

96. 0.0001

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

97. 0.0001

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

98. 0.0001

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

99. 0.0001

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

100. 0.0001

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

101. 0.0001

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

102. 0.0001

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

103. 0.0001

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

104. 0.0001

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

105. 0.0001

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

106. 0.0001

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

107. 0.0001

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

108. 0.0001

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

109. 0.0001

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

110. 0.0001

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

111. 0.0001

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

112. 0.0001

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

113. 0.0001

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

114. 0.0001

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

115. 0.0001

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

116. 0.0001

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

117. 0.0001

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

118. 0.0001

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

119. 0.0001

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

120. 0.0001

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

121. 0.0001

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

122. 0.0001

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

123. 0.0001

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

124. 0.0001

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

125. 0.0001

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

126. 0.0001

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

127. 0.0001

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

128. 0.0001

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

129. 0.0001

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

130. 0.0001

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

131. 0.0001

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

132. 0.0001

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

133. 0.0001

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

134. 0.0001

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

135. 0.0001

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

136. 0.0001

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

137. 0.0001

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

138. 0.0001

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

139. 0.0001

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

140. 0.0001

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

141. 0.0001

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

142. 0.0001

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

143. 0.0001

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

144. 0.0001

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

145. 0.0001

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

146. 0.0001

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

147. 0.0001

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

148. 0.0001

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

149. 0.0001

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

150. 0.0001

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

151. 0.0001

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

152. 0.0001

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

153. 0.0001

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

154. 0.0001

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

155. 0.0001

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

156. 0.0001

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

157. 0.0001

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

158. 0.0001

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

159. 0.0021

     SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.636835678816 AND ville_latitude_deg<48.996564321184 AND ville_longitude_deg>2.1101746819952 AND ville_longitude_deg<2.6564853180048 HAVING distance <= 20 ORDER BY distance ASC

160. 0.0082

     SELECT ville_cp, ROUND((((acos(sin((48.8167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.367039197041 AND ville_latitude_deg<49.266360802959 AND ville_longitude_deg>1.7004358163378 AND ville_longitude_deg<3.0662241836622 HAVING distance <= 50 ORDER BY distance ASC

161. 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 (570,565,567)

162. 0.0002

     SELECT util_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id IN (221065,123283,477842,169283,256197,546480,226225,315898,14758,163161,277683,119132,10634,365535)

163. 0.0001

     SELECT util_id, util_photo FROM util_info WHERE util_id IN (221065,123283,477842,169283,256197,546480,226225,315898,14758,163161,277683,119132,10634,365535)

164. 0.0002

     SELECT ssrubr_id, ssrubr_title, ssrubr_slug, ssrubr_photo, cate_title_slug FROM ssrubr ss, category c WHERE ss.cate_id=c.cate_id AND ssrubr_visu=1 AND ss.cate_id=43 AND ss.fami_id=3 ORDER BY ssrubr_order LIMIT 6,100

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

166. 0.0001

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

167. 0.0001

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

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

169. 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 (43) ORDER BY ssrubr_order ASC

170. 0.001

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

171. 0.0342

     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'

172. 0.0241

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

172 requetes sql en 0.1453