Location ›

Autres

›

Lancez votre recherche pour voir les annonces.

Indiquer un code postal ou une ville

Poster une annonce

Se connecter S'inscrire

i18n

Recherche chambre à louer en journée

Location Chambre en colocation Location chambre en colocation entre particuliers (94)

Discuter

Ce voisin demande à louer à Maisons-Alfort (94700)

40€/j

1 annonce

Prix

40€/j

Description de l'annonce

Nous sommes un couple qui recherchons une chambre à louer entre 12h et 14h proche du rer d maisons alfort-alfortville/metro ligne 8 maisons alfort les juliottes/metro ligne 8 maisons alfort ecole veterinaire/charenton #chambre en colocation

Annonces similaires

Tout voir

Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

CHERCHE CHAMBRE à LOUER

Voisin #110148

Saint-Cyr-l'École 78210

415€/^m

Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

JE RECHERCHE UNE CHAMBRE CHEZ L'HABITANT

Sonia L

Meaux 77100

240€/^sem

Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

CHERCHE CHAMBRE à LOUER CHEZ L'HABITA

Voisin #73565

Paris 75017

35€/^nuit

Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

CHERCHE LOCATION

Monique M

Ville-d'Avray 92410

405€/^m

5.0

Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

ITALIENNE CHERCHE CHAMBRE GRATUITE

Mima D

Paris 75001

-- €

Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

BESOIN D'UN LOGEMENT SPORTIVE DE HAUT NI

Albane P

Suresnes 92150

150€

Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

CHERCHE CHAMBRE MEUBLéE à LOUER URGE

Marlyse Y

Paris 17 75017

600€/^m

Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

CHERCHE COLOCATION

Ny farantsa R

Massy 91300

325€/^m

Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE LOCATION OU COLOCATION URGENT

Vilaine G

Sarcelles 95200

370€/^m

Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

CHERCHE. CHAMBRE à LOUER

Nathalie T

Villejuif 94800

395€/^m

Louer une chambre entre particuliers ou proposer une chambre en location.

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='263598'
0.0001
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='chambre-en-colocation' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='505'
0.0001
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'chambre-en-colocation' 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='94'
0.0001
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='45643' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
0
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 45643
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.0004
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.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 (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.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 (176) 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 (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.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 (93) 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 (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.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 = 263598
0
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=505 LIMIT 1
0.0001
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='263598'
0.0001
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='263598' 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` = 45643 AND util_tel != ''
0
SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 45643 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''
0.0002
SELECT M.match_step FROM `match` as M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 45643 AND W.type_id = 1) OR (W.util_id != 45643 AND W.type_id = 2)) AND (`post_util_id` = 45643 OR `dest_util_id` = 45643) 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='45643' 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 = '263598'
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='45643' AND wish_id<>'263598' 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='94700'
0.0083
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.43333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.350339197041 AND ville_latitude_deg<49.249660802959 AND ville_longitude_deg>1.7506632105093 AND ville_longitude_deg<3.1159967894907 HAVING distance <= 50 ORDER BY distance ASC
0.0046
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 (94700,94140,94220,94410,94000,94340,94400,94160,94600,94200,94205,94800,94340,94100,94210,94130,94380,94320,94270,94300,94460,94390,94310,94430,94500,94120,94550,94360,94110,94170,93100,94290,94190,93170,94250,94235,94240,94230,94231,94232,94233,94239,94238,94234,94236,94237,94380,94370,94470,94150,93110,94450,92120,94490,94880,94880,92340,93330,93230,93260,94350,75116,75020,75019,75013,75016,75018,75017,75014,75015,75012,75011,75000,75007,75008,75009,75005,75004,75006,75003,75010,75001,75002,94480,91560,91200,93310,93130,93360,92220,94420,92240,94260,91320,92170,91330,91550,93250,92320,92330,92260,94510,93000,91270,91230,93160,92160,94440,93500,93140,93220,94440,91800,92140,93460,92130,92350,77340,93340,93320,92290,91210,91300,93400,91420,77420,91370,94440,91260,93300,93120,77184,77185,92100,94520,94520,92190,92360,91860,77170,93370,92110,91160,91380,93150,93700,93350,91800,91170,92200,77500,77150,93390,93190,92300,77186,93210,93200,77680,91390,91600,91120,92150,92800,91480,92600,77150,91160,93450,92210,93270,92390,91360,91480,91450,93440,91130,91000,77200,91570,93470,77181,93240,91350,92370,92400,91360,92310,77177,92250,91140,77183,77090,77330,77360,91430,92230,93410,77380,93600,92270,91160,92410,78140,91160,95500,91000,91090,95140,91430,77181,92700,77170,91450,93430,92380,93800,77600,93380,91250,91700,92420,92430,91700,92500,77173,95360,78220,77135,91140,77400,78350,93420,91700,77270,77164,93290,77600,77600,92000,95880,95500,77127,95400,77410,77400,91080,91620,91070,91250,77400,91400,91240,91280,95410,95100,91400,78800,78170,77166,95210,95218,91310,95170,95870,77600,77166,78000,77400,91220,91220,91310,91310,91620,91090,78530,78350,95500,78420,91440,91100,95200,95400,95500,95230,78400,77400,78150,91250,95350,95110,95700,78380,78290,77220,77600,95160,91940,77600,78150,77400,91460,95120,77550,77400,91190,78117,95720,91100,95190,95580,95580,77144,78430,95440,77290,91310,78360,77410,91940,77170,78500,77111,95600,95350,78560,91190,77220,95130,77410,77220,78117,91940,91190,77410,78110,77220,91540,91540,95720,91180,77550,77176,95530,91540,77700,77144,77700,78870,95380,95460,91810,91250,91830,95680,77410,95240,78600,77390,95130,77550,91640,77111,78160,78230,78210,77220,77410,77174,95330,95390,77990,91290,78600,78280,78750,95380,91630,95370,78590,77550,91400,95320,91290,77450,91630,95190,78620,78114,95720,91540,78100,77450,78470,77290,91680,78330,77990,77176,77410,91710,78590,77700,78112,95570,78960,91630,77240,95380,95570,91340,91520,77700,77700,78470,95380,77240,91640,91630,77240,77174,95570,95250,77230,78180,77610,77950,95220,77230,77410,77390,95850,91750,95190,95720,77230,95380,91830,77390,77450,78460,77610,77610,95560,91630,95550,95150,91680,78390,91770,77410,91470,77410,77390,77450,91470,91610,78450,77310,95560,95840,77230,91640,91470,95480,78860,77950,77950,95560,95470,77310,78240,77450,77580,78470,95850,95270,91750,77450,95270,77450,78300,77230,78700,77950,91650,78190,91470,77860,95670,95570,95740,77450,91790,77230,77390,91640,77610,91760,77390,77230,78240,91650,77230,78260,77230,95560,91470,77410,95470,77310,91850,77165,78340,77860,95840,91730,77350,78460,77230,95590,77350,95270,95270,78450,95270,91530,95470,91650,78720,77610,78570,78955,91750,91510,91510,77165,77165,91590,95270,77390,77950,95540,77000,77000,77165,77610,95610,77350,77230,95470,78720,77610,77390,77860,78780,91910,91730,77190,77580,77580,78810,77100,78320,60128,95270,77390,95270,91590,91730,95270,77580,78630,78370,78990,77163,78720,77950,95430,77124,77163,78570,78830,91590,77100,78670,95430,95630,78670,77124,78320,77390,77390,95000,77720,91470,77230,95310,91580,77930,91530,77280,77000,77115,95590,77580,78320,77163,77390,95300,77230,77930,60330,91890,77100,91840,60128,77190,78720,95000,77165,78810,91530,95270,91590,95760,77000,91580,60560,77930,95270,78510,77124,77115,78121,78540,78830,95270,60520,95280,77122,60950,78310,91590,77390,95290,91580,77720,78850,77580,78310,77720,95590,95300,77930,95620,95260,77540,77930,91590,91580,77124,78480,77470,60260,91490,60580,95260,60330,95490,77580,78640,77515,78760,91580,91410,78640,91530,77515,77580,95660,91580,78630,77540,91590,77580,95000,77720,60520,77930,95300,78580,95520,77178,78720,77820,77720,78690,77590,78640,60520,91590,77470,78690,91820,77910,95340,77910,95180,77178,77630,91490,91490,78730,78730,95800,77131,77470,78130,77470,91820,77540,77165,77165,60820,95650,60330,95300,77470,78920,95690,95650,77540,77515,78640,78490,95650,95820,91410,78580,78740,78610,78650,60950,77139,77590,95340,91880,77630,77720,77580,77470,95690,77580,78124,91150,91410,60270,91720,77515,78740,60330,78490,78490,77910,77820,77590,60230,78124,60950,78410,78125,77131,95690,77540,77470,77540,95810,95340,78120,95450,78130,77910,60440,78490,77120,77515,60530,78580,77630,95690,78650,77120,77720,78610,95810,77120,77139,78490,60500,91490,78580,91720,60500,95650,60440,95650,60300,60300,91150,60460,78250,77139,78250,95450,77540,78730,77720,60300,60300,77720,91870,78126,78490,78490,77820,91410,77580,78770,77920,78410,95450,77120,60530,60440,78770,91150,77660,60300,77440,78250,91410,77720,60300,95810,77850,78770,77139,60530,91150,78730,78250,60300,60740,60340,78490,60340,78490,95810,91490,78410,95830,60440,78610,77370,78770,60440,78250,60300,78770,78410,78410,78120,77370,95450,78120,60530,91720,60540,60540,95810,77440,60460,95830,77133,77870,60530,77660,77120,91720,95450,77370,77440,77120,78730,91150,78680,77440,78820,78770,60300,95450,77123,60300,60300,77210,60540,91150,77300,77640,91410,77133,78940,91410,95450,78490,91780,91780,95810,91150,77210,77120,60530,78660,78580,60810,60540,95640,77141,91720,78770,60440,78610,78970,78250,60530) AND fami_id='5' AND cate_id='193' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='505' AND wish_id<>'263598' 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='505' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=110148 AND note_visu IN (1,3,4)
0.0002
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 110148 AND W.type_id = 1) OR (W.util_id != 110148 AND W.type_id = 2)) AND (`post_util_id` = 110148 OR `dest_util_id` = 110148) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0003
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 110148
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='505' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=174468 AND note_visu IN (1,3,4)
0.0002
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 174468 AND W.type_id = 1) OR (W.util_id != 174468 AND W.type_id = 2)) AND (`post_util_id` = 174468 OR `dest_util_id` = 174468) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0003
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 174468
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='505' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=73565 AND note_visu IN (1,3,4)
0.0002
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 73565 AND W.type_id = 1) OR (W.util_id != 73565 AND W.type_id = 2)) AND (`post_util_id` = 73565 OR `dest_util_id` = 73565) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0003
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 73565
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='505' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=125280 AND note_visu IN (1,3,4)
0.0002
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 125280 AND W.type_id = 1) OR (W.util_id != 125280 AND W.type_id = 2)) AND (`post_util_id` = 125280 OR `dest_util_id` = 125280) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0003
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 125280
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='505' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=482153 AND note_visu IN (1,3,4)
0.0002
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 482153 AND W.type_id = 1) OR (W.util_id != 482153 AND W.type_id = 2)) AND (`post_util_id` = 482153 OR `dest_util_id` = 482153) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0003
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 482153
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='505' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=438116 AND note_visu IN (1,3,4)
0.0002
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 438116 AND W.type_id = 1) OR (W.util_id != 438116 AND W.type_id = 2)) AND (`post_util_id` = 438116 OR `dest_util_id` = 438116) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0003
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 438116
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='505' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=37614 AND note_visu IN (1,3,4)
0.0002
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 37614 AND W.type_id = 1) OR (W.util_id != 37614 AND W.type_id = 2)) AND (`post_util_id` = 37614 OR `dest_util_id` = 37614) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0003
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 37614
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='505' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=4444 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 = 4444 AND W.type_id = 1) OR (W.util_id != 4444 AND W.type_id = 2)) AND (`post_util_id` = 4444 OR `dest_util_id` = 4444) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0003
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 4444
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='505' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=333776 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 = 333776 AND W.type_id = 1) OR (W.util_id != 333776 AND W.type_id = 2)) AND (`post_util_id` = 333776 OR `dest_util_id` = 333776) 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 = 333776
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='505' LIMIT 0,1
0.0001
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=142488 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 = 142488 AND W.type_id = 1) OR (W.util_id != 142488 AND W.type_id = 2)) AND (`post_util_id` = 142488 OR `dest_util_id` = 142488) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
0.0003
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 142488
0.0001
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 505
0.0017
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.0718
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

85 requetes sql en 0.0988

Taille variable Globale : 78.88 KB