Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Recherche Logement

Annonces similaires

Tout voir
Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

HéBERGEMENT POUR STAGE (3 SEMAINES)
Profil du voisin
Albane A

Bobigny 93000

450€

Louer ma chambre
Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE UNE CHAMBRE EN COLOCATION
Profil du voisin
Eddy M

Bagneux 92220

350€/m

Louer ma chambre
Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

CHERCHE COLOCATION
Profil du voisin
Ny farantsa R

Massy 91300

325€/m

Louer ma chambre
Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

CHERCHE CHAMBRESà LOUER
Profil du voisin
Mamadou M

Clichy 92110

300€/m

Louer ma chambre
Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

ITALIENNE CHERCHE CHAMBRE GRATUITE
Profil du voisin
Mima D

Paris 75001

-- €

Louer ma chambre
Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE URGENTE LOCATION STUDIO NON ME
Profil du voisin
Annick Y Voisin vérifié
1.0

Paris 75004

600€

Louer ma chambre
1.0
Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE CHAMBRE PARIS (3 MOIS)
Profil du voisin
Voisin #392336

Paris 75015

500€

Louer ma chambre
Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

CHAMBRE à LOUER OU COLOCATION (3 MOIS)
Profil du voisin
Abdelkader M

Nanterre 92000

350€

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
Isabelle M

Nanteuil-le-Haudouin 60440

380€/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 à LOUER CHEZ L'HABITANT
Profil du voisin
Philippe M

La Ferté-sous-Jouarre 77260

320€/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='588987'

  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='93'

  7. 0.0001

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

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

  30. 0

    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='588987'

  32. 0.0001

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

  33. 0

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

  34. 0

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

  35. 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 = 453865 AND W.type_id = 1) OR (W.util_id != 453865 AND W.type_id = 2)) AND (`post_util_id` = 453865 OR `dest_util_id` = 453865) 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='453865' 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 = '588987'

  38. 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='453865' AND wish_id<>'588987' 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='93150'

  40. 0.0062

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.9333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9333*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.483639197041 AND ville_latitude_deg<49.382960802959 AND ville_longitude_deg>1.7655122878414 AND ville_longitude_deg<3.1344877121586 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 (93700,93150,93350,93440,93000,93140,95500,95140,93500,93120,93300,93240,93600,95500,93260,93230,93130,95400,93270,93320,93340,93310,93250,93200,93210,93380,93420,93100,95500,93190,93390,93170,93110,95500,95360,93220,93430,92390,93450,93410,93360,95400,95200,95700,95410,93400,93370,94300,95720,95190,93290,94120,95350,77181,93470,94170,95170,95880,95440,93800,92230,93330,75001,75000,75002,75003,75004,75005,75006,75007,75008,75009,75010,75011,75012,75013,75014,75015,75016,75017,75018,75019,75020,75116,95160,93460,94160,95720,94130,92110,95380,95350,94360,77270,92600,95230,77500,77181,93160,95460,95210,95218,92300,95190,94410,94340,94220,95580,95580,95380,94350,77290,95720,92270,94200,94205,94500,95330,95600,94270,95380,77990,77420,95120,92200,77177,95100,92700,77410,77990,95190,94700,95850,95570,95380,92400,94140,95380,95110,92250,95720,94100,94210,94340,95680,94250,95570,94420,94430,92170,94800,92120,77410,95390,77186,77360,77185,95850,94000,95130,95270,95570,92240,95870,94400,95670,94110,95470,95320,77200,95270,77230,95130,77290,92800,92150,95560,95570,77230,77184,77400,94490,94880,94880,77230,77410,78800,92100,95560,77230,92220,95270,95270,95270,77400,77410,92000,95560,92130,94600,94380,95470,95470,94240,94230,94231,94232,94233,94234,94235,94236,94237,94238,94239,77340,95240,77410,92500,94320,92320,95560,94510,77090,77183,77600,94370,94380,95840,78500,78420,77410,77230,77400,95530,77400,92210,94550,95270,95470,92140,92340,95370,77400,95150,95550,94460,95270,77230,95250,77600,77600,95270,92190,92360,95590,92260,92330,77410,94310,94390,95270,77680,77400,60128,94470,77230,95740,92350,77230,77600,77400,77230,94150,95840,95220,78360,78600,92380,94190,94290,94450,92410,77164,92310,94260,78400,95480,77230,60560,77600,92290,92430,92420,95270,60520,95590,60128,77144,92160,77450,95270,94440,77410,95540,92370,77135,78600,77144,77700,78170,95270,91320,77280,91560,60260,60580,94480,77230,77165,78290,78380,77410,91200,91330,77330,91370,77410,77230,78140,77600,78110,77450,95430,95630,60330,95590,91550,94440,77165,77410,78560,60950,60520,95260,91300,77150,95430,77165,77165,78430,78220,94440,77450,95290,78230,77700,95260,91230,77150,60520,77170,95760,91270,77700,78700,91800,77230,95620,91570,95660,78150,77450,78150,94520,94520,60820,78100,77450,95610,91420,78750,78000,60330,95340,95310,95820,78350,78160,77700,77165,60270,91210,91430,77450,95340,91380,91160,91120,91260,91860,78260,77450,78870,91800,78570,78112,77450,95300,77174,60950,91430,77124,77173,78780,78620,77700,91160,78300,95000,77122,91480,78590,95300,77178,95690,95300,60330,78350,78530,60500,60500,60230,77860,91140,91170,95000,77580,60460,60300,60300,91480,60530,77170,60950,91400,77220,77100,78955,77100,77124,91390,91600,77178,77220,78240,91360,77380,91160,77174,78570,77124,77860,95340,60300,60300,95690,60300,91360,78590,91450,60740,95300,60330,91000,91130,60530,60340,95520,78210,60340,95690,95280,78117,78240,91350,77860,77165,77165,60300,78330,91140,77166,91160,77220,77124,95490,91400,60530,60300,95690,95650,77220,77100,60460,78670,78670,95810,77910,60530,78860,60440,60300,91440,78510,91700,91090,91000,91450,91190,77139,91250,78450,78280,77610,77910,60300,77580,77580,60300,77166,60530,60300,95650,60440,91700,78117,60440,95000,78630,77127,95650,60540,60540,91620,78540,91190,91700,77580,78480,77580,95810,95800,60440,91940,77220,77170,77139,78390,95810,60530,91240,60160,60540,60810,91620,91250,95180,78450,77470,91080,91280,60660,77390,77470,77580,91310,91070,60440,78180,78960,78114,77610,77111,77163,91310,91310,77910,78810,91940,91940,91190,60540,60810,60530,60810,78740,78340,77470,91220,91220,60700,77470,95810,77610,77580,78470,95650,95650,77550,95810,78190,60440,91460,77139,77111,60160,60180,77139,91090,91100,60100,91250,77910,78470,77610,60660,60660,60540,60660,60660,77580,95830,78740,77163,60110,95810,78630,77470,95450,78130,77163,91310,95450,78121,60110,91400,91640,78810,77550,95830,95450,77610,78470,78370,91100,78920,60870,77470,78580,77470,77550,60440,60800,78460,77390,77550,77440,60550,60810,60810,95810,78130,95640,95450,77610,77176,91180,77440,60440,77580,77515,78250,77610,78850,60250,78990,95640,60730,78410,91470,95450,60800,60110,77580,77390,60620,60800,60730,60290,91540,91540,60810,60290,60570,78250,91470,77390,77580,60620,91540,91250,91830,60660,60870,91290,78250,95450,77139,91810,60730,91680,91470,60870,77660,91640,78580,60119,91290,60250,95640,77390,60620,78640,77440,78320,77390,95640,60570,60810,78320,60700,91630,77176,78250,78720,60620,77440,77950,77515,78460,60700,78250,91630,77240,78640,60410,91520,91340,77240,78720,78580,60290,60140,95640,95640,60175,77540,78410,77660,77440,78124,95640,91540,77580,60940,95450,91640,77515,60940,91630,60730,78124,60240,77950,91470,91710,91680,77390,78310,60250,60940,77240,60730,60700,60119,91630,78640,77515,95450,60620,60110,60800,78760,91470,77440,77440,77390,78650,77120,60620,60250,77950,60800,78320,78126,77390,78580,95450,60620,78410,95450,60700,78310,78720,60410,77950,91640,78820,77440,77440,60290,91750,60140,91830,78640,77120,60119,60290,60140,60410,91630,95640,77131,95450,77310,77640,95450,77145,78410,78410,60173,60800,60800,78250,91650,77390,91770,77310,91610,77390,78440,60800,60410,95450,95750,60620,91650,77540,77390,78490,77515,60320,91790,91530,77390,78720,78690,60570,60620,78680,77260,77260,91750,60140,60240,77440,77950,77720,95450,60149,78650,77350,60290,60140,60110,77120,78830,77720,78770,60250,60800,60250,60620,78440,78440,60430,60410,91650,78770,60700,78690,60620,78490,78490,78490,77540,77131,60250,91760,77310,60800,60129,91730,77000,77000,78440,77350,60410,77950,60790,77260,60890,77115,60250,60700,78970,91850,78770,60620,95750,60700,60790,77350,60240,60620,77840,91470,60430,78770,77120,60117,60600,60250,78830,91510,91510,77540,91750,77440,78770,77190,77120,77120,60140,78440,60710,91910,91730,60790,95420,78440,91590,60320,60320,78580,60240,60790,77720,77720,78610,60250,77540,77540,60320,95420,95450,60240,91530,77440,78440,78490,78490,60240,78490,78770,60710,60129,60890,91730,77000,60240,91530,78490,78440,78720,60430,91580,77115,60790,60370,60240,60430,60240,78490,60890,78930,77640,77260,78930,60190) 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<>'588987' 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=50775 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 = 50775 AND W.type_id = 1) OR (W.util_id != 50775 AND W.type_id = 2)) AND (`post_util_id` = 50775 OR `dest_util_id` = 50775) 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 = 50775

  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=19343 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 = 19343 AND W.type_id = 1) OR (W.util_id != 19343 AND W.type_id = 2)) AND (`post_util_id` = 19343 OR `dest_util_id` = 19343) 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 = 19343

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

  53. 0.0002

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

  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=317426 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 = 317426 AND W.type_id = 1) OR (W.util_id != 317426 AND W.type_id = 2)) AND (`post_util_id` = 317426 OR `dest_util_id` = 317426) 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 = 317426

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

  61. 0.0002

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

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

  65. 0.0002

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

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

  69. 0.0002

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

  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=333328 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 = 333328 AND W.type_id = 1) OR (W.util_id != 333328 AND W.type_id = 2)) AND (`post_util_id` = 333328 OR `dest_util_id` = 333328) 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 = 333328

  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=216520 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 = 216520 AND W.type_id = 1) OR (W.util_id != 216520 AND W.type_id = 2)) AND (`post_util_id` = 216520 OR `dest_util_id` = 216520) 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 = 216520

  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=224066 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 = 224066 AND W.type_id = 1) OR (W.util_id != 224066 AND W.type_id = 2)) AND (`post_util_id` = 224066 OR `dest_util_id` = 224066) 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 = 224066

  82. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 505

  83. 0.0008

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

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

Taille variable Globale : 78.88 KB