Location ›

Animations

›

Lancez votre recherche pour voir les annonces.

Indiquer un code postal ou une ville

Poster une annonce

Se connecter S'inscrire

i18n

REIMS aide jardinage

Service Entretien jardin Service entretien jardin entre particuliers (51)

Discuter

Ce voisin propose ce service à Reims (51100)

20€/h

Excel B.

15 annonces

Prix

20€/h

Description de l'annonce

Bonjour j'espère que vous allez bien,
Je m'appelle Excel j'ai 23 ans, et je suis actuellement en train de créer mon entreprise. En parallèle de celle-ci je propose mes services pour lancer mon réseau professionnel. Merci à vous & à bientôt j'espère.
#entretien jardin

Autres annonces du voisin

Tout voir

Service coupe de bois

REIMS AIDE AUX PARTICULIERS

Excel B

Reims 51100

30€/^h

Service arrosage

REIMS AIDE JARDINAGE

Excel B

Reims 51100

14€/^h

Service taille de haies

REIMS AIDE JARDINAGE

Excel B

Reims 51100

25€/^h

Service tonte de pelouse

REIMS AIDE JARDINAGE

Excel B

Reims 51100

25€/^h

Service transport personne

REIMS AIDE AUX PARTICULIERS

Excel B

Reims 51100

30€

Service gardiennage

REIMS AIDE AUX PARTICULIERS

Excel B

Reims 51100

-- €

Service service a personne

REIMS AIDE AUX PARTICULIERS

Excel B

Reims 51100

25€/^h

Service aide aux courses

REIMS AIDE AUX PARTICULIERS

Excel B

Reims 51100

13€/^h

Service aide personne

REIMS AIDE AUX PARTICULIERS

Excel B

Reims 51100

20€/^h

Service aide personne

REIMS AIDE AUX PARTICULIERS

Excel B

Reims 51100

20€/^h

Service personal shopper

REIMS AIDE AUX PARTICULIERS

Excel B

Reims 51100

-- €

Service livraison

SERVICE : REIMS AIDE COLIS

Excel B

Reims 51100

25€/^h

Service debarras

SERVICE : REIMS AIDE

Excel B

Reims 51100

35€/^h

Service aide demenageur

SERVICE : REIMS AIDE

Excel B

Reims 51100

25€/^h

Annonces similaires

Tout voir

Service entretien jardin

ENTRETIEN JARDIN

Matéo J

Pontfaverger-Moronvilliers 51490

10€/^h

Service entretien jardin

SERVICE : JARDINIER

Kevin F

Reims 51100

20€/^h

Service entretien jardin

AIDE POUR VOTRE JARDIN

Ophelie

Saint-Leonard 51500

20€/^h

Service entretien jardin

ENTRETIEN JARDIN PELOUSE HAIES..

Côme D

Laon 02000

20€/^h

Service entretien jardin

TONDEUSE / DEBROUSSAILLEUSE

Yohan L

Villemontoire 02210

20€/^h

Service entretien jardin

ENTRETIEN JARDIN ET BRICOLAGE

Leo A

Cormicy 51220

15€/^h

Service entretien jardin

SOS JARDIN EN DéTRESSE

Voisin #41258

Bazoches-sur-Vesles 02220

20€/^h

Service entretien jardin

TRAVAUX DE JARDINAGE

Jacques P

Pierrepont 02350

12€/^h

Service entretien jardin

TONTE PELOUSE, TAILLAGE ARBUSTE, DéBROU

Kama A

Soissons 02200

13€/^h

Service entretien jardin

BROYAGE/LABOUR /FRAISAGE

Eric S

Villers-sur-Fere 02130

300€

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

Poster une annonce

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Autre chose ?

Contactez-nous

Script : /wiiz-annonce.php

0.0001
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''
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='530790'
0.0001
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='entretien-jardin' AND fami_id='3' AND ssrubr_photo<>'' AND ssrubr_id='527'
0.0001
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'entretien-jardin' LIMIT 1
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'
0
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='51'
0.0001
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='379439' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
0
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 379439
0.0001
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
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
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
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
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
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
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
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
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
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
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
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
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
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 = 530790
0
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=527 LIMIT 1
0.0001
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='530790'
0.0001
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='530790' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
0
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 379439 AND util_tel != ''
0
SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 379439 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''
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 = 379439 AND W.type_id = 1) OR (W.util_id != 379439 AND W.type_id = 2)) AND (`post_util_id` = 379439 OR `dest_util_id` = 379439) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='379439' AND note_visu IN (1,3,4)
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 = '530790'
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='379439' AND wish_id<>'530790' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
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='1190' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=379439 AND note_visu IN (1,3,4)
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 = 379439 AND W.type_id = 1) OR (W.util_id != 379439 AND W.type_id = 2)) AND (`post_util_id` = 379439 OR `dest_util_id` = 379439) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 379439
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='531' LIMIT 0,1
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 = 379439 AND W.type_id = 1) OR (W.util_id != 379439 AND W.type_id = 2)) AND (`post_util_id` = 379439 OR `dest_util_id` = 379439) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 379439
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='530' LIMIT 0,1
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 = 379439 AND W.type_id = 1) OR (W.util_id != 379439 AND W.type_id = 2)) AND (`post_util_id` = 379439 OR `dest_util_id` = 379439) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 379439
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
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 = 379439 AND W.type_id = 1) OR (W.util_id != 379439 AND W.type_id = 2)) AND (`post_util_id` = 379439 OR `dest_util_id` = 379439) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 379439
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='1064' LIMIT 0,1
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 = 379439 AND W.type_id = 1) OR (W.util_id != 379439 AND W.type_id = 2)) AND (`post_util_id` = 379439 OR `dest_util_id` = 379439) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 379439
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='1133' LIMIT 0,1
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 = 379439 AND W.type_id = 1) OR (W.util_id != 379439 AND W.type_id = 2)) AND (`post_util_id` = 379439 OR `dest_util_id` = 379439) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 379439
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='1092' LIMIT 0,1
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 = 379439 AND W.type_id = 1) OR (W.util_id != 379439 AND W.type_id = 2)) AND (`post_util_id` = 379439 OR `dest_util_id` = 379439) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 379439
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='958' LIMIT 0,1
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 = 379439 AND W.type_id = 1) OR (W.util_id != 379439 AND W.type_id = 2)) AND (`post_util_id` = 379439 OR `dest_util_id` = 379439) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 379439
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='1020' LIMIT 0,1
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 = 379439 AND W.type_id = 1) OR (W.util_id != 379439 AND W.type_id = 2)) AND (`post_util_id` = 379439 OR `dest_util_id` = 379439) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 379439
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='1020' LIMIT 0,1
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 = 379439 AND W.type_id = 1) OR (W.util_id != 379439 AND W.type_id = 2)) AND (`post_util_id` = 379439 OR `dest_util_id` = 379439) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 379439
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='1172' LIMIT 0,1
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 = 379439 AND W.type_id = 1) OR (W.util_id != 379439 AND W.type_id = 2)) AND (`post_util_id` = 379439 OR `dest_util_id` = 379439) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 379439
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='959' LIMIT 0,1
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 = 379439 AND W.type_id = 1) OR (W.util_id != 379439 AND W.type_id = 2)) AND (`post_util_id` = 379439 OR `dest_util_id` = 379439) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 379439
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='1113' LIMIT 0,1
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 = 379439 AND W.type_id = 1) OR (W.util_id != 379439 AND W.type_id = 2)) AND (`post_util_id` = 379439 OR `dest_util_id` = 379439) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 379439
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='996' LIMIT 0,1
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 = 379439 AND W.type_id = 1) OR (W.util_id != 379439 AND W.type_id = 2)) AND (`post_util_id` = 379439 OR `dest_util_id` = 379439) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 379439
0.0001
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='51100'
0.0047
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.25*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.25*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((4.03333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.800339197041 AND ville_latitude_deg<49.699660802959 AND ville_longitude_deg>3.344461825585 AND ville_longitude_deg<4.722198174415 HAVING distance <= 50 ORDER BY distance ASC
0.0044
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 (51100,51430,51370,51350,51450,51370,51420,51430,51500,51500,51370,51370,51500,51500,51370,51220,51500,51220,51220,51420,51500,51500,51420,51390,51420,51390,51220,51140,51390,51390,51500,51140,51390,51390,51500,51500,51220,51500,51500,51220,51110,51500,51110,51390,51140,51140,51500,51110,51390,51220,51220,51500,51500,51220,51390,51390,51110,51390,51390,51110,51360,51390,51170,51500,51360,51480,51490,51220,51220,51480,51170,51360,51170,51140,51140,51380,51160,02190,51490,51170,02190,51110,51170,51500,51110,51480,51110,51140,51140,51360,51140,51170,51220,51110,51140,51110,51170,51170,51140,51110,51170,02190,51160,51150,51380,51170,51170,02160,51480,51480,51490,51140,51170,51140,02190,02160,51110,02190,51160,51480,51480,51160,02190,51490,51400,08190,51150,51400,02190,51140,51170,02190,51160,51400,51140,51480,51380,51170,02160,51150,02190,02190,51480,51160,08190,51160,51140,02160,08190,51170,51200,02190,51700,51170,51490,51140,51170,08190,51480,51480,51170,51170,51400,51160,08310,02160,51160,51700,51150,08190,08190,51150,51200,08300,51380,51700,51170,51170,51150,51200,51480,51700,08310,51200,02160,02160,51170,08300,51480,51400,51150,51700,02160,51170,02190,02190,51170,51170,08300,02160,02160,51400,02160,02190,51700,08190,51150,51480,51490,08190,51400,51480,02130,51170,51490,02160,51170,08300,08300,51480,51700,51200,51530,51170,51150,02160,51700,51480,02160,51490,02130,51700,08300,51600,51150,51200,08310,08310,08300,02160,02190,51200,02160,02160,51400,51150,08190,08190,08190,51150,51200,02160,51700,51490,08190,02160,51700,02160,02130,51200,51600,08310,08190,02160,02820,02160,51700,02160,51200,02130,02820,02220,02130,02160,02160,08190,51700,02160,51400,08310,02220,51700,51400,51190,51150,51200,51150,02190,51200,51190,02160,02220,02820,51700,08300,51200,51150,08310,02160,02160,02160,02820,51200,51200,08310,02220,02220,51150,02160,02860,02160,51700,51600,51190,02190,02820,51520,08190,51700,51190,02820,08300,51700,51200,08310,02160,02860,51700,02820,08360,02820,51200,02220,02130,51600,02220,51150,02860,02220,08310,02220,51190,51190,02130,51600,02160,51400,51510,02160,02160,02860,51400,51400,51130,02220,51600,02860,02820,08360,02160,51130,08310,08310,02860,08310,02820,08360,02130,51700,02220,02130,08360,02150,02220,02220,08300,02150,08300,02220,51700,51400,51130,51130,08310,02130,08220,02820,51270,08310,02220,02860,51130,02220,02860,08300,02840,51520,08300,02860,02130,08310,02000,02160,02850,02150,51130,02130,02860,02860,08300,51520,02130,51130,51510,51510,51600,02130,02860,08220,51130,02220,51510,51600,08360,51510,51510,02220,02370,02130,08300,08300,02860,51460,02850,08300,02860,02840,08300,02220,02840,08310,51700,51600,51270,02220,02220,02860,02370,08310,51130,02840,02330,08220,51130,02860,02220,02220,51130,51270,02370,02850,08220,51130,51270,02850,02860,08300,02840,02860,51270,02130,08300,02350,08310,02220,08130,08300,51270,51000,08130,02000,51600,02860,02850,02850,08300,08300,02850,02330,51130,51130,08400,02860,08300,02150,02130,08300,51130,51130,02350,51270,51270,02220,02370,02220,02130,51210,02350,08130,02370,02130,08300,02860,51130,51130,51470,51510,51270,02860,02130,02330,02220,02000,08220,02000,51600,02340,02370,02330,51600,51130,51270,02840,02400,51270,02220,08220,02350,51460,02840,02350,02000,08220,08130,08270,08400,08300,02330,51510,02330,51510,02220,02650,02370,08270,02000,02130,02220,08300,02340,08130,02350,51240,51270,51270,02330,02000,02650,08130,02210,02330,08220,02400,02210,08300,02210,51270,08400,08400,02200,02330,51210,08220,51240,51210,02000,51130,08400,51210,02370,08400,02350,02000,02400,08400,51520,02210,51600,02650,02340,02880,02350,02880,08400,51130,08400,02210,51460,02200,51320,08270,02200,08400,02210,51130,02000,02340,51130,02200,02320,02880,02340,02340,02340,02000,02400,02880,08270,02000,08220,51130,51470,08220,02000,02000,51520,02210,08400,08400,08400,02210,51240,02840,02000,02350,08270,08130,08130,51240,08400,02000,02330,08130,02000,08270,02210,02350,51210,51270,02350,08220,02330,02340,08400,02350,02000,02880,08270,51800,02330,02210,51270,51270,51240,02320,08270,51210,08130,02000,02400,02200,02200,02000,02250,02400,08270,51600,51600,51600,02400,08270,08400,02400,51600,08270,51270,08220,08220,02340,51240,08130,02320,08400,02210,51800,02210,51270,51800,02350,02210,02330,51460,02400,02880,02210,02880) AND fami_id='3' AND cate_id='38' AND type_id='1' AND ssrubr_id='527' AND wish_id<>'530790' AND wish_url='' ORDER BY rand() LIMIT 0,10
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='527' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=144420 AND note_visu IN (1,3,4)
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 = 144420 AND W.type_id = 1) OR (W.util_id != 144420 AND W.type_id = 2)) AND (`post_util_id` = 144420 OR `dest_util_id` = 144420) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 144420
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='527' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=502746 AND note_visu IN (1,3,4)
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 = 502746 AND W.type_id = 1) OR (W.util_id != 502746 AND W.type_id = 2)) AND (`post_util_id` = 502746 OR `dest_util_id` = 502746) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 502746
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='527' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=502742 AND note_visu IN (1,3,4)
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 = 502742 AND W.type_id = 1) OR (W.util_id != 502742 AND W.type_id = 2)) AND (`post_util_id` = 502742 OR `dest_util_id` = 502742) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 502742
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='527' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=416826 AND note_visu IN (1,3,4)
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 = 416826 AND W.type_id = 1) OR (W.util_id != 416826 AND W.type_id = 2)) AND (`post_util_id` = 416826 OR `dest_util_id` = 416826) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 416826
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='527' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=339730 AND note_visu IN (1,3,4)
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 = 339730 AND W.type_id = 1) OR (W.util_id != 339730 AND W.type_id = 2)) AND (`post_util_id` = 339730 OR `dest_util_id` = 339730) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 339730
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='527' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=86932 AND note_visu IN (1,3,4)
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 = 86932 AND W.type_id = 1) OR (W.util_id != 86932 AND W.type_id = 2)) AND (`post_util_id` = 86932 OR `dest_util_id` = 86932) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 86932
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='527' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=41258 AND note_visu IN (1,3,4)
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 = 41258 AND W.type_id = 1) OR (W.util_id != 41258 AND W.type_id = 2)) AND (`post_util_id` = 41258 OR `dest_util_id` = 41258) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 41258
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='527' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=272408 AND note_visu IN (1,3,4)
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 = 272408 AND W.type_id = 1) OR (W.util_id != 272408 AND W.type_id = 2)) AND (`post_util_id` = 272408 OR `dest_util_id` = 272408) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 272408
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='527' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=313730 AND note_visu IN (1,3,4)
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 = 313730 AND W.type_id = 1) OR (W.util_id != 313730 AND W.type_id = 2)) AND (`post_util_id` = 313730 OR `dest_util_id` = 313730) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 313730
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='527' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=182460 AND note_visu IN (1,3,4)
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 = 182460 AND W.type_id = 1) OR (W.util_id != 182460 AND W.type_id = 2)) AND (`post_util_id` = 182460 OR `dest_util_id` = 182460) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0001
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 182460
0
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 527
0.0009
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
0
SELECT count(*) as nbwish FROM wish
0.0512
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

121 requetes sql en 0.0734

Taille variable Globale : 57.96 KB