Location karcher à 91290 Arpajon

1. 0.0001

   SELECT cate_id FROM category WHERE fami_id='5' AND cate_title_slug='materiel-nettoyage'

2. 0.0001

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

3. 0.0001

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='91'

4. 0.0001

   SELECT ville_nom FROM villes WHERE ville_cp='91290' AND ville_nom like '%arpajon%' ORDER BY ville_population_2012 DESC LIMIT 0,1

5. 0.0002

   SELECT ssrubr_id, ssrubr_keywords, ssrubr_title, ssrubr_slug, ssrubr_mail, ssrubr_photo FROM ssrubr WHERE (ssrubr_keywords like '%nettoyeur%haute%pression%' OR ssrubr_title like '%nettoyeur%haute%pression%' OR ssrubr_slug like '%nettoyeur%haute%pression%') AND cate_id='110' ORDER BY ssrubr_id LIMIT 0,1

6. 0.0001

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

7. 0.0018

   SELECT ville_cp, ROUND((((acos(sin((48.5833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.5833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.26667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.403435678816 AND ville_latitude_deg<48.763164321184 AND ville_longitude_deg>1.9947783424089 AND ville_longitude_deg<2.5385616575911 HAVING distance <= 20 ORDER BY distance ASC

8. 0.0001

   SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='nettoyeur haute pression'

9. 0.0009

   SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='110'AND MATCH (wish_title,wish_desc) AGAINST ('+nettoyeur haute pression*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '91290%'

10. 0.0001

    SELECT * FROM texte WHERE cate_id=110

11. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='nettoyeur haute pression' OR ssrubr_slug='nettoyeur-haute-pression' OR (ssrubr_title like '%nettoyeur haute pression%')) AND cate_id='110' ORDER BY ssrubr_id LIMIT 0,1

12. 0.0001

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

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

14. 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 (110) ORDER BY ssrubr_order ASC

15. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='nettoyeur-haute-pression' AND cate_id='110'

16. 0.0001

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

17. 0.0015

    SELECT ville_cp, ROUND((((acos(sin((48.5833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.5833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.26667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.403435678816 AND ville_latitude_deg<48.763164321184 AND ville_longitude_deg>1.9947783424089 AND ville_longitude_deg<2.5385616575911 HAVING distance <= 20 ORDER BY distance ASC

18. 0.0051

    SELECT ville_cp, ROUND((((acos(sin((48.5833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.5833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.26667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.133639197041 AND ville_latitude_deg<49.032960802959 AND ville_longitude_deg>1.5869349946139 AND ville_longitude_deg<2.9464050053861 HAVING distance <= 50 ORDER BY distance ASC

19. 0.0631

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='110' AND MATCH (wish_desc) AGAINST ('(+nettoyeur +haute +pression*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (91290,91290,91290,91630,91630,91180,91630,91340,91520,91630,91310,91630,91790,91220,91220,91680,91310,91310,91310,91240,91460,91730,91650,91510,91510,91770,91700,91620,91650,91810,91850,91700,91620,91710,91730,91730,91910,91650,91680,91760,91700,91070,91640,91160,91360,91540,91580,91580,91080,91540,91360,91610,91530,91390,91600,91590,91160,91090,91640,91350,91640,91580,91140,91640,91530,91580,91940,91540,91540,91170,91590,91470,91160,91590,91580,91140,91380,91940,91160,91130,91580,91000,91750,91590,91100,91420,91260,91400,91590,91400,91090,91000,91530,91470,91940,91190,91530,91590,91120,91440,91470,91450,91750,91590,91150,91210,91590,91450,91100,91250,91550,91300,91880,91830,91270,91430,91250,91830,91250,91410,91320,91470,91430,91280,78830,91470,91200,91190,91150,91890,91250,91410,91820,91400,91820,91190,94480,91370,91230,78470,92160,91870,91150,91570,94260,91410,91470,91750,94150,78830,94290)

20. 0.0546

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.5833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.5833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.26667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id LEFT JOIN villes v ON wish.wish_cp=v.ville_cp WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='110' AND MATCH (wish_desc) AGAINST ('(+nettoyeur +haute +pression*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (91290,91290,91290,91630,91630,91180,91630,91340,91520,91630,91310,91630,91790,91220,91220,91680,91310,91310,91310,91240,91460,91730,91650,91510,91510,91770,91700,91620,91650,91810,91850,91700,91620,91710,91730,91730,91910,91650,91680,91760,91700,91070,91640,91160,91360,91540,91580,91580,91080,91540,91360,91610,91530,91390,91600,91590,91160,91090,91640,91350,91640,91580,91140,91640,91530,91580,91940,91540,91540,91170,91590,91470,91160,91590,91580,91140,91380,91940,91160,91130,91580,91000,91750,91590,91100,91420,91260,91400,91590,91400,91090,91000,91530,91470,91940,91190,91530,91590,91120,91440,91470,91450,91750,91590,91150,91210,91590,91450,91100,91250,91550,91300,91880,91830,91270,91430,91250,91830,91250,91410,91320,91470,91430,91280,78830,91470,91200,91190,91150,91890,91250,91410,91820,91400,91820,91190,94480,91370,91230,78470,92160,91870,91150,91570,94260,91410,91470,91750,94150,78830,94290) AND type_id=1 GROUP BY wish_id

21. 0.0001

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

22. 0.0022

    SELECT ville_cp, ROUND((((acos(sin((48.5833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.5833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.26667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.403435678816 AND ville_latitude_deg<48.763164321184 AND ville_longitude_deg>1.9947783424089 AND ville_longitude_deg<2.5385616575911 HAVING distance <= 20 ORDER BY distance ASC

23. 0.0072

    SELECT ville_cp, ROUND((((acos(sin((48.5833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.5833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.26667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.133639197041 AND ville_latitude_deg<49.032960802959 AND ville_longitude_deg>1.5869349946139 AND ville_longitude_deg<2.9464050053861 HAVING distance <= 50 ORDER BY distance ASC

24. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 74331 AND W.type_id = 1) OR (W.util_id != 74331 AND W.type_id = 2)) AND (`post_util_id` = 74331 OR `dest_util_id` = 74331) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

25. 0.0001

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

26. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 113039 AND W.type_id = 1) OR (W.util_id != 113039 AND W.type_id = 2)) AND (`post_util_id` = 113039 OR `dest_util_id` = 113039) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

27. 0.0001

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

28. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 149386 AND W.type_id = 1) OR (W.util_id != 149386 AND W.type_id = 2)) AND (`post_util_id` = 149386 OR `dest_util_id` = 149386) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

29. 0.0001

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

30. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 158491 AND W.type_id = 1) OR (W.util_id != 158491 AND W.type_id = 2)) AND (`post_util_id` = 158491 OR `dest_util_id` = 158491) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

31. 0.0001

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

32. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 159195 AND W.type_id = 1) OR (W.util_id != 159195 AND W.type_id = 2)) AND (`post_util_id` = 159195 OR `dest_util_id` = 159195) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

33. 0.0001

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

34. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 169778 AND W.type_id = 1) OR (W.util_id != 169778 AND W.type_id = 2)) AND (`post_util_id` = 169778 OR `dest_util_id` = 169778) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

35. 0.0001

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

36. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 173157 AND W.type_id = 1) OR (W.util_id != 173157 AND W.type_id = 2)) AND (`post_util_id` = 173157 OR `dest_util_id` = 173157) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

37. 0.0001

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

38. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 174204 AND W.type_id = 1) OR (W.util_id != 174204 AND W.type_id = 2)) AND (`post_util_id` = 174204 OR `dest_util_id` = 174204) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

39. 0.0001

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

40. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 205896 AND W.type_id = 1) OR (W.util_id != 205896 AND W.type_id = 2)) AND (`post_util_id` = 205896 OR `dest_util_id` = 205896) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

41. 0.0001

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

42. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 71897 AND W.type_id = 1) OR (W.util_id != 71897 AND W.type_id = 2)) AND (`post_util_id` = 71897 OR `dest_util_id` = 71897) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

43. 0.0001

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

44. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 212734 AND W.type_id = 1) OR (W.util_id != 212734 AND W.type_id = 2)) AND (`post_util_id` = 212734 OR `dest_util_id` = 212734) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

45. 0.0001

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

46. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 238905 AND W.type_id = 1) OR (W.util_id != 238905 AND W.type_id = 2)) AND (`post_util_id` = 238905 OR `dest_util_id` = 238905) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

47. 0.0001

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

48. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 239713 AND W.type_id = 1) OR (W.util_id != 239713 AND W.type_id = 2)) AND (`post_util_id` = 239713 OR `dest_util_id` = 239713) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

49. 0.0001

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

50. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 237197 AND W.type_id = 1) OR (W.util_id != 237197 AND W.type_id = 2)) AND (`post_util_id` = 237197 OR `dest_util_id` = 237197) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

51. 0.0001

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

52. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 244165 AND W.type_id = 1) OR (W.util_id != 244165 AND W.type_id = 2)) AND (`post_util_id` = 244165 OR `dest_util_id` = 244165) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

53. 0.0001

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

54. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 134765 AND W.type_id = 1) OR (W.util_id != 134765 AND W.type_id = 2)) AND (`post_util_id` = 134765 OR `dest_util_id` = 134765) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

55. 0.0001

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

56. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 258176 AND W.type_id = 1) OR (W.util_id != 258176 AND W.type_id = 2)) AND (`post_util_id` = 258176 OR `dest_util_id` = 258176) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

57. 0.0001

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

58. 0.0005

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 138228 AND W.type_id = 1) OR (W.util_id != 138228 AND W.type_id = 2)) AND (`post_util_id` = 138228 OR `dest_util_id` = 138228) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

59. 0.0001

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

60. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 284713 AND W.type_id = 1) OR (W.util_id != 284713 AND W.type_id = 2)) AND (`post_util_id` = 284713 OR `dest_util_id` = 284713) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

61. 0.0001

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

62. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 289408 AND W.type_id = 1) OR (W.util_id != 289408 AND W.type_id = 2)) AND (`post_util_id` = 289408 OR `dest_util_id` = 289408) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

63. 0.0001

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

64. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 294867 AND W.type_id = 1) OR (W.util_id != 294867 AND W.type_id = 2)) AND (`post_util_id` = 294867 OR `dest_util_id` = 294867) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

65. 0.0001

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

66. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 297789 AND W.type_id = 1) OR (W.util_id != 297789 AND W.type_id = 2)) AND (`post_util_id` = 297789 OR `dest_util_id` = 297789) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

67. 0.0001

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

68. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 320240 AND W.type_id = 1) OR (W.util_id != 320240 AND W.type_id = 2)) AND (`post_util_id` = 320240 OR `dest_util_id` = 320240) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

69. 0.0001

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

70. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 333203 AND W.type_id = 1) OR (W.util_id != 333203 AND W.type_id = 2)) AND (`post_util_id` = 333203 OR `dest_util_id` = 333203) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

71. 0.0001

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

72. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 347732 AND W.type_id = 1) OR (W.util_id != 347732 AND W.type_id = 2)) AND (`post_util_id` = 347732 OR `dest_util_id` = 347732) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

73. 0.0001

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

74. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 354917 AND W.type_id = 1) OR (W.util_id != 354917 AND W.type_id = 2)) AND (`post_util_id` = 354917 OR `dest_util_id` = 354917) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

75. 0.0001

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

76. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 259487 AND W.type_id = 1) OR (W.util_id != 259487 AND W.type_id = 2)) AND (`post_util_id` = 259487 OR `dest_util_id` = 259487) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

77. 0.0001

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

78. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 305815 AND W.type_id = 1) OR (W.util_id != 305815 AND W.type_id = 2)) AND (`post_util_id` = 305815 OR `dest_util_id` = 305815) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

79. 0.0001

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

80. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 370222 AND W.type_id = 1) OR (W.util_id != 370222 AND W.type_id = 2)) AND (`post_util_id` = 370222 OR `dest_util_id` = 370222) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

81. 0.0001

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

82. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 370605 AND W.type_id = 1) OR (W.util_id != 370605 AND W.type_id = 2)) AND (`post_util_id` = 370605 OR `dest_util_id` = 370605) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

83. 0.0001

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

84. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 376333 AND W.type_id = 1) OR (W.util_id != 376333 AND W.type_id = 2)) AND (`post_util_id` = 376333 OR `dest_util_id` = 376333) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

85. 0.0001

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

86. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 381310 AND W.type_id = 1) OR (W.util_id != 381310 AND W.type_id = 2)) AND (`post_util_id` = 381310 OR `dest_util_id` = 381310) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

87. 0.0001

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

88. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 382604 AND W.type_id = 1) OR (W.util_id != 382604 AND W.type_id = 2)) AND (`post_util_id` = 382604 OR `dest_util_id` = 382604) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

89. 0.0001

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

90. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 385186 AND W.type_id = 1) OR (W.util_id != 385186 AND W.type_id = 2)) AND (`post_util_id` = 385186 OR `dest_util_id` = 385186) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

91. 0.0001

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

92. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 396213 AND W.type_id = 1) OR (W.util_id != 396213 AND W.type_id = 2)) AND (`post_util_id` = 396213 OR `dest_util_id` = 396213) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

93. 0.0001

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

94. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 369445 AND W.type_id = 1) OR (W.util_id != 369445 AND W.type_id = 2)) AND (`post_util_id` = 369445 OR `dest_util_id` = 369445) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

95. 0.0001

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

96. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 324522 AND W.type_id = 1) OR (W.util_id != 324522 AND W.type_id = 2)) AND (`post_util_id` = 324522 OR `dest_util_id` = 324522) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

97. 0.0001

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

98. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 427500 AND W.type_id = 1) OR (W.util_id != 427500 AND W.type_id = 2)) AND (`post_util_id` = 427500 OR `dest_util_id` = 427500) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

99. 0.0001

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

100. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 488591 AND W.type_id = 1) OR (W.util_id != 488591 AND W.type_id = 2)) AND (`post_util_id` = 488591 OR `dest_util_id` = 488591) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

101. 0.0001

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

102. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 488591 AND W.type_id = 1) OR (W.util_id != 488591 AND W.type_id = 2)) AND (`post_util_id` = 488591 OR `dest_util_id` = 488591) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

103. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 493193 AND W.type_id = 1) OR (W.util_id != 493193 AND W.type_id = 2)) AND (`post_util_id` = 493193 OR `dest_util_id` = 493193) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

104. 0.0001

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

105. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 347842 AND W.type_id = 1) OR (W.util_id != 347842 AND W.type_id = 2)) AND (`post_util_id` = 347842 OR `dest_util_id` = 347842) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

106. 0.0001

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

107. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 516557 AND W.type_id = 1) OR (W.util_id != 516557 AND W.type_id = 2)) AND (`post_util_id` = 516557 OR `dest_util_id` = 516557) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

108. 0.0001

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

109. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 546376 AND W.type_id = 1) OR (W.util_id != 546376 AND W.type_id = 2)) AND (`post_util_id` = 546376 OR `dest_util_id` = 546376) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

110. 0.0001

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

111. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 521993 AND W.type_id = 1) OR (W.util_id != 521993 AND W.type_id = 2)) AND (`post_util_id` = 521993 OR `dest_util_id` = 521993) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

112. 0.0001

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

113. 0.0001

     SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 546928 AND W.type_id = 1) OR (W.util_id != 546928 AND W.type_id = 2)) AND (`post_util_id` = 546928 OR `dest_util_id` = 546928) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

114. 0.0001

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

115. 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=110 AND ss.fami_id=5 ORDER BY ssrubr_order LIMIT 6,100

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

117. 0.0001

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

118. 0.0009

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

119. 0

     SELECT count(*) as nbwish FROM wish

120. 0.0499

     SELECT note.*, post.util_prenom as postp, post.util_nom as postn, dest.util_prenom as destp, dest.util_nom as destn, w.wish_id, w.wish_desc, w.fami_id FROM note, util_info dest, util_info post, wish w WHERE note.wish_id=w.wish_id AND note.post_util_id=post.util_id AND note.dest_util_id=dest.util_id AND note_visu IN (1,2,3,4) AND post_util_id<>'7' ORDER BY note_date DESC, note_hour DESC

120 requetes sql en 0.1992