Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Service : Bricoleur dispo

Autres annonces du voisin

Tout voir
Location karcher
Location karcher
KARCHER ESSENCE
Profil du voisin
Sébastien G

Montceau-les-Mines 71300

30€/j

Service agencement
Service agencement
MONTAGE MEUBLE, CUISINE
Profil du voisin
Sébastien G

Montceau-les-Mines 71300

20€/h

Location leve plaques
Location leve plaques
LèVE PLAQUE PRO
Profil du voisin
Sébastien G

Montceau-les-Mines 71300

20€/j

Service coach sportif
Service coach sportif
DIPLOMé ET EXPéRIMENTé
Profil du voisin
Sébastien G

Montceau-les-Mines 71300

20€/h

Service tonte de pelouse
Service tonte de pelouse
SERVICE : TONTE DE PELOUSE
Profil du voisin
Sébastien G

Montceau-les-Mines 71300

20€/h

Service debroussaillage
Service debroussaillage
SERVICE : DéBROUSSAILLAGE
Profil du voisin
Sébastien G

Montceau-les-Mines 71300

20€/h

Location scie sauteuse
Location scie sauteuse
SCIE SAUTEUSE MAKITA PRO
Profil du voisin
Sébastien G

Montceau-les-Mines 71300

10€/j

Location betonniere
Location betonniere
BéTONNIèRE éLECTRIQUE
Profil du voisin
Sébastien G

Saint-Berain-sous-Sanvignes 71300

15€/j

Location niveau laser
Location niveau laser
LOCATION NIVEAU LASER BOSCH GLL3 80
Profil du voisin
Sébastien G

Montceau-les-Mines 71300

20€/j

Location scie sabre
Location scie sabre
LOCATION SCIE SABRE PR
Profil du voisin
Sébastien G

Montceau-les-Mines 71300

15€/j

Location scie circulaire
Location scie circulaire
SCIE CIRCULAIRE PRO MAKITA
Profil du voisin
Sébastien G

Montceau-les-Mines 71300

15€/j

Location burineur
Location burineur
LOCATION BURINEUR HILTI
Profil du voisin
Sébastien G

Montceau-les-Mines 71300

15€/j

Location meuleuse
Location meuleuse
MEULEUSE PRO MAKITA ET HILTI
Profil du voisin
Sébastien G

Montceau-les-Mines 71300

15€/j

Annonces similaires

Tout voir
Service multi services
Service multi services
DIPLôME MéCANICIEN BATEAU
Profil du voisin
Nelson P

Simandre 71290

20€/h

Service multi services
Service multi services
MULTI SERVICE
Profil du voisin
Olivier B

Saint-Loup-de-Varennes 71240

25€/h

Service multi services
Service multi services
SERVICE : MULTI SERVICE (4H)
Profil du voisin
Olivier B

Saint-Loup-de-Varennes 71240

120€

Service multi services
Service multi services
SERVICE : MULTI SERVICE
Profil du voisin
Nathan Z

Perrecy-les-Forges 71420

-- €

Service multi services
Service multi services
CARROSSERIE - SELLERIE - VOITURE
Profil du voisin
Robert F

Charolles 71120

25€/h

Service multi services
Service multi services
SERVICE : TOUT TRAVAUX
Profil du voisin
Louka D

Chalon-sur-Saone 71100

20€/h

Service multi services
Service multi services
BESOIN D'AIDE POUR DIVERS CHOSES
Profil du voisin
Guillaume P

Pont-de-Vaux 01190

-- €

Service multi services
Service multi services
LOCATION TAILLE HAIES
Profil du voisin
Catherine L

Marizy 71220

30€/j

Service multi services
Service multi services
MULTI-SERVICES
Profil du voisin
Sylvain N

Saint-Marcel 71380

20€/h

Service multi services
Service multi services
SERVICE : BRICOLAGE
Profil du voisin
Nassim B

Chalon-sur-Saône 71100

180€

Demande un service de bricolage entre voisins ou proposer mes services de bricolage.

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

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='multi-services' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='595'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'multi-services' 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='50'

  6. 0.0001

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

  7. 0.0001

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

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

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

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

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

  21. 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 (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 = 262878

  23. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=595 LIMIT 1

  24. 0.0001

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

  25. 0.0001

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

  26. 0.0001

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

  27. 0.0001

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

  31. 0.0002

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

  32. 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='684' LIMIT 0,1

  33. 0.0001

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

  35. 0.0002

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

  36. 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='607' LIMIT 0,1

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

  38. 0.0002

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

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

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

  41. 0.0002

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

  42. 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='1025' LIMIT 0,1

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

  44. 0.0002

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

  45. 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='524' LIMIT 0,1

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

  47. 0.0002

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

  48. 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='529' LIMIT 0,1

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

  50. 0.0002

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

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

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

  53. 0.0002

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

  54. 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='73' LIMIT 0,1

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

  56. 0.0002

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

  57. 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='53' LIMIT 0,1

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

  59. 0.0001

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

  60. 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='25' LIMIT 0,1

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

  62. 0.0001

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

  63. 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='33' LIMIT 0,1

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

  65. 0.0001

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

  66. 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='74' LIMIT 0,1

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

  68. 0.0001

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

  69. 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='54' LIMIT 0,1

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

  71. 0.0001

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

  72. 0.0001

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

  73. 0.0034

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((46.6667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((46.6667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((4.36667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>46.217039197041 AND ville_latitude_deg<47.116360802959 AND ville_longitude_deg>3.7114114562425 AND ville_longitude_deg<5.0219285437575 HAVING distance <= 50 ORDER BY distance ASC

  74. 0.009

    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 (71300,71230,71450,71410,71230,71300,71690,71230,71690,71420,71710,71210,71690,71710,71420,71210,71690,71220,71210,71710,71460,71220,71210,71420,71420,71460,71460,71420,71220,71220,71390,71220,71460,71460,71200,71210,71460,71390,71320,71160,71210,71460,71670,71430,71460,71430,71460,71190,71460,71320,71460,71460,71190,71460,71390,71710,71220,71420,71710,71220,71190,71460,71200,71460,71460,71220,71220,71420,71670,71390,71250,71390,71670,71190,71320,71460,71250,71130,71220,71120,71390,71460,71460,71510,71430,71390,71460,71460,71220,71510,71250,71190,71120,71320,71940,71320,71390,71940,71320,71460,71510,71190,71390,71130,71430,71390,71430,71190,71120,71130,71120,71940,71510,71250,71460,71390,71490,71220,71190,71460,71130,71390,71460,71390,71390,71460,71510,71400,71190,71250,71190,71460,71220,71130,71120,71250,71390,71390,71640,71490,71220,71460,71490,71600,71320,71640,71250,71120,71490,71250,71250,71250,71600,71510,71190,71250,71390,71460,71490,71940,71640,71250,71460,71640,71510,71190,71460,71220,71220,71490,71120,71220,71120,71130,71600,71640,71160,71120,71250,71990,71460,71390,71600,71130,71240,71510,71760,71490,71640,71640,71250,71120,71510,71400,71360,71520,71240,58170,71400,71460,71510,71490,71250,71640,71250,71460,71510,71640,71400,71520,58170,71510,71600,71250,71360,71760,71100,71240,71600,71250,71490,71150,71250,71640,71520,71240,71130,71700,71990,71150,71360,71800,71250,71360,71150,58170,71610,71150,71150,71400,71800,71880,71760,71160,71250,71610,71240,21340,71250,71610,58170,71600,71250,71700,71520,71150,71520,71150,71700,21590,71250,71150,58370,71610,71600,71150,71520,71520,71100,71240,71240,71400,71100,71800,71240,21340,71600,71990,71360,71260,71160,71150,58170,71520,03510,71260,71100,71240,71240,71240,71240,71700,71240,71760,71610,71360,71260,71990,71800,71800,58170,71400,21340,71100,71630,71530,71360,21340,21340,71240,71700,03510,21340,71530,71530,71260,71400,71150,71700,71960,71110,21190,71240,71540,71400,21190,71520,71800,71260,71700,71140,58370,21340,58250,71160,58250,71600,71610,71140,58170,71540,21190,58170,71960,71380,71110,71630,71800,71520,71800,71530,71960,71140,71260,71110,71520,71240,71150,71700,21340,21340,71260,71700,21340,71800,71540,71380,71120,71800,71960,71530,58250,71530,69790,71800,21190,71260,21230,71260,71240,71260,03470,71160,71380,21190,71700,71960,71110,71960,71700,71550,71380,71380,71110,71110,71700,71540,71960,71110,71260,71960,58360,71800,21230,71870,03130,71800,71520,71520,71960,58370,71800,71370,71140,21190,58250,69790,71110,21230,71800,21340,21190,21340,21190,71700,71290,58250,03130,71290,71370,71800,03470,71290,03130,71400,71150,71260,71520,21230,71540,21190,71110,69860,71160,71530,21230,69860,71540,71290,71260,03130,71960,71380,21190,71290,71260,21360,21230,21190,71370,58430,21190,58360,58360,71170,71170,71370,71870,21360,71140,71260,71960,21230,69790,71170,71110,71590,71118,71620,58370,71960,71550,71960,21190,71960,71550,21360,69860,21190,03290,03470,01190,71110,69840,71960,71260,71140,69860,71370,71110,21360,21200) AND fami_id='3' AND cate_id='50' AND type_id='1' AND ssrubr_id='595' AND wish_id<>'262878' AND wish_url='' ORDER BY rand() LIMIT 0,10

  75. 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='595' LIMIT 0,1

  76. 0.0001

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

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

  78. 0.0001

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

  79. 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='595' LIMIT 0,1

  80. 0.0001

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

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

  82. 0.0001

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

  83. 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='595' LIMIT 0,1

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

  85. 0.0001

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

  86. 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='595' LIMIT 0,1

  87. 0.0001

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

  89. 0.0001

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

  90. 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='595' LIMIT 0,1

  91. 0.0001

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

  93. 0.0001

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

  94. 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='595' LIMIT 0,1

  95. 0.0001

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

  97. 0.0001

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

  98. 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='595' LIMIT 0,1

  99. 0.0001

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

  101. 0.0001

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

  102. 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='595' LIMIT 0,1

  103. 0.0001

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

  105. 0.0001

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

  106. 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='595' LIMIT 0,1

  107. 0.0001

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

  109. 0.0001

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

  110. 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='595' LIMIT 0,1

  111. 0.0001

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

  113. 0.0002

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

  114. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 595

  115. 0.0008

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

  116. 0

    SELECT count(*) as nbwish FROM wish

  117. 0.0493

    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

117 requetes sql en 0.0757

Taille variable Globale : 57.46 KB