Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Recherche Colocation proche Montreuil

Autres annonces du voisin

Tout voir
Location parking abrite
Location parking abrite
LOCATION PARKING
Profil du voisin
Sylvie F

Montreuil 93100

90€/m

Louer le parking
Location parking en sous sol
Location parking en sous sol
LOCATION EMPLACEMENT DE STATIONNEMENT
Profil du voisin
Sylvie F

Montreuil 93100

90€/m

Louer le parking

Annonces similaires

Tout voir
Location colocation maison
Location colocation maison

Demande il y a + de 30j

Il y a + de 30j

COLOCATION MAISON
Profil du voisin
Claire M

Melun 77000

400€/m

Louer ma chambre
Location colocation maison
Location colocation maison

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE COLOCATION 78
Profil du voisin
José S

Versailles 78000

450€/m

Louer ma chambre
Location colocation maison
Location colocation maison

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE D'UNE LOCATION MAISON MEUBLéE
Profil du voisin
Voisin #359383

Paris 75009

810€

Louer ma chambre
Location colocation maison
Location colocation maison

Demande il y a + de 30j

Il y a + de 30j

CHAMBRE A LOUER
Profil du voisin
Telly D

Villeneuve-la-Garenne 92390

300€/m

Louer ma chambre
Location colocation maison
Location colocation maison

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE CHAMBRE à LOUER EN COLOCATION
Profil du voisin
Bentyaga O

Villiers-sur-Marne 94350

200€/m

Louer ma chambre
Location colocation maison
Location colocation maison

Demande il y a + de 30j

Il y a + de 30j

CHERCHE LOGEMENT CONTRE SERVICES
Profil du voisin
Yakoub B

Bobigny 93000

200€/m

Louer ma chambre
Location colocation maison
Location colocation maison

Demande il y a + de 30j

Il y a + de 30j

LOCATION OU SOUS LOCATION IMMOBILIèRE
Profil du voisin
Baba N

Clamart 92140

-- €

Louer ma chambre
Location colocation maison
Location colocation maison

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE CHAMBRE MEUBLéE
Profil du voisin
Pierre G

Saint-Germain-en-Laye 78100

35€/nuit

Louer ma chambre
Location colocation maison
Location colocation maison

Demande il y a + de 30j

Il y a + de 30j

JE CHERCHE UNE CHAMBRE
Profil du voisin
Yaroslav G Voisin vérifié
4.0 100% fiable

Saint-Gratien 95210

300€/m

Louer ma chambre
4.0 100%
Location colocation maison
Location colocation maison

Demande il y a + de 30j

Il y a + de 30j

CHERCHE UN PETIT STUDIO (12 MOIS)
Profil du voisin
Monir M

Le Blanc-Mesnil 93150

-- €

Louer ma chambre

Louer en colocation entre particuliers ou proposer en colocation 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='240953'

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='colocation-maison' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='503'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'colocation-maison' 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='93'

  7. 0.0001

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

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

  30. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=503 LIMIT 1

  31. 0

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

  32. 0.0001

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

  34. 0

    SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 7005 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 = 7005 AND W.type_id = 1) OR (W.util_id != 7005 AND W.type_id = 2)) AND (`post_util_id` = 7005 OR `dest_util_id` = 7005) 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='7005' AND note_visu IN (1,3,4)

  37. 0

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

  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='7005' AND wish_id<>'240953' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  39. 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='516' LIMIT 0,1

  40. 0.0001

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

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

  42. 0.0002

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

  43. 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='523' LIMIT 0,1

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

  45. 0.0001

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

  46. 0.0001

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

  47. 0.0054

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.43333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.417039197041 AND ville_latitude_deg<49.316360802959 AND ville_longitude_deg>1.7497537413096 AND ville_longitude_deg<3.1169062586904 HAVING distance <= 50 ORDER BY distance ASC

  48. 0.0012

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

  49. 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='503' LIMIT 0,1

  50. 0.0001

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

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

  52. 0.0001

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

  53. 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='503' LIMIT 0,1

  54. 0.0001

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

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

  56. 0.0001

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

  57. 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='503' LIMIT 0,1

  58. 0.0001

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

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

  60. 0.0001

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

  61. 0

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

  62. 0.0001

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

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

  64. 0.0001

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

  65. 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='503' LIMIT 0,1

  66. 0.0001

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

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

  68. 0.0001

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

  69. 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='503' LIMIT 0,1

  70. 0.0001

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

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

  72. 0.0001

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

  73. 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='503' LIMIT 0,1

  74. 0.0001

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

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

  76. 0.0001

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

  77. 0

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

  78. 0.0001

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

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

  80. 0.0001

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

  81. 0

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

  82. 0.0001

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

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

  84. 0.0001

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

  85. 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='503' LIMIT 0,1

  86. 0.0001

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

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

  88. 0.0001

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

  89. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 503

  90. 0.0008

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

  91. 0

    SELECT count(*) as nbwish FROM wish

  92. 0.0472

    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

92 requetes sql en 0.0636

Taille variable Globale : 79.32 KB