Indiquer un code postal ou une ville

Flèche vers le champ lieu

Service nettoyage à 91540 Mennecy


Retour
Fermer

Service › Ménage/repassage

Lancez votre recherche pour voir les annonces.

<
1
2
>>
Demander un service / jobbing de nettoyage ou proposer un service de nettoyage 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.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='91'

  4. 0.0001

    SELECT ville_nom FROM villes WHERE ville_cp='91540' AND ville_nom like '%mennecy%' 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 '%nettoyage%' OR ssrubr_title like '%nettoyage%' OR ssrubr_slug like '%nettoyage%') 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='91540'

  7. 0.0017

    SELECT ville_cp, ROUND((((acos(sin((48.55*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.55*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.4- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.370135678816 AND ville_latitude_deg<48.729864321184 AND ville_longitude_deg>2.1282873140569 AND ville_longitude_deg<2.6717126859431 HAVING distance <= 20 ORDER BY distance ASC

  8. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='nettoyage'

  9. 0.0009

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

  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='nettoyage' OR ssrubr_slug='nettoyage' OR (ssrubr_title like '%nettoyage%')) 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.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 (47) ORDER BY ssrubr_order ASC

  15. 0.0001

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

  16. 0.0001

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

  17. 0.0016

    SELECT ville_cp, ROUND((((acos(sin((48.55*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.55*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.4- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.370135678816 AND ville_latitude_deg<48.729864321184 AND ville_longitude_deg>2.1282873140569 AND ville_longitude_deg<2.6717126859431 HAVING distance <= 20 ORDER BY distance ASC

  18. 0.0062

    SELECT ville_cp, ROUND((((acos(sin((48.55*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.55*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.4- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.100339197041 AND ville_latitude_deg<48.999660802959 AND ville_longitude_deg>1.7207124275922 AND ville_longitude_deg<3.0792875724078 HAVING distance <= 50 ORDER BY distance ASC

  19. 0.0588

    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 ('(+nettoyage*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (91540,91540,91540,91710,91610,91750,91540,91540,91810,91100,91750,91770,91090,91760,91830,91630,91590,91080,91590,91070,91630,91830,91250,91850,91590,91100,91250,91750,91890,91700,91220,91250,91220,91590,91630,91090,91000,91630,91280,91700,91450,91510,91290,91510,77310,77240,91840,91590,91130,91000,91350,91630,91290,91450,91250,91240,91590,91490,91180,91730,77310,91310,91590,77930,91820,77176,77310,91170,91310,77930,91700,91820,91310,91790,91310,91600,91390,77176,91490,91490,91360,77930,91340,91520,91730,77350,77930,91590,91580,91360,77127,91580,91720,91620,77240,91260,91210,91880,91460,91160,77930,91680,91580,91650,77240,91730,91910,91480,77930,77350,77550,77190,91620,91270,91720,77550,91230,91860,91650,77350,91420,91490,77190,91160,91800,77380,77630,91580,91650,91160,91800,91380,91150,91480,77630,91580,91200,94480,91550,91560,91680,91140,91490,91160,91150,77630,91720,77950,77000,77000,91720,91640,91330,77950,94520,91140,94520)

  20. 0.0647

    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.55*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.55*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.4- 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 ('(+nettoyage*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (91540,91540,91540,91710,91610,91750,91540,91540,91810,91100,91750,91770,91090,91760,91830,91630,91590,91080,91590,91070,91630,91830,91250,91850,91590,91100,91250,91750,91890,91700,91220,91250,91220,91590,91630,91090,91000,91630,91280,91700,91450,91510,91290,91510,77310,77240,91840,91590,91130,91000,91350,91630,91290,91450,91250,91240,91590,91490,91180,91730,77310,91310,91590,77930,91820,77176,77310,91170,91310,77930,91700,91820,91310,91790,91310,91600,91390,77176,91490,91490,91360,77930,91340,91520,91730,77350,77930,91590,91580,91360,77127,91580,91720,91620,77240,91260,91210,91880,91460,91160,77930,91680,91580,91650,77240,91730,91910,91480,77930,77350,77550,77190,91620,91270,91720,77550,91230,91860,91650,77350,91420,91490,77190,91160,91800,77380,77630,91580,91650,91160,91800,91380,91150,91480,77630,91580,91200,94480,91550,91560,91680,91140,91490,91160,91150,77630,91720,77950,77000,77000,91720,91640,91330,77950,94520,91140,94520) 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='91540'

  22. 0.0023

    SELECT ville_cp, ROUND((((acos(sin((48.55*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.55*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.4- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.370135678816 AND ville_latitude_deg<48.729864321184 AND ville_longitude_deg>2.1282873140569 AND ville_longitude_deg<2.6717126859431 HAVING distance <= 20 ORDER BY distance ASC

  23. 0.0076

    SELECT ville_cp, ROUND((((acos(sin((48.55*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.55*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.4- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.100339197041 AND ville_latitude_deg<48.999660802959 AND ville_longitude_deg>1.7207124275922 AND ville_longitude_deg<3.0792875724078 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 = 12265 AND W.type_id = 1) OR (W.util_id != 12265 AND W.type_id = 2)) AND (`post_util_id` = 12265 OR `dest_util_id` = 12265) 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=12265 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 = 37913 AND W.type_id = 1) OR (W.util_id != 37913 AND W.type_id = 2)) AND (`post_util_id` = 37913 OR `dest_util_id` = 37913) 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=37913 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 = 44937 AND W.type_id = 1) OR (W.util_id != 44937 AND W.type_id = 2)) AND (`post_util_id` = 44937 OR `dest_util_id` = 44937) 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=44937 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 = 53336 AND W.type_id = 1) OR (W.util_id != 53336 AND W.type_id = 2)) AND (`post_util_id` = 53336 OR `dest_util_id` = 53336) 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=53336 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 = 71011 AND W.type_id = 1) OR (W.util_id != 71011 AND W.type_id = 2)) AND (`post_util_id` = 71011 OR `dest_util_id` = 71011) 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=71011 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 = 72451 AND W.type_id = 1) OR (W.util_id != 72451 AND W.type_id = 2)) AND (`post_util_id` = 72451 OR `dest_util_id` = 72451) 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=72451 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 = 108330 AND W.type_id = 1) OR (W.util_id != 108330 AND W.type_id = 2)) AND (`post_util_id` = 108330 OR `dest_util_id` = 108330) 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=108330 AND note_visu IN (1,3,4)

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

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

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

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

  62. 0.0003

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

  63. 0.0001

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

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

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

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

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

  88. 0.0001

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

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

  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 = 433385 AND W.type_id = 1) OR (W.util_id != 433385 AND W.type_id = 2)) AND (`post_util_id` = 433385 OR `dest_util_id` = 433385) 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=433385 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 = 417995 AND W.type_id = 1) OR (W.util_id != 417995 AND W.type_id = 2)) AND (`post_util_id` = 417995 OR `dest_util_id` = 417995) 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=417995 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 = 450315 AND W.type_id = 1) OR (W.util_id != 450315 AND W.type_id = 2)) AND (`post_util_id` = 450315 OR `dest_util_id` = 450315) 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=450315 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 = 452364 AND W.type_id = 1) OR (W.util_id != 452364 AND W.type_id = 2)) AND (`post_util_id` = 452364 OR `dest_util_id` = 452364) 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=452364 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 = 37102 AND W.type_id = 1) OR (W.util_id != 37102 AND W.type_id = 2)) AND (`post_util_id` = 37102 OR `dest_util_id` = 37102) 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=37102 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 = 444509 AND W.type_id = 1) OR (W.util_id != 444509 AND W.type_id = 2)) AND (`post_util_id` = 444509 OR `dest_util_id` = 444509) 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=444509 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 = 126661 AND W.type_id = 1) OR (W.util_id != 126661 AND W.type_id = 2)) AND (`post_util_id` = 126661 OR `dest_util_id` = 126661) 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=126661 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 = 126661 AND W.type_id = 1) OR (W.util_id != 126661 AND W.type_id = 2)) AND (`post_util_id` = 126661 OR `dest_util_id` = 126661) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  105. 0.0001

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

  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 = 481881 AND W.type_id = 1) OR (W.util_id != 481881 AND W.type_id = 2)) AND (`post_util_id` = 481881 OR `dest_util_id` = 481881) 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=481881 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 = 156675 AND W.type_id = 1) OR (W.util_id != 156675 AND W.type_id = 2)) AND (`post_util_id` = 156675 OR `dest_util_id` = 156675) 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=156675 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 = 494960 AND W.type_id = 1) OR (W.util_id != 494960 AND W.type_id = 2)) AND (`post_util_id` = 494960 OR `dest_util_id` = 494960) 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=494960 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 = 78874 AND W.type_id = 1) OR (W.util_id != 78874 AND W.type_id = 2)) AND (`post_util_id` = 78874 OR `dest_util_id` = 78874) 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=78874 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 = 299238 AND W.type_id = 1) OR (W.util_id != 299238 AND W.type_id = 2)) AND (`post_util_id` = 299238 OR `dest_util_id` = 299238) 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=299238 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 = 171904 AND W.type_id = 1) OR (W.util_id != 171904 AND W.type_id = 2)) AND (`post_util_id` = 171904 OR `dest_util_id` = 171904) 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=171904 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 = 504171 AND W.type_id = 1) OR (W.util_id != 504171 AND W.type_id = 2)) AND (`post_util_id` = 504171 OR `dest_util_id` = 504171) 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=504171 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 = 515219 AND W.type_id = 1) OR (W.util_id != 515219 AND W.type_id = 2)) AND (`post_util_id` = 515219 OR `dest_util_id` = 515219) 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=515219 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 = 519457 AND W.type_id = 1) OR (W.util_id != 519457 AND W.type_id = 2)) AND (`post_util_id` = 519457 OR `dest_util_id` = 519457) 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=519457 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 = 22423 AND W.type_id = 1) OR (W.util_id != 22423 AND W.type_id = 2)) AND (`post_util_id` = 22423 OR `dest_util_id` = 22423) 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=22423 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 = 541034 AND W.type_id = 1) OR (W.util_id != 541034 AND W.type_id = 2)) AND (`post_util_id` = 541034 OR `dest_util_id` = 541034) 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=541034 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 = 362346 AND W.type_id = 1) OR (W.util_id != 362346 AND W.type_id = 2)) AND (`post_util_id` = 362346 OR `dest_util_id` = 362346) 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=362346 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 = 362346 AND W.type_id = 1) OR (W.util_id != 362346 AND W.type_id = 2)) AND (`post_util_id` = 362346 OR `dest_util_id` = 362346) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

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

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

  133. 0.0001

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

  134. 0.001

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

  135. 0

    SELECT count(*) as nbwish FROM wish

  136. 0.0707

    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

136 requetes sql en 0.2291

Taille variable Globale : 76.16 KB