Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Colocation chambre ou contre service (15 mois)

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€

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

Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

CHERCHE CHAMBRE
Profil du voisin
- -

Cergy 95000

370€/m

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

Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE CHAMBRE à LOUER (12 MOIS)
Profil du voisin
Claire D

Versailles 78000

400€

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

Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE CHAMBRE 3/4 NUITS PAR SEMAINE
Profil du voisin
Clara B

Paris 75000

150€

Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

CHERCHE UN STUDIO
Profil du voisin
Abdel C

Paris 75000

-- €

Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

LOUER UNE CHAMBRE OU STUDIO 5-6 MOIS
Profil du voisin
Aicha yasmine B

Créteil 94000

300€/m

Location chambre en colocation
Location chambre en colocation

Demande il y a + de 30j

Il y a + de 30j

LOCATION DE CHAMBRE
Profil du voisin
Voisin #41647

Créteil 94000

500€/m

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

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

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

  7. 0.0001

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

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

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

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

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

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

  32. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='452106' 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` = 284703 AND util_tel != ''

  34. 0

    SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 284703 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 = 284703 AND W.type_id = 1) OR (W.util_id != 284703 AND W.type_id = 2)) AND (`post_util_id` = 284703 OR `dest_util_id` = 284703) 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='284703' 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 = '452106'

  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='284703' AND wish_id<>'452106' 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='95340'

  40. 0.0085

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49.15*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49.15*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.26667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.700339197041 AND ville_latitude_deg<49.599660802959 AND ville_longitude_deg>1.5791932991832 AND ville_longitude_deg<2.9541467008168 HAVING distance <= 50 ORDER BY distance ASC

  41. 0.0044

    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 (95340,95260,95260,95660,60230,95590,95340,60530,95820,95340,95590,95290,95620,95270,60530,60530,95270,95690,60820,60540,60540,95690,95760,95590,95270,60530,60540,95270,95560,60530,95690,95690,95430,95630,60540,60460,60530,95560,95840,60530,95560,60540,95270,60110,95570,60460,95540,95810,95560,95300,95840,95270,95570,95270,60270,95740,95430,60260,95810,95570,60340,60110,95570,95810,95270,60340,95270,60730,60570,95300,60110,95720,95150,95550,95330,60730,60570,95270,95270,60580,95810,60660,95720,95390,95680,95320,60660,60660,60730,95460,95810,95810,60740,95850,95300,95850,60250,60660,60660,60500,95310,95270,60730,95250,95810,95350,95640,60175,95190,95650,60110,60160,95300,95480,60119,60500,95600,95470,60730,95580,95580,95130,95720,95440,95520,95160,95190,60250,60160,95640,95220,95350,60560,95380,95670,95120,95830,95130,95230,60570,95400,95200,60250,60119,60110,95170,95240,95610,95720,60660,60430,60173,95650,95640,60180,60149,60520,95410,95370,95000,60250,60119,60240,95830,60790,60300,60300,60300,60100,95210,95110,95218,60250,60520,95640,95640,95880,95000,95190,95650,95650,60430,95530,95360,95650,60290,60790,95470,60790,95490,95380,95400,60790,60870,93380,60240,95450,93430,60430,60290,78780,95500,60790,78700,60250,95100,95380,60250,93800,60300,95450,95280,60290,60430,60250,60290,95500,60790,95500,60520,78500,95470,95640,95640,95140,60240,95800,60250,95380,60550,60140,78570,60240,60300,60128,60290,95500,95470,60430,78600,93240,60370,60370,92230,60370,60290,95750,95870,95380,60240,95000,60240,60128,95450,92390,93450,60250,60870,95700,93440,60240,93200,93210,60140,78260,60940,78570,60240,95450,95180,95640,60430,60240,60700,95450,95450,78600,60140,60390,92270,60940,92700,77230,95450,60134,60240,78800,60134,78740,60430,93350,77990,95450,60240,60870,60300,60140,60390,92600,78420,78510,60240,95450,60600,60240,60300,60600,78360,93120,93300,60240,78740,93700,93150,60940,60600,95450,78480,77230,92300,92250,95750,92110,60930,60390,60140,78955,60240,60390,92400,93420,92000,93400,60700,77990,60240,60390,93600,78300,78540,60000,60600,60840,60300,60810,60700,60240,60240,60430,93500,78250,78670,78670,95450,60810,92200,77230,60510,60510,60240,60000,78110,60810,60240,95450,92500,60510,60240,60140,60510,60700,60600,60600,78230,60300,60300,95420,95420,95450,78130,60700,78250,78250,95450,60240,60950,78100,93000,60510,78400,60390,93270,60600,77230,93290,93310,77280,93140,60240,78250,77290,60950,92800,92150,78560,78130,60240,60510,60510,95450,95420,93260,93230,60240,77230,78440,60600,60810,60330,60700,60240,60600,78750,93410,78250,78240,77230,75001,75000,75002,75003,75004,75005,75006,75007,75008,75009,75010,75011,75012,75013,75014,75015,75016,75017,75018,75019,75020,75116,95420,60700,60810,78290,78380,78250,78112,93130,78630,93190,93390,60155,78240,93320,93340,60600,78430,93170,60510,60240,78440,60600,77290,78410,60410,93100,60390,60700,78920,60300,77230,78440,77230,60390,60000,93250,60155,60000,78160,78630,60240,60950,78170,92210,60240,60410,60590,60190,78820,60190,60190,60590,60600,78620,77181,93470,60600,60590,92380,77270,78440,95420,60810,60240,60810,60000,60600,95420,92100,60510,93110,92170,60390,93370,60650,60510,93220,60130,94300,60130,77410,78410,95420,95420,60590,60410,60710,77230,60000,92430,92420,60240,60190,78870,60330,60510,77230,60650,60440,60130,60390,60190,95420,78440,95510,77181,78580,93360,95420,78590,60590,92410,78410,60590,60510,77410,60590,78440,60330,60680,60000,78150,94160,94120,60650,92130,77230,60510,60800,92240,92120,92310,94250,60130,94170,60240,60190,60710,60510,77410,78150,60190,60190,95420,77230,60440,94270,60410,78580,60510,94200,94205,78860,92190,92360,77230,78440,60130,60130,27140,77410,78440,77500,78121,78810,93460,60650,60000,78590,94130,93330,77410,78410,78410,60410,60480,94220,60240,95510,78126,60440,92140,92320,95420,78440,60130,60130,92220,60650,60510,60130,60240,60650,60330,95510,92370,94110,78450,77165,60850,60130,78140,78580,60800,60126,60590,78220,94800,60130,60510,94410,78680,78970,78450,94360,60590,78810,78440,60190,94340,93160,77178,95510,77177,78580,60410,60240,95420,77165,60480,78000,60112,78330,78124,60800,60320,94140,60126,60190,60130,60130,27140,60680,60680,92350,94700,60190,60480,92260,92330,94350,60480,60480,60480,77165,60440,94240,94230,94231,94232,94233,94234,94235,94236,94237,94238,94239,60190,77178,60112,77165,77165,60190,60190,95710,77420,94500,60650,60480,27830,60130,78210,60800,60880,78124,77410,60112,77410,78440,77410,60320,92340,94400,77410,78850,60800,60650,60190,77360,60112,95780,60130,78340,77400,60440,94100,94210,94340,60590,95770,60440,95710,92290,27720,78520,77186,95770,95770,60480,60650,60130,60112,60480,60112,78390,94430,77400,94420,27720,94550,78520,95510,60850,78350,78520,60320,60320,94000,60420,60112,94320,77185,77200,60112,60190,60610,60590,78370,60440,78930,60480,78350,78530,77410,78580,77400,27630,60680,77122,77165,77165,27420,94600,60650,60130,78200,78640,77400,78770,60800,60650,60440,95780,78650,60800,60129,27660,27660,91370,60480,60850,92160,60800,60880,60880,77400,60480,91570,94260,78840,60130,77410,77450,78930,77450,27140,27630,94150,95710,78200,78711,60190,77184,27630,78280,60130,60480,77600,77400,78190,60190,95510,60190,94380,77400,78770,94310,94390,60650,60650,60190,27150,78640,94490,94880,94880,77090,77183,78930,60860,27870,60130,60360,78117,77139,78930,78180,60850,77600,77600,60480,77124,78930,60129,27630,60420,60112,77340,78270,91300,78770,60190,60480,60130,78640,77600,60420,60480,91430,91320,91430,27140,60590,27420,95780,77139,77450,60860,94460,77450,94370,94380,78990,94510,91400,60800,77144,77700,78770,60650,60650,78200,60860,78640,60129,60190,78960,77144,27630,60620,78770,77910,78650,60120,60112,60420,60112,77124,78200,60190,60800,77600,94290,78770,27150,60129,77700,78790,78790,60190,78930,78930,27150,60860,60120,78117,78270,77680,60860,94470,27860,78770,91120,77139,94190,60480,60480,60480,60420,60850,60420,60480,78520,60190,77164,60120,78114,77124,78200,27630,60620,27150,78490,91550,60200,27420,78760,77450,27420,77450,60480,60420,78470,94450,27150,60420,77100,77124,78200,77910,78710,27620,78270,60120,91200,91190,78200,60650,60120,60360,91190,94480,60127,78270,27150,60113,60113,78310,60620,27420,27630,78840,78470,77450,78790,77600,78790,77100,60360,91560,60480) 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<>'452106' 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.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 = 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=413332 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 = 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

  49. 0.0002

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

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

  53. 0.0001

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

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

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

  65. 0.0001

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

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

  69. 0.0001

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

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

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

  77. 0.0001

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

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

  81. 0.0001

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

  82. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 505

  83. 0.0009

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

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

Taille variable Globale : 78.87 KB