Location ›

Animations

›

Lancez votre recherche pour voir les annonces.

Indiquer un code postal ou une ville

Poster une annonce

Se connecter S'inscrire

i18n

Service : Secrétariat

Service Secretariat

Discuter

Ce voisin propose ce service à Mantes-la-Ville (78711)

25€/h

Dona A.

15 annonces

Prix

25€/h

Description de l'annonce

Je vous propose tous les services ayant trait à la fonction d'assistant de direction: prise et planification de rendez-vous, rédaction de courriers électroniques et lettres, organisation d'agendas… etc
#secretariat

Autres annonces du voisin

Tout voir

Service montage video

SERVICE : MONTAGE VIDéOS

Dona A

Mantes-la-Ville 78711

40€/^h

Demander un montage

Service aide aux courses

SERVICE : AIDE AUX COURSES

Dona A

Mantes-la-Ville 78711

14€/^h

Demander une course

Service aide personne

SERVICE : AIDE A LA PERSONNE

Dona A

Mantes-la-Ville 78711

20€/^h

Demander une aide

Service nettoyage

SERVICE DE NETTOYAGE

Dona A

Mantes-la-Ville 78711

25€/^h

Demander un nettoyage

Service traduction

SERVICE : TRADUCTION

Dona A

Mantes-la-Ville 78711

35€

Demander une traduction

Service decorateur

DéCORATEUR D’INTéRIEUR

Dona A

Mantes-la-Ville 78711

100€

Demander ce décorateur

Service decorateur

DéCORATEUR D’INTéRIEUR

Dona A

Mantes-la-Ville 78711

100€

Demander ce décorateur

Service aide demenageur

SERVICE : AIDE DéMéNAGEUR

Dona A

Mantes-la-Ville 78711

25€/^h

Demander ce déménageur

Service coach sportif

SERVICE : COACH SPORTIF

Dona A

Mantes-la-Ville 78711

40€

Faire appel à ce coach

Service entretien jardin

SERVICE : ENTRETIEN JARDIN

Dona A

Mantes-la-Ville 78711

20€/^h

Demander ce jardinier

Service garde de chien

SERVICE : GARDE CHIEN

Dona A

Mantes-la-Ville 78711

15€/^j

Demander ce petsitter

Service montage de meubles

SERVICE : MONTAGE MEUBLES

Dona A

Mantes-la-Ville 78711

25€/^h

Demander ce monteur

Service soutien scolaire

SERVICE : SUPPORT SCOLAIRE

Dona A

Mantes-la-Ville 78711

20€/^h

Demander du soutien

Service cours de sport

COURS DE REMISE EN FORME

Dona A

Mantes-la-Ville 78711

30€/^h

Réserver un cours

Annonces similaires

Tout voir

Service secretariat

CONSEILLèRE EN ASSURANCE

Marie hélène B

Meru 60110

40€/^h

Demander un service

Service secretariat

REMPLIR OU FAIRE DES PAPIERS

Casey F

5.0 100% fiable

Paris 75020

-- €

Demander un service

5.0 100%

Service secretariat

SERVICES DE SECRéTARIAT

Salima K

Paris 75018

15€/^h

Demander un service

Service secretariat

SERVICE : SECRéTARIAT

Joao F

Beynes 78650

20€/^h

Demander un service

Service secretariat

AIDE AUX COURRIERS ADMINISTRATIFS

Helene L

L'Hay-les-Roses 94240

25€/^h

Demander un service

Service secretariat

RéDACTION DE COURRIERS BILINGUES

Racha C

Bures-sur-Yvette 91440

19€/^h

Demander un service

Service secretariat

PERMIS DE CONSTRUIRE

Alexandre L

Saint-Prix 95390

25€/^h

Demander un service

Service secretariat

MISE EN PAGE DOCUMENT

Julie K

Paris 75013

30€/^h

Demander un service

Service secretariat

SECRéTARIAT AIDE ADMINISTRATIVE

Nadine L

Nointel 95590

25€/^h

Demander un service

Service secretariat

SECRéTAIRE ADMINISTRATIVE

Dalila A

Aubervilliers 93300

20€/^h

Demander un service

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

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='620996'
0.0001
INSERT INTO wish_photos (`wish_id`, `wish_temp_id`, `photo_path`, `photo_ordre`) VALUES (620996, 0, '/img/wiiz/476652-250323-0328-service-secretariat.jpeg', 0)
0.0001
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'secretariat' 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='229'
0.0001
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='78'
0.0001
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='476652' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
0
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 476652
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.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
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.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
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
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.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
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.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
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
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 = 620996
0
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1134 LIMIT 1
0.0001
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='620996'
0.0001
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='620996' 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` = 476652 AND util_tel != ''
0
SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 476652 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 = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) 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='476652' 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 = '620996'
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='476652' AND wish_id<>'620996' 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='1005' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=476652 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 = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) 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 = 476652
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 = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) 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 = 476652
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 = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) 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 = 476652
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='970' 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 = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) 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 = 476652
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='1144' 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 = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) 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 = 476652
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='586' 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 = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) 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 = 476652
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='586' 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 = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) 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 = 476652
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 = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) 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 = 476652
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
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 = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) 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 = 476652
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 M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) 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 = 476652
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='951' 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 = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) 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 = 476652
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='600' 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 = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) 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 = 476652
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='1024' 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 = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) 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 = 476652
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='1171' 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 = 476652 AND W.type_id = 1) OR (W.util_id != 476652 AND W.type_id = 2)) AND (`post_util_id` = 476652 OR `dest_util_id` = 476652) 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 = 476652
0.0001
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='78711'
0.006
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.9667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((1.71667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.517039197041 AND ville_latitude_deg<49.416360802959 AND ville_longitude_deg>1.0317239280719 AND ville_longitude_deg<2.4016160719281 HAVING distance <= 50 ORDER BY distance ASC
0.0037
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 (78200,78711,78930,78200,78930,78520,78200,78440,78930,78930,78930,78200,78200,78200,78200,78200,78930,78520,78790,78970,78440,78200,78930,78200,78200,78710,78440,78580,78520,78790,78790,78680,78440,78790,78440,78980,78520,78790,78200,78410,78410,78270,78790,78440,78270,78790,78200,78410,78440,78770,78440,78111,78820,78126,78270,78790,78410,78910,95780,95510,78980,78580,95510,78910,78580,78840,78770,95510,78770,78270,78250,78980,78440,78840,78250,78770,78910,78910,95510,78270,95450,78124,78440,78910,78770,78410,78440,78790,95780,78980,78250,78980,78790,78270,78580,78980,95780,78770,78124,78250,78250,78270,78920,95510,78910,78910,78910,78130,78270,28260,27620,78270,95450,95420,95420,95510,78250,78580,28260,78980,78130,27640,78270,27620,78910,78630,78270,78770,78550,28260,95710,78890,95450,78650,95420,78650,78550,27630,27620,78270,78490,28260,28560,78740,78270,78121,95450,95420,95450,78940,27120,95450,28560,95420,78490,78550,78940,78740,95420,95710,95450,78810,78270,95450,28260,78540,78490,78850,78480,27730,95420,78550,28410,78640,78640,27120,95180,78630,95710,95450,27540,78640,27640,95420,78490,78510,78670,78670,95420,95450,95420,27620,95450,78810,27200,28260,78640,95000,27780,27630,78490,78490,95800,27120,27120,27630,28260,78550,95450,27120,27730,28260,95420,78950,78490,78490,27630,95450,27630,27640,78240,78490,78570,27120,78955,95450,78550,78450,27730,95450,95640,95750,95280,95650,78370,95420,78490,95770,95490,27630,95420,78240,27750,27630,78113,27510,28410,95650,95650,78760,28410,28260,27950,27950,27530,27120,78300,28410,27120,95640,95640,28410,78860,28260,27630,60240,78260,78490,78570,27950,27220,95650,27950,78340,27510,78780,60240,27220,95770,95770,27120,95000,27420,78113,60240,28410,78450,95830,27950,27120,95000,78990,78310,28410,27220,27220,60240,27120,27510,60240,27510,78690,78112,95750,27510,27420,95830,60240,27950,27120,78100,27220,95520,27120,27220,78620,27720,27120,28410,78610,78700,95640,78310,28410,78113,60240,27220,27120,78750,27420,27950,27920,27920,95610,78590,95650,78590,78390,78113,78230,78160,27510,27220,27940,28570,78190,27220,27120,95300,78320,78330,28500,95640,28520,28520,60240,78870,27120,60240,60240,95640,27870,95300,27120,78600,78110,27700,27510,95640,60240,95810,27950,78610,78113,95810,27120,95310,78560,27600,28500,78113,78690,27420,27940,27420,78610,78430,27120,27720,27810,78210,27710,78125,28210,27950,95300,27220,27600,78600,60240,78320,27120,28500,27220,78125,27120,60240,27220,78610,28210,78180,78360,60240,27120,78380,78290,27220,27510,27220,27420,78320,60240,95810,60240,78150,27220,60240,78400,28210,60240,95220,27930,27700,27930,95480,78125,78150,27420,95300,60119,28500,78280,60240,78470,95530,27120,95370,78500,27150,60240,95640,78170,27220,78960,27220,78420,95810,27600,27940,95810,27650,95430,28500,27930,28500,27650,28500,27930,27490,78125,27940,95810,27150,27150,28210,78720,27830,27930,28210,78125,95240,60119,27930,28500,27930,60240,28500,60119,27140,27600,78470,78000,95250,27600,78800,27700,60240,27320,27220,27420,28210,27490,27220,92000,27700,28500,78720,60590,78120,60240,60240,28210,28100,78114,27220,92500,95690,92420,92430,27600,95870,92380,95810,27770,27700,27700,27220,28210,95540,78720,27660,27660,27930,95550,95150,27150,78125,28210,60240,60173,95430,95630,95690,95740,27930,27150,28210,28210,28500,27650,78350,78530,95130,78220,27150,28500,27220,27490,95130,78117,60590,28210,78720,27420,27930,92410,78117,95760,60590,27700,27930,78460,78460,27930,27150,27600,95690,60590,27930,95690,78140,27220,95110,78125,95100,78125,60240,28230,27940,60110,92310,60240,27140,92210,60590,60240,95840,95320,92700,92800,92150,60240,27320,28130,27700,60240,92250,78350,27320,27930,91470,27150,92400,27700,60175,92370,27940,78470,95840,95620,27490,95120,27930,60240,60240,91190,28500,28130,27600,95390,60790,92270,27240,27600,28380,27140,60240,28230,28500,78720,27490,27860,28500,27930,28130,27430,27150,95560,27930,95290,92200,27720,91190,28500,27700,95218,95210,95600,27180,27240,27150,92100,27000,95680,78120,27150,60240,60590,91400,28500,60149,92600,92300,91470,27700,60110,28210,28500,92360,92190,27320,28210,60110,28210,28130,95230,27150,78125,95340,27150,95580,95580,27930,60790,27400,92230,60590,28350,91470,78125,27440,60110,27240,95660,28210,60590,27930,93800,92110,78125,27930,27930,95590,27320,28500,27700,92130,95570,27700,27150,28130,95880,91570,27180,91940,27320,91190,91430,27400,95560,60590,27440,78830,95260,91470,92140,60790,91440,78120,91400,27150,60240,28320,60590,27150,27400,60540,60540,27930,27400,60230,60540,91430,27700,60110,95340,27180,60390,95170,27150,28170,28130,27430,92350,92170,95560,95160,93450,92390,28500,91400,95260,78830,27320,92320,60570,27430,27430,27180,95330,95560,93430,93400,27440,60390,95590,91940,28170,92240,95570,28270,92290,27240,27430,27400,28500,60790,27240,27150,28270,27930,27930,92260,92330,95360,95410,27180,27930,27440,27430,27140,60590,28320,27400,95590,27150,92220,28170,27440,27180,95350,60590,27400,60540,27440,91940,28500,78730,78730,91370,28130,92120,27430,60540,93200,93210,28350,95570,27930,28130,60790,27440,60390,28130,78730,27430,27150,28130,75009,75020,75019,75005,75116,75001,75000,75018,75002,75015,75012,75011,75010,75016,75008,75007,75006,75017,75013,75004,75003,75014,91640,93380,27400,27400,28170,95350,60570,27240,60530,60530,27150,60790,60390,60430,91120,28130,95340,91470,95460,27240,94250,27100,27100,27430,27150,28320,78730,60390,95270,28320,60390,27380,95270,60570,27930,93240,91640,27400,94110,27400,27240,92340,95400,95200,27180,27400,60530,91300,95440,27240,93300,93120,27790,92160,60390,28270,91140,95820,28170,78660,27930,95570,91140,27400,27850,27480,27590,94235,94239,94231,94233,94238,94237,94236,94230,94232,94240,94234,60730,27380,60390,27110,60850,95270,60530,91470,60730,27190,60530,27400,27480,91160) AND fami_id='3' AND cate_id='229' AND type_id='1' AND ssrubr_id='1134' AND wish_id<>'620996' 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='1134' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=402482 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 = 402482 AND W.type_id = 1) OR (W.util_id != 402482 AND W.type_id = 2)) AND (`post_util_id` = 402482 OR `dest_util_id` = 402482) 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 = 402482
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='1134' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=457703 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 = 457703 AND W.type_id = 1) OR (W.util_id != 457703 AND W.type_id = 2)) AND (`post_util_id` = 457703 OR `dest_util_id` = 457703) 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 = 457703
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='1134' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=37618 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 = 37618 AND W.type_id = 1) OR (W.util_id != 37618 AND W.type_id = 2)) AND (`post_util_id` = 37618 OR `dest_util_id` = 37618) 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 = 37618
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='1134' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=399996 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 = 399996 AND W.type_id = 1) OR (W.util_id != 399996 AND W.type_id = 2)) AND (`post_util_id` = 399996 OR `dest_util_id` = 399996) 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 = 399996
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='1134' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=283023 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 = 283023 AND W.type_id = 1) OR (W.util_id != 283023 AND W.type_id = 2)) AND (`post_util_id` = 283023 OR `dest_util_id` = 283023) 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 = 283023
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='1134' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=48685 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 = 48685 AND W.type_id = 1) OR (W.util_id != 48685 AND W.type_id = 2)) AND (`post_util_id` = 48685 OR `dest_util_id` = 48685) 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 = 48685
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='1134' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=406099 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 = 406099 AND W.type_id = 1) OR (W.util_id != 406099 AND W.type_id = 2)) AND (`post_util_id` = 406099 OR `dest_util_id` = 406099) 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 = 406099
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='1134' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=366185 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 = 366185 AND W.type_id = 1) OR (W.util_id != 366185 AND W.type_id = 2)) AND (`post_util_id` = 366185 OR `dest_util_id` = 366185) 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 = 366185
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='1134' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=212669 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 = 212669 AND W.type_id = 1) OR (W.util_id != 212669 AND W.type_id = 2)) AND (`post_util_id` = 212669 OR `dest_util_id` = 212669) 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 = 212669
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='1134' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=222547 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 = 222547 AND W.type_id = 1) OR (W.util_id != 222547 AND W.type_id = 2)) AND (`post_util_id` = 222547 OR `dest_util_id` = 222547) 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 = 222547
0
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 1134
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.0507
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.0748

Taille variable Globale : 58.01 KB