Retour
Fermer

›

Lancez votre recherche pour voir les annonces.

Recherche un élagueur

Annonces similaires

Tout voir
Service elagage
Service : elagage

Demande il y a + de 30j

Il y a + de 30j • 62223

Tronconnage + decoupe pin en morceaux (2
Profil du voisin
Christian B

Anzin-Saint-Aubin 62223

60€

Proposer mes services

Demande un service d'elagage entre voisins ou proposer mes services d'elagage.

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='255408'

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='elagage' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='526'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'elagage' LIMIT 1

  5. 0.0001

    SELECT c.cate_id, 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='80'

  7. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='31430' 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` = 31430

  9. 0

    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.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 (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.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 (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 = 255408

  23. 0.0001

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

  24. 0.0001

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

  25. 0

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

  26. 0

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

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

  28. 0.0001

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

  29. 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 = '255408'

  30. 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='31430' AND wish_id<>'255408' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  31. 0.0001

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

  32. 0.0056

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.1833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.1833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.08333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.733639197041 AND ville_latitude_deg<50.632960802959 AND ville_longitude_deg>1.3810938276568 AND ville_longitude_deg<2.7855661723432 HAVING distance <= 50 ORDER BY distance ASC

  33. 0.0019

    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 (80370,80370,80370,80370,80370,80370,80150,80370,80370,80150,80620,80370,80150,62390,80370,80370,80370,62390,80150,80150,80370,62390,62390,80620,80150,80620,80370,80150,80135,80370,80370,80370,80370,80135,62390,80150,80135,80620,62390,80150,80370,80620,62390,62390,80150,80600,62390,80620,80135,80135,62390,80620,62390,80600,62140,62390,80690,80690,80150,80150,80150,80600,80600,80150,80150,80600,62390,80135,80690,62270,80750,80620,62390,62390,80600,80620,80690,80600,62140,62270,80135,80690,80150,62270,80600,80132,80150,80132,62390,80620,80670,80750,80780,62140,80132,62270,62270,80132,80600,62140,62140,80132,80850,62770,80150,62140,62270,62270,80132,80670,62270,80670,80600,80690,62140,80690,80610,80830,62270,80670,80132,80600,62770,62770,80830,80150,80670,62140,62140,80150,80150,80510,80600,62270,80420,80420,62770,80610,62140,62270,80580,80150,80132,80890,62140,62770,80510,62270,80580,80132,80600,62270,80150,80510,80670,80510,80150,80132,80630,80100,80580,80132,62270,80650,62770,80670,62810,62140,62140,80580,62140,62770,62144,62140,80600,62270,62270,62270,80580,80600,62130,80600,62270,80600,62870,80260,80150,62130,62130,80490,80132,80132,62770,80150,62270,80860,80310,80310,62770,62140,80260,80580,62130,62140,80970,62130,62130,62770,62140,62140,62770,62130,62270,62810,62760,80120,80490,80260,62130,80270,80132,80600,80310,62760,80132,62130,80132,62130,62770,62870,80310,62130,62140,80260,80310,80120,62810,62270,62870,62760,62270,62760,80132,62810,80120,62140,62770,80600,80310,62870,80120,62990,62810,80120,62130,80270,62130,80260,62130,62770,62760,80310,62770,80860,62130,62130,62130,80860,80310,80310,62770,80490,80490,80560,62770,62140,80870,80230,62760,62130,80260,80270,62270,80132,62760,62810,80600,62760,62130,80270,62990,62810,80132,62130,62870,62810,62760,80490,80310,62770,80120,62127,80260,80560,80870,62127,62130,62810,80600,62140,62130,80260,62810,80120,62870,62130,80490,80260,62134,62158,62870,62130,80470,80230,62990,62310,62130,80870,80140,80490,62134,80470,62810,62810,80132,80560,62130,62870,80260,62130,80310,62158,62760,62760,80310,80270,62140,80270,62760,80270,62127,80210,80260,80120,62810,80120,80210,62990,80270,80120,80260,80140,80560,62130,80260,80140,62134,80470,62134,80140,80260,80560,80140,62127,62180,62127,80120,80120,80560,62134,62990,80270,62990,80210,80560,80140,80140,80260,62310,80310,80730,80470,80730,80540,62310,62810,80140,62310,80560,62990,62310,62134,80270,62127,62158,80230,62760,62990,62130,80260,80140,80210,62760,80470,80540,62990,62310,62810,80260,80270,80270,62127,62760,62130,80140,62990,80140,80640,62180,62130,62180,62127,80210,62127,62127,62134,80270,80540,62310,62134,62990,80550,62158,62810,80140,62310,80230,62310,62170,80560,80210,80540,80540,62130,62134,80260,62310,62310,80820,80560,62810,62127,80136,80140,62810,80560,62134,62990,62310,80140,62170,62550,80260,80260,62990,62310,80140,62760,80210,62170,62170,62550,80560,62127,62111,80730,80260,62158,62127,80140,62134,80560,80210,80560,80560,80090,80140,80080,80000,80560,62810,80540,80260,80540,80140,62690,80120,62310,80560,80540,80540,80640,80480,80260,62158,62810,62810,62158,80230,80540,80140,62170,80140,62990,62130,62170,62180,80260,80300,62170,80540,80140,62123,80560,62111,80140,80140,62134,80140,80115,62170,62550,80640,62111,80210,80560,80390,62690,80300,80540,62690,80540,62134,80480,80480,62170,80210,62170,62310,62810,80120,80140,80140,80220,80560,80560,80540,62134,62650,80960,80140,80540,62310,80140,62690,62550,80560,62180,62690,80140,62111,80230,80220,62460,62170,80140,62123,62127,80115,80800,80300,62550,80450,62150,62690,80140,62650,80800,62170,62170,80230,62170,80140,80140,80800,62134,62310,62123,80710,80560,80390,62123,62127,62180,62310,62123,62111,80480,62123,80480,62550,80480,80140,62123,62310,62550,62111,80130,80560,62170,80450,80300,80640,62111,62600,62690,62690,80330,80330,80220,62650,80300,62123,62123,80220,62550,80140,62180,80130,80430,62650,62960,80480,80790,62690,62180,62150,62180,80430,80140,62960,80640,62123,62123,80230,62111,80710,62170,62550,62170,62310,62310,80800,80440,80430,80300,80290,62460,80300,62690,80430,62170,62170,80290,62310,80430,62123,80290,80220,80113,80520,62123,62650,62650,80570,62111,80800,62650,62650,80430,80140,80440,80160,80530,80300,62690,80570,62150,76340,80800,80140,80300,62150,80126,62550,62170,62690,80460,62960,80300,62170,62170,80680,80290,80140,80800,80520,80800,76340,80220,62144,80800,62123,62170,80410,62150,62170,62550,62560,62650,80440,62173,62560,62600,62123,62310,80300,80530,80530,80300,62470,80300,62173,62550,80113,62960,62170,62460,62560,62690,62550,76340,80800,62550,80160,80160,62650,80160,62161,62150,62260,62550,62470,62150,80140,76340,62116,62960,62690,62260,62150,80680,80430,80220,62690,76340,80300,80520,80160,80940,80680,62116,62144,62170,80430,62155,80770,62560,62260,62116,62650,80590,62161,80800,80800,62170,80290,62650,80220,80300,80160,62650,62560,62690,62260,62150,80590,80680,62960,62960,80800,76340,62650,80290,76260,62116,62173,76340,80300,62650,80380,80430,62170,62190,80290,80300,76117,80440,80590,80290,62630,62960,80160,80300,80300,80460,76340,62217,62630,62650,62144,80430,62620,62161,62161,62175,62116,62560,62560,80590,80300,62000,80800,62116,80300,62170,62173,80430,80880,62145,80290,80680,62700,62540,80380,62560,80380,76390,80300,62780,80300,62530,76340,62190,62190,62120,80460,80810,80300,80800,80290,62540,62145,62940,62620,62151,62175,76260,62650,62144,80440,80110,62530,80250,80590,80800,62121,76260,62620,80160,80300,62630,80160,80160,80160,80290,80300,80160,62560,62560,62630,80300,80290,80590,62121,62175,80160,62650,62190,62120,62650,76260,80590,62157,80250,62129,62172,62122,76340,76340,62145,80110,62144,80300,80590,80300,62630,62190,80290,80290,80250,80590,76340,80110,62217,62217,76260,80300,80160,80290,80590,62223,76340,80110,76260,62120,62175,62121,80440,80300,62190,62530) 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='526' AND wish_id<>'255408' AND wish_url='' ORDER BY rand() LIMIT 0,10

  34. 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='526' LIMIT 0,1

  35. 0.0001

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

  37. 0.0001

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

  38. 0.0001

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 526

  39. 0.0011

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

  40. 0

    SELECT count(*) as nbwish FROM wish

  41. 0.0449

    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

41 requetes sql en 0.0569

Taille variable Globale : 53.29 KB