Location karcher à 33530 Bassens

1. 0.0001

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

2. 0

   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='33'

4. 0.0001

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

5. 0.0001

   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='33530'

7. 0.0012

   SELECT ville_cp, ROUND((((acos(sin((44.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((44.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((-0.516667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>44.720135678816 AND ville_latitude_deg<45.079864321184 AND ville_longitude_deg>-0.77059118585681 AND ville_longitude_deg<-0.26274281414319 HAVING distance <= 20 ORDER BY distance ASC

8. 0

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

9. 0.0002

   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 '33530%'

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='33530'

17. 0.0011

    SELECT ville_cp, ROUND((((acos(sin((44.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((44.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((-0.516667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>44.720135678816 AND ville_latitude_deg<45.079864321184 AND ville_longitude_deg>-0.77059118585681 AND ville_longitude_deg<-0.26274281414319 HAVING distance <= 20 ORDER BY distance ASC

18. 0.003

    SELECT ville_cp, ROUND((((acos(sin((44.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((44.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((-0.516667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>44.450339197041 AND ville_latitude_deg<45.349660802959 AND ville_longitude_deg>-1.1514829387097 AND ville_longitude_deg<0.11814893870969 HAVING distance <= 50 ORDER BY distance ASC

19. 0.0636

    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 (33530,33530,33560,33560,33440,33310,33370,33370,33440,33150,33370,33450,33270,33290,33440,33450,33520,33100,33072,33300,33000,33800,33200,33370,33110,33114,33240,33270,33450,33290,33750,33240,33360,33370,33320,33130,33290,33400,33240,33240,33290,33700,33320,33370,33450,33370,33810,33360,33600,33185,33240,33750,33360,33240,33240,33370,33360,33710,33360,33140,33240,33460,33240,33670,33240,33240,33240,33240,33240,33870,33460,33240,33710,33126,33126,33670,33750,33360,33140,33170,33670,33710,33160,33710,33240,33750,33460,33240,33880,33240,33126,33460,33750,33710,33240,33670,33500,33710,33710,33141,33610,33710,33240,33750,33710,33880,33670,33850,33670,33126,33750)

20. 0.0538

    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((44.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((44.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((-0.516667- 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 (33530,33530,33560,33560,33440,33310,33370,33370,33440,33150,33370,33450,33270,33290,33440,33450,33520,33100,33072,33300,33000,33800,33200,33370,33110,33114,33240,33270,33450,33290,33750,33240,33360,33370,33320,33130,33290,33400,33240,33240,33290,33700,33320,33370,33450,33370,33810,33360,33600,33185,33240,33750,33360,33240,33240,33370,33360,33710,33360,33140,33240,33460,33240,33670,33240,33240,33240,33240,33240,33870,33460,33240,33710,33126,33126,33670,33750,33360,33140,33170,33670,33710,33160,33710,33240,33750,33460,33240,33880,33240,33126,33460,33750,33710,33240,33670,33500,33710,33710,33141,33610,33710,33240,33750,33710,33880,33670,33850,33670,33126,33750) 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='33530'

22. 0.0011

    SELECT ville_cp, ROUND((((acos(sin((44.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((44.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((-0.516667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>44.720135678816 AND ville_latitude_deg<45.079864321184 AND ville_longitude_deg>-0.77059118585681 AND ville_longitude_deg<-0.26274281414319 HAVING distance <= 20 ORDER BY distance ASC

23. 0.003

    SELECT ville_cp, ROUND((((acos(sin((44.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((44.9*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((-0.516667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>44.450339197041 AND ville_latitude_deg<45.349660802959 AND ville_longitude_deg>-1.1514829387097 AND ville_longitude_deg<0.11814893870969 HAVING distance <= 50 ORDER BY distance ASC

24. 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 = 65649 AND W.type_id = 1) OR (W.util_id != 65649 AND W.type_id = 2)) AND (`post_util_id` = 65649 OR `dest_util_id` = 65649) 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=65649 AND note_visu IN (1,3,4)

26. 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 = 55354 AND W.type_id = 1) OR (W.util_id != 55354 AND W.type_id = 2)) AND (`post_util_id` = 55354 OR `dest_util_id` = 55354) 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=55354 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 = 81553 AND W.type_id = 1) OR (W.util_id != 81553 AND W.type_id = 2)) AND (`post_util_id` = 81553 OR `dest_util_id` = 81553) 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=81553 AND note_visu IN (1,3,4)

30. 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 = 108863 AND W.type_id = 1) OR (W.util_id != 108863 AND W.type_id = 2)) AND (`post_util_id` = 108863 OR `dest_util_id` = 108863) 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=108863 AND note_visu IN (1,3,4)

32. 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 = 82287 AND W.type_id = 1) OR (W.util_id != 82287 AND W.type_id = 2)) AND (`post_util_id` = 82287 OR `dest_util_id` = 82287) 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=82287 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 = 160907 AND W.type_id = 1) OR (W.util_id != 160907 AND W.type_id = 2)) AND (`post_util_id` = 160907 OR `dest_util_id` = 160907) 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=160907 AND note_visu IN (1,3,4)

36. 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 = 127789 AND W.type_id = 1) OR (W.util_id != 127789 AND W.type_id = 2)) AND (`post_util_id` = 127789 OR `dest_util_id` = 127789) 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=127789 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 = 168580 AND W.type_id = 1) OR (W.util_id != 168580 AND W.type_id = 2)) AND (`post_util_id` = 168580 OR `dest_util_id` = 168580) 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=168580 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 = 168649 AND W.type_id = 1) OR (W.util_id != 168649 AND W.type_id = 2)) AND (`post_util_id` = 168649 OR `dest_util_id` = 168649) 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=168649 AND note_visu IN (1,3,4)

42. 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 = 169915 AND W.type_id = 1) OR (W.util_id != 169915 AND W.type_id = 2)) AND (`post_util_id` = 169915 OR `dest_util_id` = 169915) 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=169915 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 = 159721 AND W.type_id = 1) OR (W.util_id != 159721 AND W.type_id = 2)) AND (`post_util_id` = 159721 OR `dest_util_id` = 159721) 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=159721 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 = 186570 AND W.type_id = 1) OR (W.util_id != 186570 AND W.type_id = 2)) AND (`post_util_id` = 186570 OR `dest_util_id` = 186570) 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=186570 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 = 195616 AND W.type_id = 1) OR (W.util_id != 195616 AND W.type_id = 2)) AND (`post_util_id` = 195616 OR `dest_util_id` = 195616) 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=195616 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 = 224631 AND W.type_id = 1) OR (W.util_id != 224631 AND W.type_id = 2)) AND (`post_util_id` = 224631 OR `dest_util_id` = 224631) 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=224631 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 = 133741 AND W.type_id = 1) OR (W.util_id != 133741 AND W.type_id = 2)) AND (`post_util_id` = 133741 OR `dest_util_id` = 133741) 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=133741 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 = 252551 AND W.type_id = 1) OR (W.util_id != 252551 AND W.type_id = 2)) AND (`post_util_id` = 252551 OR `dest_util_id` = 252551) 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=252551 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 = 53673 AND W.type_id = 1) OR (W.util_id != 53673 AND W.type_id = 2)) AND (`post_util_id` = 53673 OR `dest_util_id` = 53673) 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=53673 AND note_visu IN (1,3,4)

58. 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 = 271332 AND W.type_id = 1) OR (W.util_id != 271332 AND W.type_id = 2)) AND (`post_util_id` = 271332 OR `dest_util_id` = 271332) 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=271332 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 = 272388 AND W.type_id = 1) OR (W.util_id != 272388 AND W.type_id = 2)) AND (`post_util_id` = 272388 OR `dest_util_id` = 272388) 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=272388 AND note_visu IN (1,3,4)

62. 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 = 272388 AND W.type_id = 1) OR (W.util_id != 272388 AND W.type_id = 2)) AND (`post_util_id` = 272388 OR `dest_util_id` = 272388) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

63. 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 = 153703 AND W.type_id = 1) OR (W.util_id != 153703 AND W.type_id = 2)) AND (`post_util_id` = 153703 OR `dest_util_id` = 153703) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

64. 0.0001

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

65. 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 = 301918 AND W.type_id = 1) OR (W.util_id != 301918 AND W.type_id = 2)) AND (`post_util_id` = 301918 OR `dest_util_id` = 301918) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

66. 0.0001

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

67. 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 = 253456 AND W.type_id = 1) OR (W.util_id != 253456 AND W.type_id = 2)) AND (`post_util_id` = 253456 OR `dest_util_id` = 253456) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

68. 0.0001

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

69. 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 = 325250 AND W.type_id = 1) OR (W.util_id != 325250 AND W.type_id = 2)) AND (`post_util_id` = 325250 OR `dest_util_id` = 325250) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

70. 0.0001

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

71. 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 = 275461 AND W.type_id = 1) OR (W.util_id != 275461 AND W.type_id = 2)) AND (`post_util_id` = 275461 OR `dest_util_id` = 275461) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

72. 0.0001

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

73. 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 = 350295 AND W.type_id = 1) OR (W.util_id != 350295 AND W.type_id = 2)) AND (`post_util_id` = 350295 OR `dest_util_id` = 350295) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

74. 0.0001

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

75. 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 = 356322 AND W.type_id = 1) OR (W.util_id != 356322 AND W.type_id = 2)) AND (`post_util_id` = 356322 OR `dest_util_id` = 356322) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

76. 0.0001

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

77. 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 = 372985 AND W.type_id = 1) OR (W.util_id != 372985 AND W.type_id = 2)) AND (`post_util_id` = 372985 OR `dest_util_id` = 372985) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

78. 0.0001

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

79. 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 = 364073 AND W.type_id = 1) OR (W.util_id != 364073 AND W.type_id = 2)) AND (`post_util_id` = 364073 OR `dest_util_id` = 364073) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

80. 0.0001

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

81. 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 = 40840 AND W.type_id = 1) OR (W.util_id != 40840 AND W.type_id = 2)) AND (`post_util_id` = 40840 OR `dest_util_id` = 40840) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

82. 0.0001

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

83. 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 = 314952 AND W.type_id = 1) OR (W.util_id != 314952 AND W.type_id = 2)) AND (`post_util_id` = 314952 OR `dest_util_id` = 314952) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

84. 0.0001

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

85. 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 = 455325 AND W.type_id = 1) OR (W.util_id != 455325 AND W.type_id = 2)) AND (`post_util_id` = 455325 OR `dest_util_id` = 455325) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

86. 0.0001

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

87. 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 = 455325 AND W.type_id = 1) OR (W.util_id != 455325 AND W.type_id = 2)) AND (`post_util_id` = 455325 OR `dest_util_id` = 455325) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

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 = 465319 AND W.type_id = 1) OR (W.util_id != 465319 AND W.type_id = 2)) AND (`post_util_id` = 465319 OR `dest_util_id` = 465319) 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=465319 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 = 493112 AND W.type_id = 1) OR (W.util_id != 493112 AND W.type_id = 2)) AND (`post_util_id` = 493112 OR `dest_util_id` = 493112) 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=493112 AND note_visu IN (1,3,4)

92. 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 = 135210 AND W.type_id = 1) OR (W.util_id != 135210 AND W.type_id = 2)) AND (`post_util_id` = 135210 OR `dest_util_id` = 135210) 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=135210 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 = 82401 AND W.type_id = 1) OR (W.util_id != 82401 AND W.type_id = 2)) AND (`post_util_id` = 82401 OR `dest_util_id` = 82401) 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=82401 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 = 513183 AND W.type_id = 1) OR (W.util_id != 513183 AND W.type_id = 2)) AND (`post_util_id` = 513183 OR `dest_util_id` = 513183) 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=513183 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 = 185499 AND W.type_id = 1) OR (W.util_id != 185499 AND W.type_id = 2)) AND (`post_util_id` = 185499 OR `dest_util_id` = 185499) 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=185499 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 = 515974 AND W.type_id = 1) OR (W.util_id != 515974 AND W.type_id = 2)) AND (`post_util_id` = 515974 OR `dest_util_id` = 515974) 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=515974 AND note_visu IN (1,3,4)

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

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

104. 0.0001

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

105. 0.0009

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

106. 0

     SELECT count(*) as nbwish FROM wish

107. 0.0477

     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

107 requetes sql en 0.1861