Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Urgent logement contre service ou loyer modér

Annonces similaires

Tout voir
Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

APPARTEMENT CONTRE SERVICES BABY SITTING
Profil du voisin
Marianne M

Paris 75000

-- €

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

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

APPARTEMENT
Profil du voisin
Lucie O

Trappes 78190

-- €

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

CHERCHE HEBERGEMENT (8 MOIS)
Profil du voisin
Kaleejah K

Ulis 91940

200€

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE COLOCATION CONTRE SERVICES
Profil du voisin
Marie rose L

Villejuif 94800

-- €

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

ETUDIANTE RECHERCHE UN LOGEMENT/CHAMBRE
Profil du voisin
Ella K

Paris 75013

100€/m

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

BILINGUE ANGLAISE: TRAVAIL NOURRIE LOGER
Profil du voisin
Veronica M

Paris 75000

15€/h

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
Flaubert M

Wissous 91320

100€/m

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

ETUDIANT: CHAMBRE+SALAIRE GARDE D'ENFANT
Profil du voisin
Marie-luce G

Paris 75006

-- €

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
Iolanta I

Nanterre 92000

200€/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.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='624249'

  3. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'logement-contre-service' LIMIT 1

  4. 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'

  5. 0.0001

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

  6. 0.0001

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

  7. 0

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

  8. 0

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

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

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

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

  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 (81) 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 (110) 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 (227) 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 (176) 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 (79) 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 (208) 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 (228) 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 (207) 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 (95) ORDER BY ssrubr_order ASC

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

  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 (83) 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 (93) 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 (193) 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 (91) 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 (232) 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 (92) ORDER BY ssrubr_order ASC

  28. 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 = 624249

  29. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=506 LIMIT 1

  30. 0.0001

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

  31. 0.0001

    SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='624249' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')

  32. 0

    SELECT `util_tel` FROM `util_info` WHERE `util_id` = 505737 AND util_tel != ''

  33. 0

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

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

  35. 0.0001

    SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='505737' AND note_visu IN (1,3,4)

  36. 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 = '624249'

  37. 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='505737' AND wish_id<>'624249' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  38. 0.0001

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

  39. 0.0055

    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.4- 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.7159684337256 AND ville_longitude_deg<3.0840315662744 HAVING distance <= 50 ORDER BY distance ASC

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

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

  42. 0.0001

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

  43. 0.0001

    SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 17816 AND W.type_id = 1) OR (W.util_id != 17816 AND W.type_id = 2)) AND (`post_util_id` = 17816 OR `dest_util_id` = 17816) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  44. 0.0002

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

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

  46. 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)

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

  48. 0.0001

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

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

  50. 0.0001

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

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

  52. 0.0001

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

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

  54. 0.0001

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

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

  56. 0.0002

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

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

  58. 0.0001

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

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

  60. 0.0001

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

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

  62. 0.0001

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

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

  64. 0.0001

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

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

  66. 0.0001

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

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

  68. 0.0001

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

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

  70. 0.0001

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

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

  72. 0.0001

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

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

  74. 0.0001

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

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

  76. 0.0001

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

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

  78. 0.0001

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

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

  80. 0.0001

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

  81. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 506

  82. 0.0009

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

  83. 0

    SELECT count(*) as nbwish FROM wish

  84. 0.0498

    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

84 requetes sql en 0.0706

Taille variable Globale : 78.87 KB