Retour
Fermer

›

Lancez votre recherche pour voir les annonces.

Rénovation pelouse

Autres annonces du voisin

Tout voir
Service peintre
Service : peintre

Demande il y a + de 30j

Il y a + de 30j • 25870

Repeindre portail métal (4h)
Profil du voisin
Guillaume

Venise 25870

100€

Proposer mes services
Location minibus
Location : minibus

Demande il y a + de 30j

Il y a + de 30j • 25870

Recherche véhicule 7/9 places (15 jours
Profil du voisin
Guillaume

Châtillon-le-Duc 25870

600€

Louer mon minibus

Demande un service un minibus entre voisins ou proposer mes services un minibus.

Poster une annonce

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wiiz-annonce.php
  1. 0

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

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='entretien-espace-vert' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='532'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'entretien-espace-vert' 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='25'

  7. 0.0001

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

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

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

  23. 0.0001

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

  24. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='405214' 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` = 53314 AND util_tel != ''

  26. 0

    SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 53314 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 = 53314 AND W.type_id = 1) OR (W.util_id != 53314 AND W.type_id = 2)) AND (`post_util_id` = 53314 OR `dest_util_id` = 53314) 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='53314' 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 = '405214'

  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='53314' AND wish_id<>'405214' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  31. 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='587' LIMIT 0,1

  32. 0.0001

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

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

  34. 0.0001

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

  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='863' LIMIT 0,1

  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 = 53314 AND W.type_id = 1) OR (W.util_id != 53314 AND W.type_id = 2)) AND (`post_util_id` = 53314 OR `dest_util_id` = 53314) 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 = 53314

  38. 0.0001

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

  39. 0.005

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((47.3333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((47.3333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((6.05- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>46.883639197041 AND ville_latitude_deg<47.782960802959 AND ville_longitude_deg>5.38651482334 AND ville_longitude_deg<6.71348517666 HAVING distance <= 50 ORDER BY distance ASC

  40. 0.0033

    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 (25870,25870,70190,70190,25870,25870,70190,25870,25870,25640,25870,25870,70190,70190,25870,25220,25870,25870,25640,25870,25640,70190,70190,70190,25870,70190,70190,25870,70190,25220,25220,70190,25220,25480,25480,25220,25870,25220,25870,25640,25640,70150,25000,70190,25220,25220,25480,70190,70190,70190,25660,70700,25640,70190,70700,25660,70150,25640,25170,25660,70700,25170,70150,25640,25170,70190,25960,25660,25640,25170,70190,70700,25770,25115,25660,70190,70190,25360,25640,25170,25640,70190,25640,25170,70190,25640,25640,25640,25170,70150,25770,25820,25170,25360,25170,25640,70190,25660,25640,25640,25720,25720,70190,25620,70190,70230,25720,25360,70190,25640,70150,70230,25640,25640,25170,25770,25640,25360,25170,70190,70190,70230,25320,70230,25620,70190,25640,25110,25720,25110,25640,70150,25640,70700,70700,25170,25720,25620,25640,25170,70150,70700,70700,70190,25320,70700,70700,25320,70190,70700,70230,25170,25360,25640,25110,25320,70130,25110,25110,70700,25360,25170,70230,25360,25170,25680,70700,25410,25680,25170,70190,70700,25320,25620,25110,70190,25410,25660,70700,70150,25620,25620,25110,70230,25620,25410,70190,25110,25170,25410,70230,25410,70130,25320,25680,25360,70230,70150,25680,25360,25320,25660,70000,25320,70000,25580,25360,70230,70000,25680,70700,25170,70230,25440,25620,25680,25110,70700,70150,70230,25320,70130,25440,25360,25110,70700,25170,70700,25680,25410,25620,25110,70150,25110,25620,70700,25410,25290,25360,25620,70230,70700,25410,70130,70000,25680,25360,70230,70130,70000,70700,25410,70150,70230,25680,70150,25170,70130,25680,25410,70700,70130,25320,25110,70100,25170,25110,70150,25360,25290,25290,70000,25680,25290,25580,70130,25680,25530,70150,25110,39700,70100,25580,25170,25530,25320,25530,70150,70130,25290,70000,39350,70700,39700,25440,25410,25680,70700,70230,25440,25110,70140,25110,70130,25320,70000,25330,25440,70000,25110,70100,39350,70000,70000,25680,25110,70100,25680,70130,25290,39350,70000,25440,25580,25580,25440,25530,25440,25440,25110,25110,70100,25110,25410,25110,70140,25680,70000,25440,39350,25530,39350,25680,39700,70100,25580,70100,25530,39350,25360,70230,39700,70000,25330,70000,70000,70140,70000,25111,25580,25800,70000,25360,25440,39700,25340,25440,70130,39350,25530,70000,25340,39350,70100,25340,25680,25530,25440,25440,39350,70140,39700,70130,70000,25330,70140,25530,70000,70100,25430,70140,25580,70130,70360,25330,25440,25440,25330,25340,70100,25580,70360,25840,25580,25440,25340,70360,70000,25530,25510,70000,25440,25840,70130,25680,25530,70140,70110,25440,25330,25340,25530,70130,70110,39700,25800,25340,70140,70140,25530,25340,70130,70130,25800,70000,70000,25530,25680,25680,25440,70100,25340,39700,70000,70360,25330,25440,70130,70000,25510,39700,25580,25440,25330,70130,70120,70000,25440,25440,70100,25330,25430,39290,70100,25510,39350,70360,70130,25580,25580,25690,39700,70110,70000,70360,25440,39700,70140,25340,70100,25510,70110,39700,25580,70140,25930,70120,70120,70170,25430,70140,25580,70360,25340,39700,70360,39700,25330,70360,25340,70100,39700,70180,70000,70000,70180,25340,25330,25440,25330,25440,25250,25440,70360,70100,25340,70180,70140,70100,25580,25340,25690,70120,70000,70180,70000,70000,70180,70140,70110,70120,70000,39700,70140,70000,25330,25440,25330,25330,70170,70170,70100,25920,25440,39700,70110,70000,25330,70110,70110,70100,39700,70110,39700,70110,70360,70100,25430,25430,39600,70000,70000,25690,70180,70100,70100,70100,39290,39290,25440,70100,25340,70110,25690,39700,25250,25250,70110,25510,70100,70120,70120,70170,25270,25510,39700,39290,25520,25330,70000,70120,70110,25340,70240,70180,70110,39110,25520,70120,70110,39700,25390,70110,25610,25520,70180,70110,25510,70000,70100,39600,70120,25270,25430,70240,70180,25520,25430,25250,70110,70110,39290,39110,70110,25250,25270,25250,39700,25270,70140,70240,39600,70200,70170,39290,39290,39600,25520,25390,70110,25430,25430,25520,70100,25430,70180,39700,70110,70110,70360,39700,70180,21270,70180,70110,70000,25690,39110,70120,70240,25250,39290,25250,70240,25390,70110,39380,70600,70180,70170,70240,25270,70170,39380,25390,25430,70120,25250,25250,39290,39700,25270,39110,25270,25380,70170,70110,70240,39110,70100,70110,70240,25250,25520,39600,39290,70200,39380,39700,39290,70240,70240,70120,25520,25390,70240,25250,39110,70110,39600,70240,25520,39330,70120,39110,70170,25270,70170,25250,25250,70240,25250,70100,70100,70170,70600,70600,70240,70600,39700,70240,39380,70600,39110,39330,70240,70100,39290,39290,70120,21270,39290,25430,21270,70200,70600,70160,70110,25270,39110,25650,39290,25250,25380,39380,25650,39110,25520,70400,70600,25250,70100,21270,39380,25250,25380,25390,25210,39290,70160,25390,70120,25250,39110,21270,39110,25390,70200,25260,39380,70160,21270,25270,70160,25250,25190,21270,25190,70120,70240,21130,25380,39600,70400,70400,70160,25380,39100,25380,25250,25260,39600,25150,70400,25380,70240,39100,39110,70100,70240,70120,39290,39110,39110,25380,25190,25250,70200,70160,25210,70400,70120,21270,21270,39100,70200,25500,25150,70200,25270,39100,25210,25210,21310,70160,39110,39380,70600,39110,25650,25380,70120,70600,25300,39600,25210,39100,70500,25190,39600,70500,25190,25300,21270,52500,70200,39110,70160,21310,21310,25650,39380,70200,70200,70100,25650,25650,39380,25380,25300,39290,25150,39380,25380,25260,25300,52500,25260) 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='532' AND wish_id<>'405214' AND wish_url='' ORDER BY rand() LIMIT 0,10

  41. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 532

  42. 0.001

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

  43. 0

    SELECT count(*) as nbwish FROM wish

  44. 0.0518

    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

44 requetes sql en 0.0648

Taille variable Globale : 53.27 KB