Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Logement contre service (4 mois)

Autres annonces du voisin

Tout voir
Service service a personne
Service service a personne
REMORQUAGE DE VOITURE ET CHANGEMENT PNEU
Profil du voisin
Habib N

Thiais 94320

45€/h

Annonces similaires

Tout voir
Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

LOGEMENT CONTRE SERVICE COUPLE AVEC 2 EN
Profil du voisin
Lydia B

Houilles 78800

5000€

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

DEMANDE DE LOGEMENT CONTRE SERVICE
Profil du voisin
Ahmad R

Paris 75012

200€/m

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

CHAMBRE CONTRE SERVICE (4 MOIS)
Profil du voisin
Voisin #29929

Nanterre 92000

920€

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

URGENT : AIDE LOGEMENT CONTRE SERVICE
Profil du voisin
Yulimar del valle G

Paris 75017

-- €

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

HéBERGEMENT CONTRE SERVICES
Profil du voisin
Kimly T

Lilas 93260

-- €

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

CHAMBRE CONTRE SERVICE JARDINAGE
Profil du voisin
Christophe H

Paris 75016

230€/m

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE LOGEMENT CONTRE SERVICE
Profil du voisin
Radha D

Paris 75011

2760€/an

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

CH. CHAMBRE CONTRE SERVICE, GARDIENNAGE
Profil du voisin
Bernard T

Versailles 78000

-- €

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

JE ME PROPOSE DANS L'AIDE à LA PERSONNE
Profil du voisin
Assiya

Paris 75000

-- €

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

CHAMBRE PROCHE PLESSIS-ROBINSON,VERRIERE
Profil du voisin
Isabelle G

Châtenay-Malabry 92290

230€/m

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

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

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

  7. 0.062

    SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='223548' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  8. 0.0001

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 223548

  9. 0.0001

    SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`

  10. 0.0002

    SELECT cate_id as id, cate_title as title, cate_title_slug as slug, fami_id FROM `category` WHERE cate_visu=1 AND fami_id='5' AND cate_cate_id IS NULL ORDER BY cate_order ASC

  11. 0.0004

    SELECT ssrubr_id AS id, ssrubr_title as title, ssrubr_slug as slug, ssrubr_photo, cate_id, fami_id FROM ssrubr WHERE ssrubr_visu=1 AND cate_id IN (87) ORDER BY ssrubr_order ASC

  12. 0.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 (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.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.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 (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.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 (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 = 403872

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

  32. 0.0001

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

  34. 0

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

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

  43. 0.0001

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

  44. 0.0063

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.38333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.317039197041 AND ville_latitude_deg<49.216360802959 AND ville_longitude_deg>1.7011160125509 AND ville_longitude_deg<3.0655439874491 HAVING distance <= 50 ORDER BY distance ASC

  45. 0.0056

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

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

  49. 0.0002

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

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

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

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

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

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

  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=208552 AND note_visu IN (1,3,4)

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

  73. 0.0002

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

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

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

  81. 0.0002

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

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

  83. 0.0001

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

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

  85. 0.0002

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

  86. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 506

  87. 0.001

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

  88. 0

    SELECT count(*) as nbwish FROM wish

  89. 0.0511

    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

89 requetes sql en 0.8683

Taille variable Globale : 79.37 KB