Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Colocation

Annonces similaires

Tout voir
Location colocation appartement
Location colocation appartement

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE UNE CHAMBRE à LOUER
Profil du voisin
Sam M

Chelles 77500

375€/m

Location colocation appartement
Location colocation appartement

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE COLLOCATION OU HéBERGEMENT (8
Profil du voisin
Ange N

Villiers-sur-Marne 94350

-- €

Location colocation appartement
Location colocation appartement

Demande il y a + de 30j

Il y a + de 30j

CHERCHE CHAMBRE COLOCATION (3 MOIS)
Profil du voisin
Voisin #112255

Levallois-Perret 92300

1080€

Location colocation appartement
Location colocation appartement

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE COLOCATION APPARTEMENT
Profil du voisin
Clara M

Paris 75001

500€

Location colocation appartement
Location colocation appartement

Demande il y a + de 30j

Il y a + de 30j

TRES URGENT COUPLE COUCHANT DEPUIS 4 MOI
Profil du voisin
Fanfansinger F

Paris 75014

500€/m

Location colocation appartement
Location colocation appartement

Demande il y a + de 30j

Il y a + de 30j

COLLOCATION
Profil du voisin
Voisin #370936

Paris 75013

600€/m

Location colocation appartement
Location colocation appartement

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE COLOCATION RESPECTUEUSE ...
Profil du voisin
Angela D

Paris 75010

4680€

Location colocation appartement
Location colocation appartement

Demande il y a + de 30j

Il y a + de 30j

CHERCHE UNE CHAMBRE à  LOUER (6 MOIS)
Profil du voisin
Voisin #53701

Aubervilliers 93300

450€/m

Location colocation appartement
Location colocation appartement

Demande il y a + de 30j

Il y a + de 30j

CHERCHE COLOCATION/LOCATION (9 MOIS)
Profil du voisin
Kynan C

Paris 75000

550€

Location colocation appartement
Location colocation appartement

Demande il y a + de 30j

Il y a + de 30j

LOCATION F2
Profil du voisin
Issa K

Nanterre 92000

395€/m

Louer en colocation entre particuliers ou proposer en colocation 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='602231'

  3. 0.0001

    SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='colocation-appartement' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='504'

  4. 0.0001

    SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'colocation-appartement' 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='95'

  7. 0.0002

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

  8. 0.0001

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

  9. 0.0001

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

  10. 0.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.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.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 = 602231

  30. 0

    SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=504 LIMIT 1

  31. 0.0001

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

  32. 0.0001

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

  34. 0

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

  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='471407' AND wish_id<>'602231' 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='95350'

  40. 0.0061

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((49*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((49*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.550339197041 AND ville_latitude_deg<49.449660802959 AND ville_longitude_deg>1.6812660970883 AND ville_longitude_deg<3.0520739029117 HAVING distance <= 50 ORDER BY distance ASC

  41. 0.0019

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

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

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

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

  57. 0.0002

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

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

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

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

  65. 0.0002

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

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

  69. 0.0002

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

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

  73. 0.0002

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

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

  77. 0.0002

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

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

  81. 0.0002

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

  82. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 504

  83. 0.0011

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

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

Taille variable Globale : 78.9 KB