Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Chambre contre service

Annonces similaires

Tout voir
Location logement contre service
Location logement contre service
STUDIO CONTRE TRAVAUX
Profil du voisin
Kettia L

Pantin 93500

-- €

Louer la chambre
Location logement contre service
Location logement contre service
J'éCRIS UN LIVRE ILLUSTRé (9 MOIS)
Profil du voisin
Therese M

Guerard 77580

-- €

Louer la chambre
Location logement contre service
Location logement contre service
COLLOCATION T2 à EPINAY (6 MOIS)
Profil du voisin
Ali C

Epinay-sur-Seine 93800

-- €

Louer la chambre
Location logement contre service
Location logement contre service
LOGEMENT CONTRE SERVICES (4 MOIS)
Profil du voisin
Maurice C

Paris 75000

-- €

Louer la chambre
Location logement contre service
Location logement contre service
LOGEMENT CONTRE SERVICE
Profil du voisin
Karim M

Saint-Cyr-l'École 78210

-- €

Louer la chambre
Location logement contre service
Location logement contre service
ACCOMPAGNER UNE PERSONNE âGéE DE 90 AN
Profil du voisin
Edith M

Noisy-le-Sec 93130

230€/m

Louer la chambre
Location logement contre service
Location logement contre service
HéBERGEMENT GRATUIT
Profil du voisin
Lubin M

Étampes 91150

-- €

Louer la chambre
Location logement contre service
Location logement contre service
OFFRE DE LOGEMENT CONTRE ECHANGE DE SE
Profil du voisin
Marie christine L

Saint-Leu-la-Foret 95320

200€/m

Louer la chambre
Location logement contre service
Location logement contre service
CHAMBRE CONTRE SERVICE
Profil du voisin
Saly M

Paris 75004

-- €

Louer la chambre
Location logement contre service
Location logement contre service
COLOCATION CONTRE SERVICE OU FAIBLE LOYE
Profil du voisin
Voisin #79775

Paris 75001

25€/nuit

Louer la chambre

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

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

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

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

  7. 0.0001

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

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

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

  32. 0.0001

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

  34. 0

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

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

  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='415349' AND wish_id<>'606738' 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='91200'

  40. 0.0057

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.7167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.4- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.267039197041 AND ville_latitude_deg<49.166360802959 AND ville_longitude_deg>1.7184643365919 AND ville_longitude_deg<3.0815356634081 HAVING distance <= 50 ORDER BY distance ASC

  41. 0.0042

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

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

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

  53. 0.0002

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

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

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

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

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

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

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

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

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

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

Taille variable Globale : 78.9 KB