Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Loue chambre meublée

Autres annonces du voisin

Tout voir
Location chambre meublee
Location chambre meublee
CHAMBRE MEUBLéE A  LOUER
Profil du voisin
Daisy W

Basseux 62123

347€/m

Louer la chambre

Annonces similaires

Tout voir
Location chambre en colocation
Location chambre en colocation
CHAMBRE éTUDIANTE
Profil du voisin
Celine W

Oignies 62590

370€/m

Louer la chambre
Location chambre en colocation
Location chambre en colocation
CHAMBRE GRAND LIT AVEC NETFLIX ET AMAZON
Profil du voisin
Olivier A Voisin vérifié
100% fiable

Fruges 62310

450€/m

Louer la chambre
100%
Location chambre en colocation
Location chambre en colocation
CHAMBRE CHEZ L HABITANT
Profil du voisin
Ophelie H Voisin vérifié
1.0 100% fiable

Wattignies 59139

50€/nuit

Louer la chambre
1.0 100%
Location chambre en colocation
Location chambre en colocation
CHAMBRE MEUBLéE
Profil du voisin
Daisy W

Bailleulval 62123

100€/sem

Louer la chambre
Location chambre en colocation
Location chambre en colocation
CHAMBRE CHEZ L'HABITANT CONTRE MéNAGE (
Profil du voisin
Ludivine L

Aix-Noulette 62160

-- €

Louer la chambre
Location chambre en colocation
Location chambre en colocation
CHAMBRE HOTE 62
Profil du voisin
Eddy T

Allouagne 62157

175€/sem

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

  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

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

  7. 0.0001

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

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

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

  18. 0.0002

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

  19. 0.0002

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

  20. 0.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 = 619937

  30. 0

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

  32. 0.0001

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

  34. 0

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

  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='70077' AND wish_id<>'619937' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)

  39. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='1087' LIMIT 0,1

  40. 0.0001

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

  41. 0.0001

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

  42. 0.0002

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

  43. 0.0001

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

  44. 0.0059

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.2667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.2667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.61667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.817039197041 AND ville_latitude_deg<50.716360802959 AND ville_longitude_deg>1.9132048074258 AND ville_longitude_deg<3.3201351925742 HAVING distance <= 50 ORDER BY distance ASC

  45. 0.0034

    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 (62123,62123,62810,62123,62123,62810,62123,62123,62123,62123,62123,62123,62810,62123,62123,62810,62161,62158,62123,62123,62161,62810,62173,62690,62810,62158,62173,62000,62144,62123,62158,62810,62690,62161,62161,62217,62810,62158,62690,62173,62810,62810,62173,62690,62690,62690,62111,62690,62144,62158,62810,62111,62127,62690,62217,62217,62810,62223,62144,62690,62760,62116,62111,62158,62175,62111,62690,62223,62810,62760,62690,62144,62223,62810,62217,62810,62000,62127,62127,62175,62158,62690,62690,62223,62175,80600,62127,62223,62810,62690,62116,62127,62111,62810,62223,62810,62217,62690,62760,62116,62760,62175,62580,62121,62175,62217,62144,62760,62810,62217,62127,62270,62153,62690,62111,62111,62127,62150,62127,62128,62530,62116,62760,62760,62810,62223,62128,62810,62760,62116,62580,62127,62128,80600,62153,62127,62121,62127,62128,62223,62111,62150,62580,62111,80560,62150,62530,62121,62127,62270,62172,62127,62760,80560,62150,62130,80600,62116,62160,62270,62270,62128,62580,62580,62760,80560,62580,62128,62760,62270,80560,80560,62810,80560,80560,62270,62580,62130,62121,62760,62121,62128,80600,62128,62150,62143,62121,62127,62130,62118,62150,62130,62127,62130,62121,62800,62160,62130,62118,62118,62150,80560,80300,62580,62128,62620,80560,62121,62760,62530,62620,80300,80300,62270,80300,80600,62114,80560,62580,62159,62580,62130,62760,62150,80560,62210,62130,62121,62760,62121,62118,62150,80300,62270,62270,62118,62128,62130,62300,62450,62760,62580,62460,62160,62128,62130,62130,80560,80300,62620,62940,62460,80600,62156,80560,62270,62320,80600,62670,80560,62680,80600,62580,62128,62128,80560,62450,62490,62450,62750,62130,62130,62270,62156,62460,62156,62320,62130,62270,62118,62270,62130,62130,62128,62300,62620,62450,80300,80300,80560,80300,62130,62290,62182,62430,62700,80560,80560,80600,80300,80560,62550,62182,62450,62450,62130,62320,62320,62156,80600,62980,80600,62118,62450,62450,62131,62980,62450,80600,62221,62218,62550,80600,62470,80600,62131,62196,62131,62159,62156,62270,62420,62270,62490,62450,62113,80300,80300,62470,62550,62130,62450,62113,62113,62270,80300,62540,62149,80560,80300,62130,62159,62490,62130,80600,62130,62149,62156,80600,62270,62490,62270,80630,62130,62130,62860,62130,62270,80300,62232,62182,62232,62450,62199,62410,62550,62124,62110,80560,80360,80300,62122,62124,62260,62450,80300,62660,62740,62490,80600,62182,62122,62270,62880,62450,62156,62260,80560,62550,62410,80360,62550,62440,62270,62390,80300,62130,80600,62130,62130,80600,62540,80300,62550,62640,62880,62880,62550,62410,62550,62117,62149,62130,62860,62450,59259,62232,62232,62490,62400,62390,62860,80300,80300,62270,62920,80300,80360,62124,62490,80360,62138,80600,62450,62134,62710,62124,80300,80300,59553,62130,62860,80370,62550,62138,62157,62880,62149,62860,62134,62950,62124,62134,62270,62490,62390,62390,80600,62124,80300,80560,80560,62260,80260,62112,62860,62450,80360,62151,62920,80300,62134,80370,62112,62124,80370,62400,80300,80810,62550,62138,80360,80300,62130,62138,80300,62119,62147,80750,62390,80750,62130,62860,62860,62147,62410,59552,59151,62450,80260,62130,62550,59480,80260,62770,62149,62390,62860,59169,62860,80260,80300,62970,62550,62138,80360,62134,62124,80670,62390,59151,80370,62134,62232,80300,59553,59553,59496,62260,80260,80300,59552,62770,62920,62400,62134,80360,59221,62860,80260,80260,59500,80370,62134,80260,62147,80670,59128,62770,62134,62590,80800,62860,80800,59151,62390,62770,62770,59496,62550,62190,62190,62147,62860,62220,80360,62124,62190,59169,62141,62134,59950,59185,62124,80360,62770,62770,62134,62550,80260,80360,80300,62124,80300,62350,80300,80370,80113,62190,62840,80260,80360,62124,62770,62860,80370,80260,62136,80113,59169,62860,62390,62190,62136,80260,59162,62134,62134,62350,62136,62770,62770,80370,62860,59274,62190,62190,62120,80360,62124,80370,80800,62960,80360,59187,59151,59480,62134,62960,62960,80360,62190,80340,80670,80360,62390,62790,62390,80620,59286,62770,62840,62147,80370,59112,59450,62820,59134,62350,59112,80670,59184,80340,80260,80260,62147,80670,80340,80800,80340,59134,62120,59119,59400,59251,59283,62310,62390,62390,80260,59272,80260,59133,59151,80200,59261,62310,80670,80370,62770,80260,62120,80370,62134,80360,80370,80370,59169,80370,62140,59283,62770,62310,62350,80800,80340,80115,80200,80800,80800,62147,59287,62770,62124,62860,59239,62310,80370,62350,80620,59265,59265,80150,80670,62350,62136,80800,80800,62770,62390,59267,62960,59147,62960,59169,59265,80260,80370,62770,59136,59133,80115,80340,80800,59554,80370,62310,59134,80260,80200,62770,62330,80340,80800,59147,80850,59249,62120,59554,59159,59182,59287,80760,59239,62960,59194,80360,80620,59234,59249,62120,80260,59194,80650,62330,59400,80150,80620,59660,59147,62310,62140,80340,62310,80260,80150,80240,80800,62120,62120,62145,80240,59167,62140,59253,62350,80800,59267,59940,59551,62310,62390,59234,62140,59247,62145,80340,80800,80260,62140,62140,59246,62140,62120,59265,80800,80340,80620,59182,80780,59551,59231,62840,80980,80620,80200,80370,80260,62145,62770,59176,80800,80340,80200,59247,80150,62390,62310,59159,80340,59134,62120,59940,80800,59234,80260,80200,80240,59265,59310,62310,62140,59267,62140,59231,59263,62960,59268,80121,80620,59113,59134,80122,62140,80200,62120,80200,59176,62140,59159,80620,59554,62960,62120,62310,80200,59247,62310,80240,59189,62840,59710,62310,59211,59148,80800,62140,59554,80150,62140,80610,80310,62310,59554,80800,59320,80200,80136,59710,62310,59165,62140,62140,80170,59146,80240,80240,80200,80200,62310,59554,80150,59235,59320,59320,80440,80200,59231,80150,80340,80380,80620,59252,62140,59710,62140,62145,80610,59139,59281,59320,59400,62840,59580,59175,62560,62120,80240,80240,59189,59320,59580,59161,80150,62140,80131,80450,80200,59241,80135,62310,59320,80150,59189,59297,80200,80690,59310,59175,62310,62140,59252,59870,59252,80200,80690,80690,59490,80170,80135,80170,62140,80720,80131,62310,62310,59400,80150,80000,80080,80090,59280,80450,80200,80112,80131,59139,80200,80470,59320,59161,62140,62310,59940,59400,62560,80620,62120,80440,80420,80420,59320,59710,62310,59266,80740,80340,80380,62140,59111,59295,59295,80200,59155,62140,59141,80730,80730,80470,80135,80200,59320,80320,80380,59310,59242,59870,80690,59266,80135,80310,62560,59120,62120,80690,59232,62144,80200,80240,80470,59273,62120,80720,80150,62129,80330,80330,80110,59258,80690,80310,80310,62990,59266,59870,59490,59172,59190,59840,62129,80150,80150,59258,80310,62129,80200,80200,62310,59141,80470,59242,80830,80240,62560,59310,62990,59215,80830,59161,59400,59193,80440,80240,59160,80200,59161,59173,59181,80320,80320,80135,59111,59179,59111,59870,80150,59258,80135,59400,59400,80150,59141,59810) AND fami_id='5' AND cate_id='193' AND type_id='1' AND ssrubr_id='505' AND wish_id<>'619937' AND wish_url='' ORDER BY rand() LIMIT 0,10

  46. 0.0001

    SELECT ssrubr_slug, ssrubr_mail, ssrubr_mail_bis, ssrubr_keywords, ssrubr_bt2, cate_title_slug, fami_url, ssrubr_photo FROM ssrubr ssr, category c, family f WHERE ssr.cate_id=c.cate_id AND c.fami_id=f.fami_id AND ssr.ssrubr_id='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=388534 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 = 388534 AND W.type_id = 1) OR (W.util_id != 388534 AND W.type_id = 2)) AND (`post_util_id` = 388534 OR `dest_util_id` = 388534) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL

  49. 0.0002

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

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

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

  53. 0.0002

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

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

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

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

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

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

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

  70. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 505

  71. 0.0017

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

  72. 0

    SELECT count(*) as nbwish FROM wish

  73. 0.0735

    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

73 requetes sql en 0.093

Taille variable Globale : 77.57 KB