Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Service : Débroussaillage

Autres annonces du voisin

Tout voir
Service multi services
Service multi services
SERVICE : BRICOLEUR DISPO
Profil du voisin
Sébastien G

Montceau-les-Mines 71300

20€/h

Demander ce bricoleur
Location karcher
Location karcher
KARCHER ESSENCE
Profil du voisin
Sébastien G

Montceau-les-Mines 71300

30€/j

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

Montceau-les-Mines 71300

20€/h

Demander d'agencer
Location leve plaques
Location leve plaques
LèVE PLAQUE PRO
Profil du voisin
Sébastien G

Montceau-les-Mines 71300

20€/j

Louer le lève-plaques
Service coach sportif
Service coach sportif
DIPLOMé ET EXPéRIMENTé
Profil du voisin
Sébastien G

Montceau-les-Mines 71300

20€/h

Faire appel à ce coach
Service tonte de pelouse
Service tonte de pelouse
SERVICE : TONTE DE PELOUSE
Profil du voisin
Sébastien G

Montceau-les-Mines 71300

20€/h

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

Montceau-les-Mines 71300

10€/j

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

Saint-Berain-sous-Sanvignes 71300

15€/j

Louer la bétonnière
Location niveau laser
Location niveau laser
LOCATION NIVEAU LASER BOSCH GLL3 80
Profil du voisin
Sébastien G

Montceau-les-Mines 71300

20€/j

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

Montceau-les-Mines 71300

15€/j

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

Montceau-les-Mines 71300

15€/j

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

Montceau-les-Mines 71300

15€/j

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

Montceau-les-Mines 71300

15€/j

Louer la meuleuse

Annonces similaires

Tout voir
Service debroussaillage
Service debroussaillage
ENTRETIEN PARC ET JARDIN
Profil du voisin
Arnaud

Millay 58170

30€/h

Je veux débroussailler
Service debroussaillage
Service debroussaillage
SERVICE : DéBROUSSAILLAGE
Profil du voisin
Olivier C

Montcenis 71710

-- €

Je veux débroussailler
Service debroussaillage
Service debroussaillage
SERVICE : DEBROUSSAILLAGE
Profil du voisin
Marlène M

Fontaines 71150

30€/h

Je veux débroussailler
Service debroussaillage
Service debroussaillage
SERVICE : PASSIONNé
Profil du voisin
Johann C

Jouvençon 71290

25€/h

Je veux débroussailler
Service debroussaillage
Service debroussaillage
DéBROUSSAILLER VOS TERRAINS
Profil du voisin
Vincent D

Ouroux-sur-Saone 71370

25€/h

Je veux débroussailler

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

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

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='debroussaillage' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='529'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'debroussaillage' 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.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

    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.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 = 262884

  23. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=529 LIMIT 1

  24. 0

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

  25. 0.0001

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

  27. 0

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

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

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

  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='44381' AND wish_id<>'262884' 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='595' 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.0001

    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='684' 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='607' 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.0001

    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='59' 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.0001

    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='1025' 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.0001

    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='524' 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.0001

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

  51. 0

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

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

  54. 0

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

    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

    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

    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

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

    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='38' AND type_id='1' AND ssrubr_id='529' AND wish_id<>'262884' 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='529' 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=542585 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 = 542585 AND W.type_id = 1) OR (W.util_id != 542585 AND W.type_id = 2)) AND (`post_util_id` = 542585 OR `dest_util_id` = 542585) 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 = 542585

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

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

  84. 0.0001

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

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

  86. 0.0001

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

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

  88. 0.0001

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

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

  90. 0.0001

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

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

  92. 0.0001

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

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

  94. 0.0001

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

  95. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 529

  96. 0.0008

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

  97. 0

    SELECT count(*) as nbwish FROM wish

  98. 0.0471

    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

98 requetes sql en 0.0628

Taille variable Globale : 55.62 KB