Retour
Fermer

›

Lancez votre recherche pour voir les annonces.

Recherche lieu de résidence à louer

Retour Location Chambre en colocation Location chambre en colocation 14 entre particuliers Location chambre en colocation 14 entre particuliers

Discuter

Ce voisin demande à louer à Deauville (14800)

385€/mois

Prix

385€/mois

Description de l'annonce

Mes voisins,
Ma bailleresse, est dans l'obligation de reprendre le lieu que j'habite...(sa maman ayant des problèmes de santé y habitera) retraitée de la région Parisienne, c'est avec plaisir que je désire une résidence sur la côte normande, loyer éligible APL, sans caution. Bien cordialement, Marie.
#chambre en colocation

Autres annonces du voisin

Tout voir
Location studio
Location : studio

Demande il y a + de 30j

Il y a + de 30j • 77680

Recherche lieu de résidence a louer
Profil du voisin
Marie J

Roissy-en-Brie 77680

430€/m

Louer mon studio
Location appartement
Location : appartement

Demande il y a + de 30j

Il y a + de 30j • 77680

Recherche lieu d'habitation
Profil du voisin
Marie J

Roissy-en-Brie 77680

400€/m

Louer mon appartement

Annonces similaires

Tout voir
Location chambre en colocation
Location : chambre en colocation

Demande il y a + de 30j

Il y a + de 30j • 95200

Recherche chambre à  louer
Profil du voisin
Rene B Voisin vérifié

Sarcelles 95200

350€/m

Louer ma chambre
Location chambre en colocation
Location : chambre en colocation

Demande il y a + de 30j

Il y a + de 30j • 92160

Je cherche une chambre à  louer
Profil du voisin
Voisin #79913

Antony 92160

40€/nuit

Louer ma chambre
Location chambre en colocation
Location : chambre en colocation

Demande il y a + de 30j

Il y a + de 30j • 75000

Recherche chambre 3/4 nuits par semaine
Profil du voisin
Clara B

Paris 75000

150€

Louer ma chambre
Location chambre en colocation
Location : chambre en colocation

Demande il y a + de 30j

Il y a + de 30j • 77000

Etudiante recherche colocation (12 mois)
Profil du voisin
Melika L

Melun 77000

100€

Louer ma chambre
Location chambre en colocation
Location : chambre en colocation

Demande il y a + de 30j

Il y a + de 30j • 75013

Cherche une chambre sur paris
Profil du voisin
Laurent S

Paris 75013

300€/m

Louer ma chambre
Location chambre en colocation
Location : chambre en colocation

Demande il y a + de 30j

Il y a + de 30j • 92160

Urgent du 03-11 au 01-12
Profil du voisin
Laura B

Antony 92160

350€/m

Louer ma chambre
Location chambre en colocation
Location : chambre en colocation

Demande il y a + de 30j

Il y a + de 30j • 93000

Demande de location chambre meublée
Profil du voisin
Robert D

Bobigny 93000

180€/m

Louer ma chambre
Location chambre en colocation
Location : chambre en colocation

Demande il y a + de 30j

Il y a + de 30j • 92270

Recherche petite chambre a louer 92
Profil du voisin
Barbara N

Bois-Colombes 92270

200€/m

Louer ma chambre
Location chambre en colocation
Location : chambre en colocation

Demande il y a + de 30j

Il y a + de 30j • 92190

Recherche location appartement
Profil du voisin
Sarah B

Meudon 92190

880€/m

Louer ma chambre
Location chambre en colocation
Location : chambre en colocation

Demande il y a + de 30j

Il y a + de 30j • 60300

Cherche chambre chez l'habitant
Profil du voisin
Jallila K

Senlis 60300

200€/m

Louer ma chambre

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

Poster une annonce

Assistance support Kiwiiz

Comment pouvons-nous vous aider ?

Script : /wiiz-annonce.php
  1. 0.0001

    SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''

  2. 0.0001

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom FROM wish w LEFT JOIN util_info ui ON w.util_id=ui.util_id WHERE wish_id='368354'

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='chambre-en-colocation' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='505'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'chambre-en-colocation' LIMIT 1

  5. 0.0001

    SELECT c.cate_id, 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'

  6. 0.0001

    SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='14'

  7. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='134982' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  8. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 134982

  9. 0.0001

    SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`

  10. 0.0001

    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

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

  12. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (88) ORDER BY ssrubr_order ASC

  13. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (81) ORDER BY ssrubr_order ASC

  14. 0.0002

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (110) ORDER BY ssrubr_order ASC

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

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

  17. 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 (79) ORDER BY ssrubr_order ASC

  18. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (208) ORDER BY ssrubr_order ASC

  19. 0.0001

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (228) ORDER BY ssrubr_order ASC

  20. 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 (207) ORDER BY ssrubr_order ASC

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

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

  23. 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 (83) ORDER BY ssrubr_order ASC

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

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

  26. 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 (91) ORDER BY ssrubr_order ASC

  27. 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 (232) ORDER BY ssrubr_order ASC

  28. 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 (92) ORDER BY ssrubr_order ASC

  29. 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 = 368354

  30. 0.0001

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

  31. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='368354' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')

  32. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 134982 AND util_tel != ''

  33. 0

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

  34. 0.0001

    SELECT M.match_step FROM `match` as M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 134982 AND W.type_id = 1) OR (W.util_id != 134982 AND W.type_id = 2)) AND (`post_util_id` = 134982 OR `dest_util_id` = 134982) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  35. 0.0001

    SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='134982' AND note_visu IN (1,3,4)

  36. 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 = '368354'

  37. 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='134982' AND wish_id<>'368354' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  38. 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='924' LIMIT 0,1

  39. 0.0001

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

  40. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 134982 AND W.type_id = 1) OR (W.util_id != 134982 AND W.type_id = 2)) AND (`post_util_id` = 134982 OR `dest_util_id` = 134982) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  41. 0.0002

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

  42. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1179' LIMIT 0,1

  43. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 134982 AND W.type_id = 1) OR (W.util_id != 134982 AND W.type_id = 2)) AND (`post_util_id` = 134982 OR `dest_util_id` = 134982) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  44. 0.0001

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

  45. 0.0001

    SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='77680'

  46. 0.0054

    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.65- 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.9673332105093 AND ville_longitude_deg<3.3326667894907 HAVING distance <= 50 ORDER BY distance ASC

  47. 0.0034

    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 (77680,77184,77340,77135,77183,77090,77330,77185,77164,94510,77200,77186,77600,94420,77600,77600,77420,77360,77150,94880,94880,94490,77400,77150,77600,77600,94350,93160,77400,77400,77600,94380,94370,77177,77173,77400,93460,77220,94430,94500,77500,93330,77144,94440,94360,77220,77400,77170,94100,94340,94210,94440,77400,77174,77700,94470,77220,77220,77400,93360,94170,93220,77144,77700,94440,93370,94130,77700,94380,77410,77166,77170,77181,94520,94520,94120,94340,77174,94000,93470,77181,77410,77610,77220,94410,93110,77700,94450,93250,91330,94460,77450,93320,93340,93190,93390,77390,77270,91480,77170,77610,77450,91800,77700,91800,94700,77410,77380,93410,77166,91860,77450,93130,77580,94190,77450,77610,94300,77610,77111,77410,94140,93270,91480,94220,77860,91560,77111,93140,77450,94160,94600,93100,77410,93290,93230,93260,77860,93000,91230,94400,77410,93170,94290,77450,77390,77410,94310,77610,94390,77450,77410,93600,77610,94480,77610,94200,94205,77163,77580,77580,77163,94320,77127,77580,77450,77860,93420,91270,77410,77550,77390,93310,91200,77550,77290,77410,77550,94800,93150,93700,77163,94270,77390,77390,77390,93500,91210,91250,77580,77100,91450,77290,94550,77550,77230,77410,93350,94150,91550,91450,77390,77124,77100,77390,91280,94110,77540,77580,94250,77515,94236,94235,94237,94232,94238,94233,94240,94234,94231,94230,94239,75017,75016,75007,75001,75116,75020,75019,75018,75015,75014,75013,75012,75011,75010,75009,75008,75004,75003,75002,75000,75005,75006,77390,93300,93120,91260,77515,77580,77100,91000,91090,91250,77165,93440,91130,91000,77124,77950,77230,77165,77165,95700,91320,77950,77990,95500,77390,77470,92120,91170,77580,77230,92340,77580,77390,91250,77230,77176,94260,95500,95140,77540,95500,91100,77390,77131,77165,77720,92220,77515,93240,93400,92240,91350,91420,77124,92170,95500,77950,77230,93210,93200,77390,77950,77240,77240,77230,92160,77230,77990,77176,77470,77720,91600,91390,77470,77124,95400,77540,77580,92320,77515,92330,92260,95380,77580,91080,93450,92390,91360,77470,77122,95190,77540,77470,77115,93380,77470,77230,91700,91300,77131,77230,77230,92110,91380,91160,77950,92140,77720,91090,77120,92130,77515,92350,95380,77165,91830,91250,91100,91070,77120,92290,77950,91360,93430,77120,91370,77720,95360,95380,77240,77540,77910,95720,92300,77230,95380,92600,92100,77910,92200,77470,95200,95400,92230,77540,77540,77350,77000,77000,91700,77720,77120,77230,92190,92360,95410,93800,77230,77580,91160,95470,77310,95350,77910,91540,91540,77115,91700,95880,77310,91160,91120,95170,92270,91160,95440,77139,95720,92400,77910,92250,77720,91140,92150,92800,77165,95190,77165,77660,77000,77350,77280,77178,77820,91240,77190,60330,91540,77120,91220,91220,77350,92700,92210,77178,95380,95470,91830,77310,95160,77720,77120,91570,60330,95350,95218,95210,91430,77370,91310,91620,95230,92370,92310,95190,77440,91140,95460,77139,91810,95720,77720,91540,95670,77000,77720,77120,60950,77660,95850,91750,92410,77440,95100,91310,91310,60128,91430,77640,95580,95580,77720,95470,78140,77139,92500,77120,77141,77370,60330,92380,95110,95120,95850,91710,92000,91750,95330,91620,95600,77440,95720,92430,92420,95870,60330,77820,91750,60440,78800,77190,77590,60128,95570,78220,77169,77370,77139,95470,78350,91630,60440,91310,91460,95270,77260,77260,77970,95270,77930,91400,95680,77260,91610,95570,77440,77120,91400,77590,95270,95270,77820,91630,78420,77930,95130,77440,77440,91180,95390,77440,77440,77169,78170,95270,91290,91440,60950,77590,60950,77510,77930,91770,95570,95130,91940,78400,95570,78000,77370,95320,77120,91290,78500,60520,78350,78530,60440,91630,60560,77930,77640,95560,91940,77970,78150,78290,78380,95270,60440,95240,78360,95530,77930,77370,91190,77320,91840,77260,77139,77630,77169,95270,77440,95560,91760,91590,77370,91630,78150,60520,77370,95560,78117,91630,60520,77920,77930,95270,78430,95370,77370,91680,95560,77850,91340,91520,95270,60620,91590,77440,91190,91940,78560,91190,78600,77169,91640,95840,91890,77133,78110,60620,60620,91850,95250,77440,77145,60620,60300,60300,77370,95150,95550,60440,77320,78117,77260,77750,60580,91490,78600,77133,60300,77630,95590,77370,91590,77510,77870,77320,95220,77750,78230,77320,91400,77260,78870,77970,91640,60260,77830,78160,95740,91510,91510,91790,95270,95840,78750,91730,60300,77320,78210,95480,60620,77370,78280,91680,78100,91590,91490,91650,78470,95270,77440,78590,77510,77830,77138,77370,91490,77210,60440,78620,78114,77630,60620,95590,77970,78112,95270,60440,60440,77840,77260,91650,78330,60620,77510,78590,77750,91640,77830,95540,77730,78960,60890,91590,60300,78470,77300,60620,77970,60300,77210,91730,91470,77510,95590,91640,78700,77154,91650,77320,77750,91820,77160,91470,91470,60300,60300,91730,91910,78180,91590,78460,77320,77730,77370,95430,95630,77810,77520,60620,95260,77320,77320,77440,77430,91590,77154,91470,60270,60620,77840,91530,77160,91820,95430,60500,77730,60820,78300,60810,78390,60300,95260,60500,60800,77750,91490,78240,60810,78260,78450,95290,60890,91580,78860,95760,95610,02310,77510,91720,91580,78470,91470,60800,95660,91580,78570,91580,91590,95620,95820,02310,60800,77730,77320,78190,78240,77560,95310,95340,77670,60890,77130,77840,91530,77160,77670,78955,78780,95340,91490,02810,60810,91880,78460,60300,60620,60800,60810,60740,91720,77750,91580,77560,77520,78340,95300,78720,60800,95000,02310,60460,60620,77510,78450,77650,91470,60300,77148,02310,77520,77160,60340,77123,77250,60890,02810,78570,77320,77520,78830,77160,77520,60890,77250,60340,77130,95000,95300,02310,78720) 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<>'368354' AND wish_url='' ORDER BY rand() LIMIT 0,10

  48. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1

  49. 0.0001

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

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

  51. 0.0001

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

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

  53. 0.0001

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

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

  55. 0.0001

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

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

  57. 0.0001

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

  58. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 460940 AND W.type_id = 1) OR (W.util_id != 460940 AND W.type_id = 2)) AND (`post_util_id` = 460940 OR `dest_util_id` = 460940) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  59. 0.0001

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

  60. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='505' LIMIT 0,1

  61. 0.0001

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

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

  63. 0.0001

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

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

  65. 0.0001

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

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

  67. 0.0001

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

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

  69. 0.0001

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

  70. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 21498 AND W.type_id = 1) OR (W.util_id != 21498 AND W.type_id = 2)) AND (`post_util_id` = 21498 OR `dest_util_id` = 21498) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  71. 0.0001

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

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

  73. 0.0001

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

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

  75. 0.0001

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

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

  77. 0.0001

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

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

  79. 0.0001

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

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

  81. 0.0001

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

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

  83. 0.0001

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

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

  85. 0.0001

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

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

  87. 0.0001

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

  88. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 505

  89. 0.0009

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

  90. 0

    SELECT count(*) as nbwish FROM wish

  91. 0.0539

    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

91 requetes sql en 0.0728

Taille variable Globale : 79.34 KB