Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Recherche location de chambre

Annonces similaires

Tout voir
Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE UNE CHAMBRE à LOUER
Profil du voisin
Marguerite elong N

Saint-Denis 93210

370€/m

Louer ma chambre
Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE CHAMBRE à  PROXIMITé DE PAR
Profil du voisin
Voisin #46807

Paris 14 75014

350€/m

Louer ma chambre
Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

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

RECHERCHE CHAMBRE POUR éTUDIER à LA SO
Profil du voisin
Amarine C

Paris 75013

370€/m

Louer ma chambre
Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

CHERCHE CHAMBRE
Profil du voisin
Marie M

Herblay 95220

200€/m

Louer ma chambre
Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

JE RECHERCHE UNE COLOCATION
Profil du voisin
Thomas G

Magny-les-Hameaux 78114

580€/m

Louer ma chambre
Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

CHERCHE LOGEMENT TEMPORAIRE
Profil du voisin
Clarisse B

Paris 75012

150€/sem

Louer ma chambre
Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE D'UNE LOCATION POUR éTUDIANT
Profil du voisin
Emmanuel D

Asnières-sur-Seine 92600

380€

Louer ma chambre
Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE D'UNE CHAMBRE A LOUER
Profil du voisin
Sia M

Sartrouville 78500

47€/nuit

Louer ma chambre
Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

DEMANDE CHAMBRE à  LOUER (éTUDIANT)
Profil du voisin
Voisin #73360

Créteil 94000

350€/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='272494'

  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, 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'

  6. 0

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

  7. 0.0001

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='57528' 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` = 57528

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

  11. 0.0005

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

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

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

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

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

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

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

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

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

  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 = 272494

  30. 0.0001

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=505 LIMIT 1

  31. 0.0001

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

  32. 0.0001

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

  33. 0.0001

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

  34. 0.0001

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

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

  36. 0.0001

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

  37. 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 = '272494'

  38. 0.0002

    SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish w INNER JOIN util_info ui ON w.util_id = ui.util_id WHERE wish_visu IN (1,6,10) AND w.util_id='57528' AND wish_id<>'272494' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  39. 0.0001

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

  40. 0.0072

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.6333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.6333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.45- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.183639197041 AND ville_latitude_deg<49.082960802959 AND ville_longitude_deg>1.7695916332696 AND ville_longitude_deg<3.1304083667304 HAVING distance <= 50 ORDER BY distance ASC

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

  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='505' LIMIT 0,1

  43. 0.0001

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

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

  45. 0.0002

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

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

  47. 0.0001

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

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

  49. 0.0002

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

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

  51. 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)

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

  53. 0.0002

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

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

  55. 0.0001

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

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

  57. 0.0002

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

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

  59. 0.0001

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

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

  61. 0.0001

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

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

  63. 0.0001

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

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

  65. 0.0001

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

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

  67. 0.0001

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

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

  69. 0.0001

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

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

  71. 0.0001

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

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

  73. 0.0002

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

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

  75. 0.0001

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

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

  77. 0.0002

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

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

  79. 0.0001

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

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

  81. 0.0002

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

  82. 0.0001

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 505

  83. 0.0016

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

  84. 0

    SELECT count(*) as nbwish FROM wish

  85. 0.0597

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

Taille variable Globale : 78.82 KB