Indiquer un code postal ou une ville

Flèche vers le champ lieu

Service tonte pelouse à 77340 Pontault-combault


Retour
Fermer

Service › Jardinage

Lancez votre recherche pour voir les annonces.

Service tonte pelouse : 1 annonces de tonte pelouse entre particuliers à 77340 Pontault-combault Faites appel à un particulier jardiner pour tondre votre pelouse. A des prix intéressants, les particuliers qui le souhaitent, proposent leurs services pour tondre la pelouse de voisins à proximité. Un service de jardinage entre particuliers ponctuel qui peut vite devenir une habitude. Publiez une annonce entre particuliers pour proposer ou recherche un jardinier à proximité qui pourra venir tondre la pelouse.
 ... voir la suite
<
1
2
>>
Demander un service / jobbing de tonte de pelouse ou proposer un service de tonte de pelouse 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='jardinage'

  2. 0.0001

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

  3. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt='77'

  4. 0.0001

    SELECT ville_nom FROM villes WHERE ville_cp='77340' AND ville_nom like '%pontault%combault%' 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 '%tonte%de%pelouse%' OR ssrubr_title like '%tonte%de%pelouse%' OR ssrubr_slug like '%tonte%de%pelouse%') AND cate_id='38' 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='77340'

  7. 0.0025

    SELECT ville_cp, ROUND((((acos(sin((48.7984*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7984*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.60528- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.618535678816 AND ville_latitude_deg<48.978264321184 AND ville_longitude_deg>2.3322243489142 AND ville_longitude_deg<2.8783356510858 HAVING distance <= 20 ORDER BY distance ASC

  8. 0.0001

    SELECT keywords_id FROM ssrubr_keywords WHERE keywords_title='tonte pelouse; tonte de pelouse'

  9. 0.0008

    SELECT count(wish_id) as nbwish FROM wish WHERE fami_id='3' AND cate_id='38'AND MATCH (wish_title,wish_desc) AGAINST ('+tonte pelouse; tonte de pelouse*' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp like '77340%'

  10. 0.0001

    SELECT * FROM texte WHERE cate_id=38

  11. 0.0002

    SELECT ssrubr_texte_haut FROM ssrubr WHERE fami_id='3' AND (ssrubr_keywords='tonte pelouse; tonte de pelouse' OR ssrubr_slug='tonte-pelouse;-tonte-de-pelouse' OR (ssrubr_title like '%tonte pelouse; tonte de pelouse%')) AND cate_id='38' 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 (38) ORDER BY ssrubr_order ASC

  15. 0.0001

    SELECT ssrubr_texte_haut, ssrubr_texte_bas FROM ssrubr WHERE ssrubr_slug='tonte-de-pelouse' AND cate_id='38'

  16. 0.0001

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

  17. 0.0017

    SELECT ville_cp, ROUND((((acos(sin((48.7984*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7984*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.60528- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.618535678816 AND ville_latitude_deg<48.978264321184 AND ville_longitude_deg>2.3322243489142 AND ville_longitude_deg<2.8783356510858 HAVING distance <= 20 ORDER BY distance ASC

  18. 0.0067

    SELECT ville_cp, ROUND((((acos(sin((48.7984*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7984*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.60528- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.348739197041 AND ville_latitude_deg<49.248060802959 AND ville_longitude_deg>1.922634985784 AND ville_longitude_deg<3.287925014216 HAVING distance <= 50 ORDER BY distance ASC

  19. 0.048

    SELECT count(wish_id) as nbwish FROM wish WHERE wish_id IS NOT NULL AND fami_id='3' AND cate_id='38' AND MATCH (wish_desc) AGAINST ('(+tonte +pelouse; +tonte +de +pelouse*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (77340,77340,77184,94510,77680,94420,77185,94880,94490,94880,94350,77330,77420,77183,77090,77186,94370,94380,93160,94430,77200,94500,77135,77150,77150,94360,94210,94340,94100,77164,93330,93460,77600,77360,94440,94470,77600,77600,77170,77500,77400,94440,94380,94170,77177,94130,93360,77173,77400,94000,94340,77600,94440,94120,93220,94410,77400,77400,77600,94460,94450,93370,77600,94520,94520,93110,77220,91330,93250,77400,94700,77170,93340,93320,77144,77181,77181,93470,77400,91800,94190,77220,77410,77166,93390,93190,91480,94140,94300,91800,93130,77220,77400,94220,77220,77700,94600,94160,91860,77174,91560,93100,77380,77270,77144,77700,94400,93140,93410,77410,91480,94290,93260,93230,93170,91230,93270,77700,94390,94310,93000,77166,77220,77170,94200,94205,94480,77390,94320,77174,77610,77700,77450,77111,94800,91200,94270,91270,93290,77450,77410,93310,93600,77700,77610,77410,77111,93500,77127,93700,93150,91210,77610,94550,77450,77450,77410,93420,77580,94150,91550,77410,77610,91250,94110,77410,94237,94232,94239,94234,94235,94233,94238,94236,94240,94231,94230)

  20. 0.0438

    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.7984*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7984*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.60528- 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='38' AND MATCH (wish_desc) AGAINST ('(+tonte +pelouse; +tonte +de +pelouse*)' IN BOOLEAN MODE) AND wish_visu IN (1,6,10) AND wish_cp IN (77340,77340,77184,94510,77680,94420,77185,94880,94490,94880,94350,77330,77420,77183,77090,77186,94370,94380,93160,94430,77200,94500,77135,77150,77150,94360,94210,94340,94100,77164,93330,93460,77600,77360,94440,94470,77600,77600,77170,77500,77400,94440,94380,94170,77177,94130,93360,77173,77400,94000,94340,77600,94440,94120,93220,94410,77400,77400,77600,94460,94450,93370,77600,94520,94520,93110,77220,91330,93250,77400,94700,77170,93340,93320,77144,77181,77181,93470,77400,91800,94190,77220,77410,77166,93390,93190,91480,94140,94300,91800,93130,77220,77400,94220,77220,77700,94600,94160,91860,77174,91560,93100,77380,77270,77144,77700,94400,93140,93410,77410,91480,94290,93260,93230,93170,91230,93270,77700,94390,94310,93000,77166,77220,77170,94200,94205,94480,77390,94320,77174,77610,77700,77450,77111,94800,91200,94270,91270,93290,77450,77410,93310,93600,77700,77610,77410,77111,93500,77127,93700,93150,91210,77610,94550,77450,77450,77410,93420,77580,94150,91550,77410,77610,91250,94110,77410,94237,94232,94239,94234,94235,94233,94238,94236,94240,94231,94230) 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='77340'

  22. 0.0025

    SELECT ville_cp, ROUND((((acos(sin((48.7984*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7984*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.60528- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.618535678816 AND ville_latitude_deg<48.978264321184 AND ville_longitude_deg>2.3322243489142 AND ville_longitude_deg<2.8783356510858 HAVING distance <= 20 ORDER BY distance ASC

  23. 0.0082

    SELECT ville_cp, ROUND((((acos(sin((48.7984*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7984*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.60528- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.348739197041 AND ville_latitude_deg<49.248060802959 AND ville_longitude_deg>1.922634985784 AND ville_longitude_deg<3.287925014216 HAVING distance <= 50 ORDER BY distance ASC

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

  26. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 74468 AND W.type_id = 1) OR (W.util_id != 74468 AND W.type_id = 2)) AND (`post_util_id` = 74468 OR `dest_util_id` = 74468) 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=74468 AND note_visu IN (1,3,4)

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

  30. 0.0002

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 84196 AND W.type_id = 1) OR (W.util_id != 84196 AND W.type_id = 2)) AND (`post_util_id` = 84196 OR `dest_util_id` = 84196) 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=84196 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 = 90272 AND W.type_id = 1) OR (W.util_id != 90272 AND W.type_id = 2)) AND (`post_util_id` = 90272 OR `dest_util_id` = 90272) 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=90272 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 = 61886 AND W.type_id = 1) OR (W.util_id != 61886 AND W.type_id = 2)) AND (`post_util_id` = 61886 OR `dest_util_id` = 61886) 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=61886 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 = 93950 AND W.type_id = 1) OR (W.util_id != 93950 AND W.type_id = 2)) AND (`post_util_id` = 93950 OR `dest_util_id` = 93950) 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=93950 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 = 117600 AND W.type_id = 1) OR (W.util_id != 117600 AND W.type_id = 2)) AND (`post_util_id` = 117600 OR `dest_util_id` = 117600) 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=117600 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 = 121365 AND W.type_id = 1) OR (W.util_id != 121365 AND W.type_id = 2)) AND (`post_util_id` = 121365 OR `dest_util_id` = 121365) 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=121365 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 = 122297 AND W.type_id = 1) OR (W.util_id != 122297 AND W.type_id = 2)) AND (`post_util_id` = 122297 OR `dest_util_id` = 122297) 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=122297 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 = 123229 AND W.type_id = 1) OR (W.util_id != 123229 AND W.type_id = 2)) AND (`post_util_id` = 123229 OR `dest_util_id` = 123229) 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=123229 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 = 127777 AND W.type_id = 1) OR (W.util_id != 127777 AND W.type_id = 2)) AND (`post_util_id` = 127777 OR `dest_util_id` = 127777) 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=127777 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 = 135801 AND W.type_id = 1) OR (W.util_id != 135801 AND W.type_id = 2)) AND (`post_util_id` = 135801 OR `dest_util_id` = 135801) 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=135801 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 = 135801 AND W.type_id = 1) OR (W.util_id != 135801 AND W.type_id = 2)) AND (`post_util_id` = 135801 OR `dest_util_id` = 135801) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

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

  52. 0.0001

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

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

  54. 0.0001

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

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

  56. 0.0001

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

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

  58. 0.0001

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

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

  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 = 165009 AND W.type_id = 1) OR (W.util_id != 165009 AND W.type_id = 2)) AND (`post_util_id` = 165009 OR `dest_util_id` = 165009) 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=165009 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 = 165583 AND W.type_id = 1) OR (W.util_id != 165583 AND W.type_id = 2)) AND (`post_util_id` = 165583 OR `dest_util_id` = 165583) 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=165583 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 = 166247 AND W.type_id = 1) OR (W.util_id != 166247 AND W.type_id = 2)) AND (`post_util_id` = 166247 OR `dest_util_id` = 166247) 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=166247 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 = 172760 AND W.type_id = 1) OR (W.util_id != 172760 AND W.type_id = 2)) AND (`post_util_id` = 172760 OR `dest_util_id` = 172760) 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=172760 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 = 173515 AND W.type_id = 1) OR (W.util_id != 173515 AND W.type_id = 2)) AND (`post_util_id` = 173515 OR `dest_util_id` = 173515) 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=173515 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 = 176294 AND W.type_id = 1) OR (W.util_id != 176294 AND W.type_id = 2)) AND (`post_util_id` = 176294 OR `dest_util_id` = 176294) 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=176294 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 = 185704 AND W.type_id = 1) OR (W.util_id != 185704 AND W.type_id = 2)) AND (`post_util_id` = 185704 OR `dest_util_id` = 185704) 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=185704 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 = 194126 AND W.type_id = 1) OR (W.util_id != 194126 AND W.type_id = 2)) AND (`post_util_id` = 194126 OR `dest_util_id` = 194126) 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=194126 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 = 211797 AND W.type_id = 1) OR (W.util_id != 211797 AND W.type_id = 2)) AND (`post_util_id` = 211797 OR `dest_util_id` = 211797) 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=211797 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 = 222511 AND W.type_id = 1) OR (W.util_id != 222511 AND W.type_id = 2)) AND (`post_util_id` = 222511 OR `dest_util_id` = 222511) 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=222511 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 = 73328 AND W.type_id = 1) OR (W.util_id != 73328 AND W.type_id = 2)) AND (`post_util_id` = 73328 OR `dest_util_id` = 73328) 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=73328 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 = 226970 AND W.type_id = 1) OR (W.util_id != 226970 AND W.type_id = 2)) AND (`post_util_id` = 226970 OR `dest_util_id` = 226970) 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=226970 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 = 131971 AND W.type_id = 1) OR (W.util_id != 131971 AND W.type_id = 2)) AND (`post_util_id` = 131971 OR `dest_util_id` = 131971) 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=131971 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 = 236109 AND W.type_id = 1) OR (W.util_id != 236109 AND W.type_id = 2)) AND (`post_util_id` = 236109 OR `dest_util_id` = 236109) 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=236109 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 = 280469 AND W.type_id = 1) OR (W.util_id != 280469 AND W.type_id = 2)) AND (`post_util_id` = 280469 OR `dest_util_id` = 280469) 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=280469 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 = 81680 AND W.type_id = 1) OR (W.util_id != 81680 AND W.type_id = 2)) AND (`post_util_id` = 81680 OR `dest_util_id` = 81680) 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=81680 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 = 249799 AND W.type_id = 1) OR (W.util_id != 249799 AND W.type_id = 2)) AND (`post_util_id` = 249799 OR `dest_util_id` = 249799) 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=249799 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 = 288219 AND W.type_id = 1) OR (W.util_id != 288219 AND W.type_id = 2)) AND (`post_util_id` = 288219 OR `dest_util_id` = 288219) 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=288219 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 = 290832 AND W.type_id = 1) OR (W.util_id != 290832 AND W.type_id = 2)) AND (`post_util_id` = 290832 OR `dest_util_id` = 290832) 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=290832 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 = 252345 AND W.type_id = 1) OR (W.util_id != 252345 AND W.type_id = 2)) AND (`post_util_id` = 252345 OR `dest_util_id` = 252345) 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=252345 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 = 306365 AND W.type_id = 1) OR (W.util_id != 306365 AND W.type_id = 2)) AND (`post_util_id` = 306365 OR `dest_util_id` = 306365) 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=306365 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 = 324098 AND W.type_id = 1) OR (W.util_id != 324098 AND W.type_id = 2)) AND (`post_util_id` = 324098 OR `dest_util_id` = 324098) 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=324098 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 = 324098 AND W.type_id = 1) OR (W.util_id != 324098 AND W.type_id = 2)) AND (`post_util_id` = 324098 OR `dest_util_id` = 324098) 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 = 324098 AND W.type_id = 1) OR (W.util_id != 324098 AND W.type_id = 2)) AND (`post_util_id` = 324098 OR `dest_util_id` = 324098) 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 = 328437 AND W.type_id = 1) OR (W.util_id != 328437 AND W.type_id = 2)) AND (`post_util_id` = 328437 OR `dest_util_id` = 328437) 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=328437 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 = 328437 AND W.type_id = 1) OR (W.util_id != 328437 AND W.type_id = 2)) AND (`post_util_id` = 328437 OR `dest_util_id` = 328437) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  109. 0.0001

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

  110. 0.0001

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

  111. 0.0001

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

  112. 0.0001

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

  113. 0.0001

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

  114. 0.0001

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

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

  116. 0.0001

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

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

  118. 0.0001

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

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

  120. 0.0001

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

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

  122. 0.0001

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

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

  124. 0.0001

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

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

  126. 0.0001

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

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

  128. 0.0001

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

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

  130. 0.0001

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

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

  132. 0.0001

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

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

  134. 0.0001

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

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

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

  137. 0.0001

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

  138. 0.0009

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

  139. 0

    SELECT count(*) as nbwish FROM wish

  140. 0.0649

    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

140 requetes sql en 0.1938

Taille variable Globale : 77.71 KB