Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Appartement ou maison pour 3jours (mariage)

Annonces similaires

Tout voir
Location chambre en colocation
Location chambre en colocation
CHAMBRE à OCCUPER GRATUITEMENT
Profil du voisin
Noelle E

Viry-Chatillon 91170

-- €

Louer la chambre
Location chambre en colocation
Location chambre en colocation
CHAMBRE MEUBLéE éQUIPéE +SDB PRIVéE
Profil du voisin
Isabel G

Villepinte 93420

-- €

Louer la chambre
Location chambre en colocation
Location chambre en colocation
CO-LOCATION TEMPORAIRE
Profil du voisin
Ted T

Paris 75000

175€/sem

Louer la chambre
Location chambre en colocation
Location chambre en colocation
LOGEMENT GRATUIT CONTRE GARDE D'ENFANTS
Profil du voisin
Voisin #321950

Plaisir 78370

370€/m

Louer la chambre
Location chambre en colocation
Location chambre en colocation
LOCATION CHAMBRE
Profil du voisin
Abdel M

Franconville 95130

370€/m

Louer la chambre
Location chambre en colocation
Location chambre en colocation
CHAMBRE CHEZ L’HABITANT PRèS DE TOUR
Profil du voisin
Mahmoud R

Paris 75015

100€/nuit

Louer la chambre
Location chambre en colocation
Location chambre en colocation
CHAMBRE à LOUER LA NUIT
Profil du voisin
Kim stephenjy R

Fresnes 94260

60€/nuit

Louer la chambre
Location chambre en colocation
Location chambre en colocation
LOCATION CHAMBRE DANS UN APPARTEMENT.
Profil du voisin
Voisin #133934

Sevran 93270

450€/m

Louer la chambre
Location chambre en colocation
Location chambre en colocation
CHAMBRE à LOUéE à LA JOURNéE (92)
Profil du voisin
Sohail G

Le Plessis-Robinson 92350

50€/j

Louer la chambre
Location chambre en colocation
Location chambre en colocation
JE LOUE MON APPARTEMENT
Profil du voisin
Élysée Z

Goussainville 95190

72€/nuit

Louer la chambre

Louer une chambre entre particuliers ou proposer une chambre 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='630375'

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='chambre-en-colocation' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='505'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'chambre-en-colocation' 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='92'

  7. 0.0001

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

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

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

  12. 0.0002

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

  13. 0.0002

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

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

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

  23. 0.0001

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

  24. 0.0001

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

  25. 0.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 = 630375

  30. 0.0001

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=505 LIMIT 1

  31. 0.0001

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

  32. 0.0001

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

  33. 0.0001

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

  34. 0

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

  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='517413' AND wish_id<>'630375' 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='92500'

  40. 0.006

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.2- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.433639197041 AND ville_latitude_deg<49.332960802959 AND ville_longitude_deg>1.5161968758251 AND ville_longitude_deg<2.8838031241749 HAVING distance <= 50 ORDER BY distance ASC

  41. 0.003

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

  45. 0.0001

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

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

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

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

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

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

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

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

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

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

  82. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 505

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

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

Taille variable Globale : 78.93 KB