Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Création nouvelle pelouse (2h)

Annonces similaires

Tout voir
Service amenagement jardin
Service amenagement jardin

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE UN JARDINIER
Profil du voisin
Capucine C

Cantaing-sur-Escaut 59267

100€

Proposer mes services
Service amenagement jardin
Service amenagement jardin

Demande il y a + de 30j

Il y a + de 30j

REDESSINER TERRAIN SUR DEVANT DE MAISON
Profil du voisin
Guy B

Vimy 62580

150€/j

Proposer mes services
Service amenagement jardin
Service amenagement jardin

Demande il y a + de 30j

Il y a + de 30j

REFAIRE UNE PELOUSE USAGéE DE 100M2
Profil du voisin
Jacky S

Vimy 62580

10€/h

Proposer mes services
Service amenagement jardin
Service amenagement jardin

Demande il y a + de 30j

Il y a + de 30j

POSE ENTERRéE FIL ROBOT TONDEUSE
Profil du voisin
Fabienne L

Farbus 62580

-- €

Proposer mes services
Service amenagement jardin
Service amenagement jardin

Demande il y a + de 30j

Il y a + de 30j

PERSONNE POUR RETOURNER LA TERRE
Profil du voisin
Samantha D

Pont-à-Vendin 62880

-- €

Proposer mes services

Demande un service d'amenagement de jardin entre voisins ou proposer mes services d'amenagement de jardin.

Poster une annonce

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wiiz-annonce.php

  1. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

  2. 0.0001

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom FROM wish w LEFT JOIN util_info ui ON w.util_id=ui.util_id WHERE wish_id='556278'

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='amenagement-jardin' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='999'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'amenagement-jardin' LIMIT 1

  5. 0.0001

    SELECT c.cate_id, c.cate_title, cate_title_aff, cate_title_slug, c.fami_id, f.fami_title, f.fami_url FROM category c, family f WHERE c.fami_id=f.fami_id AND c.fami_id='3' AND c.cate_id='38'

  6. 0

    SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='59'

  7. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='412357' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  8. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 412357

  9. 0.0001

    SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`

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

  11. 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 (50) ORDER BY ssrubr_order ASC

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

  13. 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 (45) ORDER BY ssrubr_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 (231) ORDER BY ssrubr_order ASC

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

  16. 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 (42) ORDER BY ssrubr_order ASC

  17. 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 (37) ORDER BY ssrubr_order ASC

  18. 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 (43) ORDER BY ssrubr_order ASC

  19. 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 (39) ORDER BY ssrubr_order ASC

  20. 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 (229) ORDER BY ssrubr_order ASC

  21. 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 (230) ORDER BY ssrubr_order ASC

  22. 0.0001

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 556278

  23. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=999 LIMIT 1

  24. 0.0001

    SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='556278'

  25. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='556278' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')

  26. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 412357 AND util_tel != ''

  27. 0

    SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 412357 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''

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

  29. 0.0001

    SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='412357' AND note_visu IN (1,3,4)

  30. 0.0001

    SELECT `empreinte_carbone`,s.prix_leroymerlin, s.prix_loxam, s.prix_kiloutou FROM `ssrubr` as s INNER JOIN wish as w ON w.ssrubr_id = s.ssrubr_id WHERE w.wish_id = '556278'

  31. 0.0001

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish w INNER JOIN util_info ui ON w.util_id = ui.util_id WHERE wish_visu IN (1,6,10) AND w.util_id='412357' AND wish_id<>'556278' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  32. 0.0001

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

  33. 0.0042

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.3167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.3167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.56667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.867039197041 AND ville_latitude_deg<50.766360802959 AND ville_longitude_deg>2.8624652035945 AND ville_longitude_deg<4.2708747964055 HAVING distance <= 50 ORDER BY distance ASC

  34. 0.0022

    SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_visu IN (1,6,10) AND wish_cp IN (59990,59990,59269,59990,59990,59300,59144,59300,59269,59770,59300,59990,59530,59269,59880,59530,59125,59144,59233,59213,59174,59990,59144,59213,59530,59410,59144,59860,59264,59213,59213,59224,59494,59990,59227,59243,59121,59144,59224,59192,59530,59195,59144,59213,59530,59213,59121,59590,59494,59220,59530,59530,59195,59920,59530,59530,59570,59220,59135,59278,59730,59970,59530,59144,59255,59144,59530,59227,59227,59154,59294,59530,59570,59198,59570,59970,59218,59218,59135,59570,59220,59282,59730,59218,59282,59570,59570,59163,59970,59163,59218,59296,59293,59171,59570,59156,59188,59124,59570,59730,59530,59163,59730,59530,59230,59188,59111,59570,59172,59730,59530,59570,59199,59178,59188,59199,59171,59178,59730,59288,59570,59111,59129,59292,59222,59171,59111,59158,59230,59222,59215,59570,59172,59550,59550,59222,59179,59214,59230,59271,59870,59870,59141,59178,59570,59277,59226,59360,59490,59111,59178,59230,59295,59138,59295,59252,59570,59870,59141,59138,59158,59145,59252,59141,59230,59145,59360,59158,59158,59580,59550,59540,59870,59580,59138,59870,59217,59217,59252,59620,59161,59540,59490,59540,59217,59360,59165,59540,59138,59400,59226,59620,59161,59360,59360,59550,59157,59330,59330,59360,59247,59310,59690,59157,59550,59750,59234,59161,59980,59176,59400,59870,59310,59554,59247,59550,59146,59870,59161,59620,59554,59176,59217,59400,59234,59225,59310,59265,59330,59980,59550,59620,59330,59247,59980,59360,59268,59600,59234,59310,59400,59182,59191,59400,59554,59360,59554,59620,59360,59265,59169,59600,59225,59191,59287,59182,59600,59440,59440,59310,59720,59265,59400,59980,59980,59330,59330,59400,59167,59265,59600,59400,59550,59191,59169,59151,02110,59360,59360,59440,02110,59287,59148,59310,59127,59244,59310,62860,59310,59330,59265,59244,59600,59440,59267,59194,59554,59440,59151,59131,59244,59238,59554,02450,59680,59360,59310,59600,59169,59600,59440,59127,59187,59281,59600,59258,59137,59450,59194,59119,62860,59127,59440,59400,59258,59169,02450,62860,59680,59151,02110,59241,02630,59830,02110,02110,62860,59680,59159,59680,59267,59550,02110,59440,02170,02450,59440,59440,59600,62860,59680,59151,59168,59245,59127,59242,59127,02450,59235,59310,59680,59830,59830,59440,59258,59159,59440,59216,59169,59151,59440,59740,59552,59830,59500,59242,59286,59216,59216,62860,59740,02110,62860,62860,59283,62112,59830,62112,62490,59164,02170,59142,59552,59400,02630,62860,59780,59242,59830,59283,59553,59553,62860,59680,02510,02110,59246,62147,62790,59128,59740,62860,59710,59680,62490,59460,02110,59440,59740,62490,02170,02420,59266,59259,59950,62860,59740,62860,59780,59710,02630,59267,59710,59149,02510,62117,59177,02510,02170,59553,59219,59740,59219,59266,59273,62156,02450,02450,59551,59177,62141,02110,59159,59740,62860,59152,62147,59830,59273,02260,59231,59740,62860,62490,62970,59162,62156,59152,59266,59152,02120,59219,62147,62182,59262,59239,02110,02110,02510,02170,62490,02420,59177,59152,02420,62490,62182,62156,59740,02420,59710,02110,59239,59231,02450,59261,59149,02230,59740,59780,02120,02120,62118,02110,02110,02120,59551,62950,59740,62147,02260,62820,62156,59297,02260,59740,02620,62119,02110,59810,62860,59231,62118,02420,59740,62147,59390,02110,62860,62490,62147,62156,59149,59510,62156,62590,02420,59133,59610,02420,59175,62490,62124,62182,02260,59510,59212,59390,62156,59790,62182,59113,59175,02110,62147,59260,59390,59155,62118,02420,62110,62580,62118,02120,59132,02120,02120,62220,59115,02120,02420,59390,02120,62320,62320,02110,02110,62640,80740,02420,80740,59133,62124,59132,02120,59139,62124,62128,02420,02420,62710,02120,02260,02420,02260,62128,62159,62124,62118,62118,02260,02110,59147,02120,02120,02120,02120,62320,62740,80122,59112,02420,62124,02120,62124,80360,02100,62128,62580,62128,62118,62420,59370,62580,59147,02260,62580,59263,59290,59170,02420,02110,59139,80240,62124,62124,62880,62124,62320,02260,02420,62128,59132,02110,62128,80240,59132,02100,02120,02100,80240,59610,59150,62440,02120,02260,59147,80112,02420,59251,59777,59350,59160,59800,59000,62580) AND fami_id='3' AND cate_id='38' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='999' AND wish_id<>'556278' AND wish_url='' ORDER BY rand() LIMIT 0,10

  35. 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='999' LIMIT 0,1

  36. 0.0001

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

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

  38. 0.0001

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

  39. 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='999' LIMIT 0,1

  40. 0.0001

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

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

  42. 0.0001

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

  43. 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='999' LIMIT 0,1

  44. 0.0001

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

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

  46. 0.0001

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

  47. 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='999' LIMIT 0,1

  48. 0.0001

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

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

  50. 0.0001

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

  51. 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='999' LIMIT 0,1

  52. 0.0001

    SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=242219 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 = 242219 AND W.type_id = 1) OR (W.util_id != 242219 AND W.type_id = 2)) AND (`post_util_id` = 242219 OR `dest_util_id` = 242219) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  54. 0.0001

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

  55. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 999

  56. 0.0008

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

  57. 0

    SELECT count(*) as nbwish FROM wish

  58. 0.0454

    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

58 requetes sql en 0.0579

Taille variable Globale : 55.12 KB