Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Recherche hébergement (studio/T2)

Retour Location Logement contre service Location logement contre service entre particuliers (93) Location logement contre service entre particuliers (93)

Discuter

Ce voisin demande à louer à Montreuil (93100)

650€/Faire offre

Prix

650€/Faire offre

Description de l'annonce

Bonjour, je cherche un vrai cocon *** en Île-de-France proche de Paris entre 400/600. Après une période épuisante en colocation. Je viens de valider ma période d'essai, je suis donc en CDI confirmé, même si je n'ai pas encore *** fiches de paie. J'aspire à plus d'indépendance et de stabilité, et je souhaite faire de ce logement mon nid douillet. Je reste à votre disposition pour échanger !
#logement contre service

Annonces similaires

Tout voir
Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE HéBERGEMENT CONTRE SERVICES
Profil du voisin
Eva N

Epinay-sur-Seine 93800

400€

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE D'UNE CHAMBRE D'éTUDIANT
Profil du voisin
Michele B

Créteil 94000

-- €

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

DEMANDE DE LOGEMENT CONTRE SERVICE (12 M
Profil du voisin
Jean arnold M

Trappes 78190

100€

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE LOGEMENT
Profil du voisin
Jean P

Paris 75008

500€/m

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE LOGEMENT
Profil du voisin
Sarah H

Paris 75000

-- €

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

CHAMBRE CONTRE SERVICE PARIS (6 MOIS)
Profil du voisin
Sofia R

Paris 75001

1350€

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

APPARTEMENT CONTRE SERVICES BABY SITTING
Profil du voisin
Marianne M

Paris 75000

-- €

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

CHERCHE LOGEMENT CONTRE SERVICES
Profil du voisin
Ionuț P

Pierrefitte-sur-Seine 93380

100€/m

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

CHERCHE LOGEMENT CONTRE SERVICE
Profil du voisin
Voisin #320099

Paris 75012

-- €

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

LOCATION CONTRE SERVICE
Profil du voisin
Abderraouf A

Paris 75000

-- €

Louer contre service entre particuliers ou proposer contre service 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='625831'

  3. 0

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='logement-contre-service' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='506'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'logement-contre-service' 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='508893' 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` = 508893

  9. 0

    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.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 (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.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.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.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.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 = 625831

  30. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=506 LIMIT 1

  31. 0.0001

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

  32. 0.0001

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

  34. 0

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

  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='508893' AND wish_id<>'625831' 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='93100'

  40. 0.0057

    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

  41. 0.0058

    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 wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='506' AND wish_id<>'625831' 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='506' 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=239398 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 = 239398 AND W.type_id = 1) OR (W.util_id != 239398 AND W.type_id = 2)) AND (`post_util_id` = 239398 OR `dest_util_id` = 239398) 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 = 239398

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

  49. 0.0001

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

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

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

  57. 0.0001

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

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

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

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

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

  73. 0.0001

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

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

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

  82. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 506

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

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

Taille variable Globale : 78.9 KB