Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Chambre contre service île de france (3 mois)

Annonces similaires

Tout voir
Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE DE LOGEMENT CONTRE SERVICES. (
Profil du voisin
Emma M

Chelles 77500

-- €

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

HéBERGEMENT CONTRE SERVICE., (15 MOIS)
Profil du voisin
Voisin #549552

Paris 75000

-- €

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

HéBERGEMENT CONTRE SERVICE
Profil du voisin
Lynda H

Sannois 95110

400€/m

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE CHAMBRE CONTRE SERVICE (15 MOI
Profil du voisin
Voisin #502699

Antony 92160

-- €

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

LOGEMENT CONTRE SERVICE (INTERGéNéRAT
Profil du voisin
Amy B

Paris 75000

100€

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

LOCATION CONTRE SERVICES
Profil du voisin
Boris S

Saint-Leu-la-Forêt 95320

-- €

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

LOGEMENT CONTRE SERVICES (12 MOIS)
Profil du voisin
Juliette L

Paris 75000

-- €

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

GARDE SENIORS CONTRE LOGEMENT
Profil du voisin
Maria S

Paris 75007

-- €

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

CHERCHE UN LOGEMENT MOMENTANé (6 MOIS)
Profil du voisin
Wassila A

Sevran 93270

50€

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

  3. 0.0001

    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='435463' 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` = 435463

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

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

  32. 0.0001

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

  34. 0

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

  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='435463' AND wish_id<>'574519' 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='93000'

  40. 0.0057

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.9*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9*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.450339197041 AND ville_latitude_deg<49.349660802959 AND ville_longitude_deg>1.7659684337256 AND ville_longitude_deg<3.1340315662744 HAVING distance <= 50 ORDER BY distance ASC

  41. 0.0054

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

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

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

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

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

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

  65. 0.0001

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

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

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

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

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

  82. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 506

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

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

Taille variable Globale : 78.91 KB