Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Logement contre service

Autres annonces du voisin

Tout voir
Déménageur avec fourgon
Déménageur avec fourgon

Demande il y a + de 30j

Il y a + de 30j

PETIT DéMéNAGEMENT
Profil du voisin
Imane E

Pierrefitte-sur-Seine 93380

-- €

Proposer mes services

Annonces similaires

Tout voir
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 #426520

Pavillons-sous-Bois 93320

230€/m

Louer ma chambre
Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

LOGEMENT CONTRE SERVICE
Profil du voisin
Leah V

Paris 75000

-- €

Louer ma chambre
Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

LOGEMENT CONTRE SERVICE
Profil du voisin
Yvon C

Paris 75116

-- €

Louer ma chambre
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
Voisin #285062

Paris 75000

20€/m

Louer ma chambre
Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

SERVICES CONTRE HéBERGEMENT (15 MOIS)
Profil du voisin
Michel B

Paris 75000

50€

Louer ma chambre
Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE COLOCATION CONTRE SERVICES COU
Profil du voisin
Voisin #313835

Paris 75000

300€/m

Louer ma chambre
Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

LOGEMENT CONTRE DIVERS SERVICES
Profil du voisin
Flora F

Maurepas 78310

-- €

Louer ma chambre
Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

LOCATION CONTRE SERVICES (4 MOIS)
Profil du voisin
Xochitl P

Paris 75000

920€

Louer ma chambre
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

-- €

Louer ma chambre
Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

SERVICE CONTRE LOGEMENT
Profil du voisin
Arnaud cedric N

Bagneux 92220

230€/m

Louer ma 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.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='304408'

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

  7. 0.0001

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

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

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

  32. 0.0001

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

  34. 0

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

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

  43. 0.0001

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

  44. 0.0063

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.9667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.36667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.517039197041 AND ville_latitude_deg<49.416360802959 AND ville_longitude_deg>1.6817239280719 AND ville_longitude_deg<3.0516160719281 HAVING distance <= 50 ORDER BY distance ASC

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

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

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

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

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

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

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

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

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

  81. 0.0001

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

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

  85. 0.0001

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

  86. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 506

  87. 0.0009

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

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

Taille variable Globale : 79.38 KB