Indiquer un code postal ou une ville

Flèche vers le champ lieu

Service ménage à 60530 Ercuis


Retour
Fermer

Service › Ménage/repassage

Lancez votre recherche pour voir les annonces.

Service ménage : 1 annonces de ménage entre particuliers à 60530 Ercuis Vous recherchez une femme de ménage pour votre domicile ? Ou vous êtes à la recherche d'un emploi de femme de ménage à domicile : déposez votre annonce pour recevoir les offres de voisins intéressés.
 ... voir la suite
Service aide menagere
Service aide menagere
Repasse/ menage
Profil du voisin
Lizabete C

25 km · Louvres 95380

13€/h

Service menage
Service menage
Femme de ménage
Profil du voisin
Voisin #39712

25 km · Louvres 95380

15€/h

<
1
2
>>
Demander un service / jobbing de menage ou proposer un service de menage entre particuliers.
Poster une annonce

Trouver

Trouver
Demandes des voisins

Demandes

 créer une annonce
Messagerie

Messages

 Mon profil

Profil

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wall.php

  1. 0.0001

    SELECT cate_id FROM category WHERE fami_id='3' AND cate_title_slug='menage-repassage'

  2. 0

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

  3. 0

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='60'

  4. 0.0001

    SELECT ville_nom FROM villes WHERE ville_cp='60530' AND ville_nom like '%ercuis%' 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 '%menage%' OR ssrubr_title like '%menage%' OR ssrubr_slug like '%menage%') AND cate_id='47' 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='60530'

  7. 0.0019

    SELECT ville_cp, ROUND((((acos(sin((49.2*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.2*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.3- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.020135678816 AND ville_latitude_deg<49.379864321184 AND ville_longitude_deg>2.0247337847846 AND ville_longitude_deg<2.5752662152154 HAVING distance <= 20 ORDER BY distance ASC

  8. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='menage'

  9. 0.0008

    SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='47'AND MATCH (wish_title,wish_desc) AGAINST ('+menage*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '60530%'

  10. 0.0001

    SELECT * FROM texte WHERE cate_id=47

  11. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='3' AND (ssrubr_keywords='menage' OR ssrubr_slug='menage' OR (ssrubr_title like '%menage%')) AND cate_id='47' 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='3' AND cate_cate_id IS NULL ORDER BY cate_order ASC

  14. 0.0001

    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 (47) ORDER BY ssrubr_order ASC

  15. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='menage' AND cate_id='47'

  16. 0.0001

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

  17. 0.002

    SELECT ville_cp, ROUND((((acos(sin((49.2*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.2*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.3- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.020135678816 AND ville_latitude_deg<49.379864321184 AND ville_longitude_deg>2.0247337847846 AND ville_longitude_deg<2.5752662152154 HAVING distance <= 20 ORDER BY distance ASC

  18. 0.0065

    SELECT ville_cp, ROUND((((acos(sin((49.2*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.2*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.3- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.750339197041 AND ville_latitude_deg<49.649660802959 AND ville_longitude_deg>1.6118285278048 AND ville_longitude_deg<2.9881714721952 HAVING distance <= 50 ORDER BY distance ASC

  19. 0.0451

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='47' AND MATCH (wish_desc) AGAINST ('(+menage*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (60530,60530,60530,60530,60530,60530,95340,60530,95820,60460,60460,60540,60530,60230,60820,60540,60540,95340,60540,95340,95590,60540,60340,95260,95260,95270,95660,95270,60270,60340,60660,60730,95270,60660,60660,95590,60730,60250,60660,60660,60110,60730,95290,60740,95620,60570,60160,60260,95690,60570,95690,60250,95270,60730,60730,95270,60500,60160,95690,95270,60110,60250,95560,95590,95690,60660,95760,60500,60110,60580,95270,60250,95570,60180,95270,95810,95560,95560,95630,95430,60100,95810,60250,95270,60110,60570,60290,95810,95270,95270,95840,60175,60300,60870,60430,60290,95270,95300,60430,60290,95720,95540,95570,60250,95560,60250,60250,95570,60290,60300,95850,60300,95810,95570,95840,60110,60790,95470,60250,60560,60290,95850,95430,60140,95740,95810,60119,60430,60290,95720,60550,95640,95300,60430,95190,60149,60520,60370,60300,95330,60250,60370,60520,60140,60790,60370,95460,60870,95810,60940,60790,95670,95150,95550,95810,60173,60430,60140,95190,95380)

  20. 0.0477

    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((49.2*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.2*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.3- 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='47' AND MATCH (wish_desc) AGAINST ('(+menage*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (60530,60530,60530,60530,60530,60530,95340,60530,95820,60460,60460,60540,60530,60230,60820,60540,60540,95340,60540,95340,95590,60540,60340,95260,95260,95270,95660,95270,60270,60340,60660,60730,95270,60660,60660,95590,60730,60250,60660,60660,60110,60730,95290,60740,95620,60570,60160,60260,95690,60570,95690,60250,95270,60730,60730,95270,60500,60160,95690,95270,60110,60250,95560,95590,95690,60660,95760,60500,60110,60580,95270,60250,95570,60180,95270,95810,95560,95560,95630,95430,60100,95810,60250,95270,60110,60570,60290,95810,95270,95270,95840,60175,60300,60870,60430,60290,95270,95300,60430,60290,95720,95540,95570,60250,95560,60250,60250,95570,60290,60300,95850,60300,95810,95570,95840,60110,60790,95470,60250,60560,60290,95850,95430,60140,95740,95810,60119,60430,60290,95720,60550,95640,95300,60430,95190,60149,60520,60370,60300,95330,60250,60370,60520,60140,60790,60370,95460,60870,95810,60940,60790,95670,95150,95550,95810,60173,60430,60140,95190,95380) 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='60530'

  22. 0.0015

    SELECT ville_cp, ROUND((((acos(sin((49.2*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.2*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.3- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.020135678816 AND ville_latitude_deg<49.379864321184 AND ville_longitude_deg>2.0247337847846 AND ville_longitude_deg<2.5752662152154 HAVING distance <= 20 ORDER BY distance ASC

  23. 0.0056

    SELECT ville_cp, ROUND((((acos(sin((49.2*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.2*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.3- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.750339197041 AND ville_latitude_deg<49.649660802959 AND ville_longitude_deg>1.6118285278048 AND ville_longitude_deg<2.9881714721952 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 = 8415 AND W.type_id = 1) OR (W.util_id != 8415 AND W.type_id = 2)) AND (`post_util_id` = 8415 OR `dest_util_id` = 8415) 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=8415 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 = 16473 AND W.type_id = 1) OR (W.util_id != 16473 AND W.type_id = 2)) AND (`post_util_id` = 16473 OR `dest_util_id` = 16473) 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=16473 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 = 3799 AND W.type_id = 1) OR (W.util_id != 3799 AND W.type_id = 2)) AND (`post_util_id` = 3799 OR `dest_util_id` = 3799) 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=3799 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 = 30781 AND W.type_id = 1) OR (W.util_id != 30781 AND W.type_id = 2)) AND (`post_util_id` = 30781 OR `dest_util_id` = 30781) 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=30781 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 = 39712 AND W.type_id = 1) OR (W.util_id != 39712 AND W.type_id = 2)) AND (`post_util_id` = 39712 OR `dest_util_id` = 39712) 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=39712 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 = 50019 AND W.type_id = 1) OR (W.util_id != 50019 AND W.type_id = 2)) AND (`post_util_id` = 50019 OR `dest_util_id` = 50019) 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=50019 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 = 54742 AND W.type_id = 1) OR (W.util_id != 54742 AND W.type_id = 2)) AND (`post_util_id` = 54742 OR `dest_util_id` = 54742) 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=54742 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 = 67224 AND W.type_id = 1) OR (W.util_id != 67224 AND W.type_id = 2)) AND (`post_util_id` = 67224 OR `dest_util_id` = 67224) 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=67224 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 = 67536 AND W.type_id = 1) OR (W.util_id != 67536 AND W.type_id = 2)) AND (`post_util_id` = 67536 OR `dest_util_id` = 67536) 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=67536 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 = 68409 AND W.type_id = 1) OR (W.util_id != 68409 AND W.type_id = 2)) AND (`post_util_id` = 68409 OR `dest_util_id` = 68409) 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=68409 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 = 73343 AND W.type_id = 1) OR (W.util_id != 73343 AND W.type_id = 2)) AND (`post_util_id` = 73343 OR `dest_util_id` = 73343) 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=73343 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 = 73347 AND W.type_id = 1) OR (W.util_id != 73347 AND W.type_id = 2)) AND (`post_util_id` = 73347 OR `dest_util_id` = 73347) 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=73347 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 = 73804 AND W.type_id = 1) OR (W.util_id != 73804 AND W.type_id = 2)) AND (`post_util_id` = 73804 OR `dest_util_id` = 73804) 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=73804 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 = 73786 AND W.type_id = 1) OR (W.util_id != 73786 AND W.type_id = 2)) AND (`post_util_id` = 73786 OR `dest_util_id` = 73786) 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=73786 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 = 81860 AND W.type_id = 1) OR (W.util_id != 81860 AND W.type_id = 2)) AND (`post_util_id` = 81860 OR `dest_util_id` = 81860) 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=81860 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 = 84497 AND W.type_id = 1) OR (W.util_id != 84497 AND W.type_id = 2)) AND (`post_util_id` = 84497 OR `dest_util_id` = 84497) 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=84497 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 = 87217 AND W.type_id = 1) OR (W.util_id != 87217 AND W.type_id = 2)) AND (`post_util_id` = 87217 OR `dest_util_id` = 87217) 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=87217 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 = 106263 AND W.type_id = 1) OR (W.util_id != 106263 AND W.type_id = 2)) AND (`post_util_id` = 106263 OR `dest_util_id` = 106263) 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=106263 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 = 85106 AND W.type_id = 1) OR (W.util_id != 85106 AND W.type_id = 2)) AND (`post_util_id` = 85106 OR `dest_util_id` = 85106) 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=85106 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 = 114066 AND W.type_id = 1) OR (W.util_id != 114066 AND W.type_id = 2)) AND (`post_util_id` = 114066 OR `dest_util_id` = 114066) 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=114066 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 = 114314 AND W.type_id = 1) OR (W.util_id != 114314 AND W.type_id = 2)) AND (`post_util_id` = 114314 OR `dest_util_id` = 114314) 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=114314 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 = 88059 AND W.type_id = 1) OR (W.util_id != 88059 AND W.type_id = 2)) AND (`post_util_id` = 88059 OR `dest_util_id` = 88059) 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=88059 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 = 122348 AND W.type_id = 1) OR (W.util_id != 122348 AND W.type_id = 2)) AND (`post_util_id` = 122348 OR `dest_util_id` = 122348) 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=122348 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 = 137759 AND W.type_id = 1) OR (W.util_id != 137759 AND W.type_id = 2)) AND (`post_util_id` = 137759 OR `dest_util_id` = 137759) 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=137759 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 = 145408 AND W.type_id = 1) OR (W.util_id != 145408 AND W.type_id = 2)) AND (`post_util_id` = 145408 OR `dest_util_id` = 145408) 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=145408 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 = 149164 AND W.type_id = 1) OR (W.util_id != 149164 AND W.type_id = 2)) AND (`post_util_id` = 149164 OR `dest_util_id` = 149164) 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=149164 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 = 165686 AND W.type_id = 1) OR (W.util_id != 165686 AND W.type_id = 2)) AND (`post_util_id` = 165686 OR `dest_util_id` = 165686) 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=165686 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 = 164612 AND W.type_id = 1) OR (W.util_id != 164612 AND W.type_id = 2)) AND (`post_util_id` = 164612 OR `dest_util_id` = 164612) 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=164612 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 = 191795 AND W.type_id = 1) OR (W.util_id != 191795 AND W.type_id = 2)) AND (`post_util_id` = 191795 OR `dest_util_id` = 191795) 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=191795 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 = 194426 AND W.type_id = 1) OR (W.util_id != 194426 AND W.type_id = 2)) AND (`post_util_id` = 194426 OR `dest_util_id` = 194426) 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=194426 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 = 67400 AND W.type_id = 1) OR (W.util_id != 67400 AND W.type_id = 2)) AND (`post_util_id` = 67400 OR `dest_util_id` = 67400) 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=67400 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 = 198204 AND W.type_id = 1) OR (W.util_id != 198204 AND W.type_id = 2)) AND (`post_util_id` = 198204 OR `dest_util_id` = 198204) 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=198204 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 = 199611 AND W.type_id = 1) OR (W.util_id != 199611 AND W.type_id = 2)) AND (`post_util_id` = 199611 OR `dest_util_id` = 199611) 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=199611 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 = 207615 AND W.type_id = 1) OR (W.util_id != 207615 AND W.type_id = 2)) AND (`post_util_id` = 207615 OR `dest_util_id` = 207615) 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=207615 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 = 214201 AND W.type_id = 1) OR (W.util_id != 214201 AND W.type_id = 2)) AND (`post_util_id` = 214201 OR `dest_util_id` = 214201) 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=214201 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 = 222150 AND W.type_id = 1) OR (W.util_id != 222150 AND W.type_id = 2)) AND (`post_util_id` = 222150 OR `dest_util_id` = 222150) 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=222150 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 = 169798 AND W.type_id = 1) OR (W.util_id != 169798 AND W.type_id = 2)) AND (`post_util_id` = 169798 OR `dest_util_id` = 169798) 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=169798 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 = 223976 AND W.type_id = 1) OR (W.util_id != 223976 AND W.type_id = 2)) AND (`post_util_id` = 223976 OR `dest_util_id` = 223976) 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=223976 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 = 185146 AND W.type_id = 1) OR (W.util_id != 185146 AND W.type_id = 2)) AND (`post_util_id` = 185146 OR `dest_util_id` = 185146) 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=185146 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 = 225232 AND W.type_id = 1) OR (W.util_id != 225232 AND W.type_id = 2)) AND (`post_util_id` = 225232 OR `dest_util_id` = 225232) 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=225232 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 = 227505 AND W.type_id = 1) OR (W.util_id != 227505 AND W.type_id = 2)) AND (`post_util_id` = 227505 OR `dest_util_id` = 227505) 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=227505 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 = 229425 AND W.type_id = 1) OR (W.util_id != 229425 AND W.type_id = 2)) AND (`post_util_id` = 229425 OR `dest_util_id` = 229425) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  107. 0.0001

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

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

  109. 0.0001

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

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

  111. 0.0001

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

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

  113. 0.0001

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

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

  115. 0.0001

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

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

  117. 0.0001

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

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

  119. 0.0001

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

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

  121. 0.0001

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

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

  123. 0.0001

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

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

  125. 0.0001

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

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

  127. 0.0001

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

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

  129. 0.0001

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

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

  131. 0.0001

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

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

  133. 0.0001

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

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

  135. 0.0001

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

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

  137. 0.0001

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

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

  139. 0.0001

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

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

  141. 0.0001

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

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

  143. 0.0001

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

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

  145. 0.0001

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

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

  147. 0.0001

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

  148. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo 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='1080' LIMIT 0,1

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

  150. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 114314

  151. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo 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='937' LIMIT 0,1

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

  153. 0.0001

    SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 39712

  154. 0.0001

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

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

  156. 0.0001

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

  157. 0.0008

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

  158. 0

    SELECT count(*) as nbwish FROM wish

  159. 0.0472

    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

159 requetes sql en 0.1739

Taille variable Globale : 81.57 KB