Location logement contre service à 78800 Houilles

1. 0.0001

   SELECT cate_id FROM category WHERE fami_id='5' AND cate_title_slug='chambre-chez-l-habitant'

2. 0

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

3. 0.0001

   SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='78'

4. 0.0001

   SELECT ville_nom FROM villes WHERE ville_cp='78800' AND ville_nom like '%houilles%' 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 '%logement%contre%service%' OR ssrubr_title like '%logement%contre%service%' OR ssrubr_slug like '%logement%contre%service%') AND cate_id='193' 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='78800'

7. 0.0024

   SELECT ville_cp, ROUND((((acos(sin((48.9167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.736835678816 AND ville_latitude_deg<49.096564321184 AND ville_longitude_deg>1.926298272488 AND ville_longitude_deg<2.473701727512 HAVING distance <= 20 ORDER BY distance ASC

8. 0.0001

   SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='contre service; logement contre service'

9. 0.0005

   SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='5' AND cate_id='193'AND MATCH (wish_title,wish_desc) AGAINST ('+contre service; logement contre service*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '78800%'

10. 0.0001

    SELECT * FROM texte WHERE cate_id=193

11. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='5' AND (ssrubr_keywords='contre service; logement contre service' OR ssrubr_slug='contre-service;-logement-contre-service' OR (ssrubr_title like '%contre service; logement contre service%')) AND cate_id='193' 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.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='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 (193) ORDER BY ssrubr_order ASC

15. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='logement-contre-service' AND cate_id='193'

16. 0.0001

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

17. 0.0017

    SELECT ville_cp, ROUND((((acos(sin((48.9167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.736835678816 AND ville_latitude_deg<49.096564321184 AND ville_longitude_deg>1.926298272488 AND ville_longitude_deg<2.473701727512 HAVING distance <= 20 ORDER BY distance ASC

18. 0.0053

    SELECT ville_cp, ROUND((((acos(sin((48.9167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.467039197041 AND ville_latitude_deg<49.366360802959 AND ville_longitude_deg>1.5157397807905 AND ville_longitude_deg<2.8842602192095 HAVING distance <= 50 ORDER BY distance ASC

19. 0.0298

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='5' AND cate_id='193' AND MATCH (wish_desc) AGAINST ('(+contre +service; +logement +contre +service*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (78800,78800,78420,92000,95870,78360,92700,92500,78500,92250,92400,92270,95100,78600,78400,95530,78600,92800,92150,92200,92600,78110,92300,95110,78560,78290,78380,95240,95370,92110,92230,78230,95130,95218,95210,78430,78170,92210,92380,78100,93800,95120,78750,92430,92420,95130,95220,93450,92390,93400,92100,95880,78160,92410,95230,78700,78112,95600,78150,78300,92310,95250,78260,78620,78870,93430,95480,78150,95320,93200,93210,95580,95580,92170,95390,92130,95170,78570,78590,95360,75007,75003,75002,75000,75001,75013,75019,75116,75020,75004,75008,75009,75010,75017,75011,75012,75006,75018,75005,75016,75015,75014,78240,92190,92360,95680,78955,92370,95150,95550,78140,78220,95410,95610,92240,93380,93120,93300,95160,78780,78240,92140,78000,93240,92120,78570,92320,78590,93500,95000,94250,95740,92220,78670,78670,93310,95840,95350,78860,95560,95350,92350,78330,78630,93350,95310,92330,92260,95000,95330,94110,78210,93440,95400,95200,78450,78510,95280,94270,95570,95300,95540,95140,78540,93170,95430,95840,78350,78530,78350,92290,95440,94205,94200,93260,93230,95400,78480,78450,95570,94231,94234,94239,94238,94237,94236,94233,94235,94232,94230,94240,95490,95460,94800,92340,95500,78810,93100,95300,95560,95000,94160,93150,93700,93000,95570,95430,95630,91570,94300,78390,95560,91370,95520,78280,95180,94220,78340,95590,78117,95800,78630,93140,95500,93130,78121,92160,94550,95650)

20. 0.0261

    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.9167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- 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='193' AND MATCH (wish_desc) AGAINST ('(+contre +service; +logement +contre +service*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (78800,78800,78420,92000,95870,78360,92700,92500,78500,92250,92400,92270,95100,78600,78400,95530,78600,92800,92150,92200,92600,78110,92300,95110,78560,78290,78380,95240,95370,92110,92230,78230,95130,95218,95210,78430,78170,92210,92380,78100,93800,95120,78750,92430,92420,95130,95220,93450,92390,93400,92100,95880,78160,92410,95230,78700,78112,95600,78150,78300,92310,95250,78260,78620,78870,93430,95480,78150,95320,93200,93210,95580,95580,92170,95390,92130,95170,78570,78590,95360,75007,75003,75002,75000,75001,75013,75019,75116,75020,75004,75008,75009,75010,75017,75011,75012,75006,75018,75005,75016,75015,75014,78240,92190,92360,95680,78955,92370,95150,95550,78140,78220,95410,95610,92240,93380,93120,93300,95160,78780,78240,92140,78000,93240,92120,78570,92320,78590,93500,95000,94250,95740,92220,78670,78670,93310,95840,95350,78860,95560,95350,92350,78330,78630,93350,95310,92330,92260,95000,95330,94110,78210,93440,95400,95200,78450,78510,95280,94270,95570,95300,95540,95140,78540,93170,95430,95840,78350,78530,78350,92290,95440,94205,94200,93260,93230,95400,78480,78450,95570,94231,94234,94239,94238,94237,94236,94233,94235,94232,94230,94240,95490,95460,94800,92340,95500,78810,93100,95300,95560,95000,94160,93150,93700,93000,95570,95430,95630,91570,94300,78390,95560,91370,95520,78280,95180,94220,78340,95590,78117,95800,78630,93140,95500,93130,78121,92160,94550,95650) 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='78800'

22. 0.0017

    SELECT ville_cp, ROUND((((acos(sin((48.9167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.736835678816 AND ville_latitude_deg<49.096564321184 AND ville_longitude_deg>1.926298272488 AND ville_longitude_deg<2.473701727512 HAVING distance <= 20 ORDER BY distance ASC

23. 0.0051

    SELECT ville_cp, ROUND((((acos(sin((48.9167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.467039197041 AND ville_latitude_deg<49.366360802959 AND ville_longitude_deg>1.5157397807905 AND ville_longitude_deg<2.8842602192095 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 = 7564 AND W.type_id = 1) OR (W.util_id != 7564 AND W.type_id = 2)) AND (`post_util_id` = 7564 OR `dest_util_id` = 7564) 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=7564 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 = 37541 AND W.type_id = 1) OR (W.util_id != 37541 AND W.type_id = 2)) AND (`post_util_id` = 37541 OR `dest_util_id` = 37541) 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=37541 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 = 55610 AND W.type_id = 1) OR (W.util_id != 55610 AND W.type_id = 2)) AND (`post_util_id` = 55610 OR `dest_util_id` = 55610) 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=55610 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 = 57503 AND W.type_id = 1) OR (W.util_id != 57503 AND W.type_id = 2)) AND (`post_util_id` = 57503 OR `dest_util_id` = 57503) 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=57503 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 = 79775 AND W.type_id = 1) OR (W.util_id != 79775 AND W.type_id = 2)) AND (`post_util_id` = 79775 OR `dest_util_id` = 79775) 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=79775 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 = 74779 AND W.type_id = 1) OR (W.util_id != 74779 AND W.type_id = 2)) AND (`post_util_id` = 74779 OR `dest_util_id` = 74779) 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=74779 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 = 139073 AND W.type_id = 1) OR (W.util_id != 139073 AND W.type_id = 2)) AND (`post_util_id` = 139073 OR `dest_util_id` = 139073) 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=139073 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 = 166547 AND W.type_id = 1) OR (W.util_id != 166547 AND W.type_id = 2)) AND (`post_util_id` = 166547 OR `dest_util_id` = 166547) 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=166547 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 = 194609 AND W.type_id = 1) OR (W.util_id != 194609 AND W.type_id = 2)) AND (`post_util_id` = 194609 OR `dest_util_id` = 194609) 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=194609 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 = 197626 AND W.type_id = 1) OR (W.util_id != 197626 AND W.type_id = 2)) AND (`post_util_id` = 197626 OR `dest_util_id` = 197626) 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=197626 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 = 216848 AND W.type_id = 1) OR (W.util_id != 216848 AND W.type_id = 2)) AND (`post_util_id` = 216848 OR `dest_util_id` = 216848) 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=216848 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 = 220137 AND W.type_id = 1) OR (W.util_id != 220137 AND W.type_id = 2)) AND (`post_util_id` = 220137 OR `dest_util_id` = 220137) 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=220137 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 = 222004 AND W.type_id = 1) OR (W.util_id != 222004 AND W.type_id = 2)) AND (`post_util_id` = 222004 OR `dest_util_id` = 222004) 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=222004 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 = 224614 AND W.type_id = 1) OR (W.util_id != 224614 AND W.type_id = 2)) AND (`post_util_id` = 224614 OR `dest_util_id` = 224614) 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=224614 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 = 237877 AND W.type_id = 1) OR (W.util_id != 237877 AND W.type_id = 2)) AND (`post_util_id` = 237877 OR `dest_util_id` = 237877) 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=237877 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 = 242448 AND W.type_id = 1) OR (W.util_id != 242448 AND W.type_id = 2)) AND (`post_util_id` = 242448 OR `dest_util_id` = 242448) 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=242448 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 = 158553 AND W.type_id = 1) OR (W.util_id != 158553 AND W.type_id = 2)) AND (`post_util_id` = 158553 OR `dest_util_id` = 158553) 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=158553 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 = 255673 AND W.type_id = 1) OR (W.util_id != 255673 AND W.type_id = 2)) AND (`post_util_id` = 255673 OR `dest_util_id` = 255673) 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=255673 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 = 285115 AND W.type_id = 1) OR (W.util_id != 285115 AND W.type_id = 2)) AND (`post_util_id` = 285115 OR `dest_util_id` = 285115) 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=285115 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 = 304258 AND W.type_id = 1) OR (W.util_id != 304258 AND W.type_id = 2)) AND (`post_util_id` = 304258 OR `dest_util_id` = 304258) 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=304258 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 = 312682 AND W.type_id = 1) OR (W.util_id != 312682 AND W.type_id = 2)) AND (`post_util_id` = 312682 OR `dest_util_id` = 312682) 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=312682 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 = 309852 AND W.type_id = 1) OR (W.util_id != 309852 AND W.type_id = 2)) AND (`post_util_id` = 309852 OR `dest_util_id` = 309852) 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=309852 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 = 349458 AND W.type_id = 1) OR (W.util_id != 349458 AND W.type_id = 2)) AND (`post_util_id` = 349458 OR `dest_util_id` = 349458) 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=349458 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 = 354730 AND W.type_id = 1) OR (W.util_id != 354730 AND W.type_id = 2)) AND (`post_util_id` = 354730 OR `dest_util_id` = 354730) 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=354730 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 = 355213 AND W.type_id = 1) OR (W.util_id != 355213 AND W.type_id = 2)) AND (`post_util_id` = 355213 OR `dest_util_id` = 355213) 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=355213 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 = 357745 AND W.type_id = 1) OR (W.util_id != 357745 AND W.type_id = 2)) AND (`post_util_id` = 357745 OR `dest_util_id` = 357745) 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=357745 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 = 369154 AND W.type_id = 1) OR (W.util_id != 369154 AND W.type_id = 2)) AND (`post_util_id` = 369154 OR `dest_util_id` = 369154) 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=369154 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 = 387443 AND W.type_id = 1) OR (W.util_id != 387443 AND W.type_id = 2)) AND (`post_util_id` = 387443 OR `dest_util_id` = 387443) 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=387443 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 = 41521 AND W.type_id = 1) OR (W.util_id != 41521 AND W.type_id = 2)) AND (`post_util_id` = 41521 OR `dest_util_id` = 41521) 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=41521 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 = 398738 AND W.type_id = 1) OR (W.util_id != 398738 AND W.type_id = 2)) AND (`post_util_id` = 398738 OR `dest_util_id` = 398738) 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=398738 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 = 402105 AND W.type_id = 1) OR (W.util_id != 402105 AND W.type_id = 2)) AND (`post_util_id` = 402105 OR `dest_util_id` = 402105) 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=402105 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 = 407490 AND W.type_id = 1) OR (W.util_id != 407490 AND W.type_id = 2)) AND (`post_util_id` = 407490 OR `dest_util_id` = 407490) 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=407490 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 = 408472 AND W.type_id = 1) OR (W.util_id != 408472 AND W.type_id = 2)) AND (`post_util_id` = 408472 OR `dest_util_id` = 408472) 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=408472 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 = 419710 AND W.type_id = 1) OR (W.util_id != 419710 AND W.type_id = 2)) AND (`post_util_id` = 419710 OR `dest_util_id` = 419710) 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=419710 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 = 421834 AND W.type_id = 1) OR (W.util_id != 421834 AND W.type_id = 2)) AND (`post_util_id` = 421834 OR `dest_util_id` = 421834) 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=421834 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 = 403098 AND W.type_id = 1) OR (W.util_id != 403098 AND W.type_id = 2)) AND (`post_util_id` = 403098 OR `dest_util_id` = 403098) 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=403098 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 = 448352 AND W.type_id = 1) OR (W.util_id != 448352 AND W.type_id = 2)) AND (`post_util_id` = 448352 OR `dest_util_id` = 448352) 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=448352 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 = 486393 AND W.type_id = 1) OR (W.util_id != 486393 AND W.type_id = 2)) AND (`post_util_id` = 486393 OR `dest_util_id` = 486393) 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=486393 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 = 518475 AND W.type_id = 1) OR (W.util_id != 518475 AND W.type_id = 2)) AND (`post_util_id` = 518475 OR `dest_util_id` = 518475) 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=518475 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 = 514430 AND W.type_id = 1) OR (W.util_id != 514430 AND W.type_id = 2)) AND (`post_util_id` = 514430 OR `dest_util_id` = 514430) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

103. 0.0001

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

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

105. 0.0001

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

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

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

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

110. 0.0001

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

111. 0.0001

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

112. 0.0008

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

113. 0

     SELECT count(*) as nbwish FROM wish

114. 0.0507

     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

114 requetes sql en 0.1348