Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Demande de logement contre service

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
Profil du voisin
Iolanta I

Nanterre 92000

200€/m

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

CHERCHE SOLUTION D'HéBERGEMENT CHEZ UNE
Profil du voisin
Julie C

Paris 75011

-- €

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

BOUTEILLE à LA MER (2 MOIS)
Profil du voisin
Virginie W

Villers-Saint-Paul 60870

300€

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

AU SECOURS
Profil du voisin
Christian A

Le Port-Marly 78560

-- €

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
Voisin #361234

Houilles 78800

-- €

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

CHAMBRE à LOUER
Profil du voisin
Christophe C

Enghien-les-Bains 95880

225€/m

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

HéBERGEMENT OU LOCATION MODéRé
Profil du voisin
Sylvie

Paris 75000

200€/m

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

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
Danielle L

Saint-Denis 93200

-- €

Location logement contre service
Location logement contre service

Demande il y a + de 30j

Il y a + de 30j

CHERCHE CHAMBRE CONTRE SERVICE
Profil du voisin
Nadjat A

Pantin 93500

-- €

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

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

  7. 0.0001

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

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

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

  32. 0.0001

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

  34. 0

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

  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='330161' AND wish_id<>'495124' 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='94300'

  40. 0.0053

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.85*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.85*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.43333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.400339197041 AND ville_latitude_deg<49.299660802959 AND ville_longitude_deg>1.7499817637462 AND ville_longitude_deg<3.1166782362538 HAVING distance <= 50 ORDER BY distance ASC

  41. 0.0053

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

  45. 0.0002

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

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

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

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

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

  61. 0.0002

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

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

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

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

  73. 0.0001

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

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

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

  82. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 506

  83. 0.0008

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

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

Taille variable Globale : 78.91 KB