Indiquer un code postal ou une ville Indiquer un code postal

Poster une annonce

Se connecter S'inscrire

i18n

Famille cherche femme / étudiante (6 mois)

Location Logement contre service

(Photo non contractuelle)

Discuter

Ce voisin propose en location à Jouars-Pontchartrain (78760)

550€

Myriam C.

1 annonce

Prix

550€

Description de l'annonce

Bonjour,
Nous sommes une joyeuse tribu avec 4 enfants et emménageons dans une maison qui a un F1 indépendant. Nous le proposons à loyer modéré (550 au lieu de 750) contre une dizaine d'heures d'aide avec nos enfants. Les aides seraient : aller / retour écoles et activités, aide aux devoirs, aide aux rangements de chambres... La maison se trouve à Jouars Pontchartrain et le logement est à prendre fin août / début septembre environ. La durée, les modalités précises sont à définir ensemble..
Excellente journée #logement contre service

Annonces similaires

Tout voir

Il y a + de 30j

Appartement 70m2 Terasse dernier étage 1

100€

Paris

Il y a + de 30j

Appartement f2 le bourget

230€/mois

Le Bourget

Il y a + de 30j

Appartement f2 le bourget

230€/mois

Le Bourget

Il y a + de 30j

Logement contre services

230€/mois

Enghien-les-Bains

Il y a + de 30j

Logement étudiant chez l'habitant (12 mo

200€

Paris

Il y a + de 30j

Chambre meublée contre services (6 mois)

-- €

Rambouillet

Il y a + de 30j

Couple marié avec un enfant de 10 mois à

230€/mois

Athis-Mons

Il y a + de 30j

Hébergement contre sortie d'école ou le

-- €

Bezons

Il y a + de 30j

Chambre contre service

230€/mois

Athis-Mons

Il y a + de 30j

Logement contre garde d'enfant

-- €

Parmain

Louer contre service entre particuliers ou proposer contre service en location.

Poster une annonce

Location entre voisins

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.0002
SHOW TABLES LIKE 'pays'
0.0002
SHOW COLUMNS FROM pays LIKE 'pays_tel_%'
0.0003
SELECT pays_code, pays_nom, pays_actif, pays_NDD, pays_drapeau, pays_lang, pays_tel, pays_nb_annonces, pays_tel_masque, pays_tel_max, pays_tel_fmt_paires, pays_tel_mode FROM pays ORDER BY pays_nom ASC
0.0001
SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL
0.0005
SELECT DISTINCT ssrubr_slug FROM ssrubr WHERE ssrubr_visu=1 AND fami_id IN (3,5) AND ssrubr_slug IS NOT NULL AND ssrubr_slug<>''
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='357096'
0.0001
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='logement-contre-service' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='506'
0.0001
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'logement-contre-service' 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='5' AND c.cate_id='193'
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='164575' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
0.0001
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 164575
0.0001
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 357096
0
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=506 LIMIT 1
0.0001
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='357096'
0.0001
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='357096' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
0.0001
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 164575 AND util_tel != ''
0
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=164575 LIMIT 1
0.0002
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 164575 AND W.type_id = 1) OR (W.util_id <> 164575 AND W.type_id = 2)) AND (M.post_util_id = 164575 OR M.dest_util_id = 164575) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0001
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='164575' 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 = '357096'
0.0001
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify 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='164575' AND wish_id<>'357096' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
0.0001
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='78760'
0.0087
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.7833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((1.9- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.333639197041 AND ville_latitude_deg<49.232960802959 AND ville_longitude_deg>1.217560395336 AND ville_longitude_deg<2.582439604664 HAVING distance <= 50 ORDER BY distance ASC
0.0053
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify 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 ('78760','78310','78490','78490','78490','78990','78640','78310','78690','78640','78640','78320','78370','78640','78490','78490','78490','78490','78340','78190','78650','78320','78690','78850','78490','78650','78490','78770','78320','78390','78610','78810','78450','78490','78180','78940','78610','78450','78470','78770','78810','78720','78610','78770','78860','78124','78121','78890','78330','78960','78720','78770','78610','78590','78470','78940','78210','78280','78770','78770','78720','78490','78125','78580','78124','78910','78114','78720','78460','78590','78910','78460','78770','78580','78580','78620','78870','78240','78120','91470','78125','78910','78117','78630','78240','78910','78117','78160','78470','78112','78910','78150','78580','78630','78126','78720','78580','78150','78000','78550','78530','78950','78350','78750','78790','78113','91190','78930','78790','78790','91470','78113','78430','78910','91470','78920','91190','78100','78120','78410','78410','78930','78125','78560','78290','78380','78550','78680','78230','78220','78350','78170','78113','78830','78670','78670','78300','91470','91400','78410','91940','91190','78790','78110','91400','78410','78130','78930','78410','78550','78550','78140','92430','92420','78955','78830','78540','78400','78790','78125','78790','78125','78910','91440','78970','78790','92380','92410','78550','78113','92370','78930','78930','78125','78120','92310','78125','78440','91940','78200','78550','91430','78910','91400','78113','78930','78730','78480','78125','78730','28410','78510','78790','91940','78930','91570','78360','91640','91470','78260','78600','78125','91430','78113','92210','78250','78130','78730','78570','78910','78250','78820','78711','78200','91640','78125','28230','78111','28410','92500','28410','78200','78440','28230','92190','92360','78200','78570','78520','78125','91470','78420','92000','28210','78440','28410','78790','28210','78200','91640','78730','78250','78200','78250','91410','78600','78200','91640','92150','92800','28210','78740','92100','78790','78740','78800','78980','78700','95180','28260','28560','91120','91140','28410','92350','92140','92290','95000','78250','78780','91530','92130','91370','28210','91140','78440','91530','78200','91680','28130','78980','28210','95280','78500','28560','28130','95450','78200','78200','95450','78250','92330','92260','92320','28410','78440','28410','91160','78730','95870','91620','91300','95000','28320','92250','78980','92400','78200','78440','95800','78200','92200','95530','91410','91160','78520','28410','92220','78660','95490','91410','92240','92160','28320','92700','91460','28210','95610','28260','92170','28500','78440','78440','95450','78660','91680','78440','95000','95370','91530','78660','92340','28410','92270','28130','28210','28210','91620','92120','28500','91160','91380','94260','78200','95650','91530','92300','28210','91160','78710','95220','91650','28260','91650','78440','95240','28700','28210','78520','28320','78980','92600','95450','95100','95450','28700','91310','91310','91310','91410','28260','94238','94240','94231','94230','94237','94236','94234','94232','94235','94239','94233','94110','28130','91650','94250','92110','28210','78440','91520','91340','28130','91320','28260','95480','78520','78660','28260','78980','95510','91410','91310','95110','28130','91180','28260','91700','95650','95130','94550','28260','95300','28320','91420','28500','94150','78270','91360','28130','91580','28320','95450','95510','95450','95450','27540','95310','75009','75010','75008','75011','75116','75012','75013','75020','75014','75019','75018','75017','75015','75016','75007','75003','75000','75002','75004','75005','75006','75001','91580','92230','91240','95520','95510','28700','78980','95450','78270','95250','91290','28130','95650','95650','28570','94800','28700','93400','95130','28500','78660','91360','28210','94270','28500','27640','95218','95210','28210','91730','91910','95780','95300','91410','78270','95120','91790','28130','91290','28260','91550','28500','93800','91630','78660','91410','95450','91600','94320','91390','95650','95420','95450','94200','94205','78980','91220','91220','92390','93450','78840','91700','91410','28210','91630','78660','28260','95550','78270','95150','28500','95420','95420','95320','28130','27530','94400','95880','95230','94390','94310','78840','27730','95510','78270','78270','95600','28700','91730','95430','28500','95450','95450','91580','91260','95450','27780','91410','95510','28700','95390','78270','91630','91200','28500','93210','93200','95780','95740','28130','91730','91870','93430','91170','78270','95830','95580','95580','94140','94600','91630','28130','94220','95830','91700','28210','95300','95680','94160','93310','94290','28700','93300','93120','95540','91350','91580','94480','95780','28700','91150','28700','95360','95170','93500','27750','78270','91630','95640','28700','93170','91270','95810','95640','95640','95450','27730','95420','94700','27710','95300','28500','95840','91410','28300','95420','28700','28500','28520','28520','91210','28100','28210','91410','95510','95410','94300','93380','27640','28500','95160','27120','95840','95420','28170','27620','95630','78270','95430','93240','78270','95560','78270','91070','91510','91510','27220','93100','78270','27730','95710','27650','28700','95810','95420','27810','27620','93230','93260','28300','94190','91000','91130','28700','95750','91780','91780','91150','91560','94410','91080','27220','95420','28700','95640','93350','27630','27220','28300','27620','91580','91230','91780','28300','95760','94000','95570','95640','95420','94340','94460','91850','27120','95350','27640','91810','95350','27120','28700','95420','95810','93440','95330','91770','27220','93000','78270','28170','95810','28700','28500','27220','95750','95400','27650','95200','27120','28700','28700','94380','27120','95420','93130','95140','28300','95560','95690','91450','91710','95710','28500','91150','91090','95640','94130','91150','94450','28170','27220','95640','95810','95710','94120','27220','95570','93140','91760','93700','93150','95590','91580','91090','91000','95620','93110','95420','95560','95440','95400','91540','94340','94100','94210','95460','27120','28500','27650','28300','95500','95690','27220','95570','95290','60240','28700','60240','94170','91330','28500','95690','27220','28700','60240','28700','60240','28300','28170','27120','91450','27220','28700','91540','91800','60240','91590','27200','95560','95690','94430','91740','93250','94500','27320','94470','28630','94360','28500','91740','91590','27630','27620','27220','91610','95640','27120','28300','28500','28700','95500','27120','28300','91540','91540','93360','91100','95420','95810','28700','28500','27120','28300','28700','28630','27630','28700','27630','60240','91150','94370','94380','27320','27220','27770','91590','95660','91860','28700','91250','91590','28300','28500','95810','95720','27120','28700','27630','95720','60240','93330','93340','93320','27220','91590','94440','28300','28500','95720','91250','60119','95590','95770','95260','28700','28000','27950','91100','60119','27630','94490','94880','94880','28380','93220','95570','91800','91280','27120','60240','94350','95500','95260','94440','91750','27220','95270','27950','28700','91480','28500','27120','95720','27950','60240','60240','28310','91590','28310','27220','95340','27630','91250','94520','94520','95270','60240','91690','95590','91740','93600','95340','27510','91880','27120','91590','28300','95190','60240','60119','95770','95770','60110','94420','27120','95500','91690','28150','93270','27420','93160','94440','91930','27220','27950','27630','28300','93460','60230','28270','91480','93390','93190','91690','27220','28170','95190','27120') AND fami_id='5' AND cate_id='193' AND type_id='1' AND ssrubr_id='506' AND wish_id<>'357096' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC 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='506' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=541205 AND note_visu IN (1,3,4)
0.0002
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 541205 AND W.type_id = 1) OR (W.util_id <> 541205 AND W.type_id = 2)) AND (M.post_util_id = 541205 OR M.dest_util_id = 541205) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 541205
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='506' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=395457 AND note_visu IN (1,3,4)
0.0002
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 395457 AND W.type_id = 1) OR (W.util_id <> 395457 AND W.type_id = 2)) AND (M.post_util_id = 395457 OR M.dest_util_id = 395457) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 395457
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='506' LIMIT 0,1
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 395457
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='506' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=514430 AND note_visu IN (1,3,4)
0.0002
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 514430 AND W.type_id = 1) OR (W.util_id <> 514430 AND W.type_id = 2)) AND (M.post_util_id = 514430 OR M.dest_util_id = 514430) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 514430
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='506' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=518475 AND note_visu IN (1,3,4)
0.0002
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 518475 AND W.type_id = 1) OR (W.util_id <> 518475 AND W.type_id = 2)) AND (M.post_util_id = 518475 OR M.dest_util_id = 518475) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 518475
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='506' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=505436 AND note_visu IN (1,3,4)
0.0001
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 505436 AND W.type_id = 1) OR (W.util_id <> 505436 AND W.type_id = 2)) AND (M.post_util_id = 505436 OR M.dest_util_id = 505436) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 505436
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='506' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=496366 AND note_visu IN (1,3,4)
0.0001
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 496366 AND W.type_id = 1) OR (W.util_id <> 496366 AND W.type_id = 2)) AND (M.post_util_id = 496366 OR M.dest_util_id = 496366) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 496366
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='506' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=486393 AND note_visu IN (1,3,4)
0.0001
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 486393 AND W.type_id = 1) OR (W.util_id <> 486393 AND W.type_id = 2)) AND (M.post_util_id = 486393 OR M.dest_util_id = 486393) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 486393
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='506' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=415349 AND note_visu IN (1,3,4)
0.0001
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 415349 AND W.type_id = 1) OR (W.util_id <> 415349 AND W.type_id = 2)) AND (M.post_util_id = 415349 OR M.dest_util_id = 415349) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 415349
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='506' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=457804 AND note_visu IN (1,3,4)
0.0001
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 457804 AND W.type_id = 1) OR (W.util_id <> 457804 AND W.type_id = 2)) AND (M.post_util_id = 457804 OR M.dest_util_id = 457804) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
0.0002
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 457804
0
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 506
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='5' AND cate_cate_id IS NULL ORDER BY cate_order ASC
0.0003
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 (87) 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 (88) 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 (81) 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 (110) 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 (227) ORDER BY ssrubr_order ASC
0.0003
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 (176) ORDER BY ssrubr_order ASC
0.0003
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 (79) 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 (208) 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 (228) ORDER BY ssrubr_order ASC
0.0003
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 (207) 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 (95) 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 (173) 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 (83) 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 (93) 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 (193) 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 (91) 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 (232) 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 (92) ORDER BY ssrubr_order ASC
0.0011
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
0.0345
SELECT COUNT(*) AS nbavis FROM note n INNER JOIN util_info dest ON n.dest_util_id=dest.util_id INNER JOIN util_info post ON n.post_util_id=post.util_id INNER JOIN wish w ON n.wish_id=w.wish_id WHERE n.note_visu IN (1,2,3,4) AND n.post_util_id<>'7'
0.0296
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)

88 requetes sql en 0.0916

Taille variable Globale : 83.74 KB