Retour
Fermer

Location ›

Lancez votre recherche pour voir les annonces.

Recherche appartement ou maison

Autres annonces du voisin

Tout voir
Location scooter
Location scooter

Demande il y a + de 30j

Il y a + de 30j

RECHERCHE SCOOTER OU VéLO éLECTRIQUE
Profil du voisin
Dalila D

Douai 59500

185€/m

Annonces similaires

Tout voir
Location colocation appartement
Location colocation appartement

Demande il y a + de 30j

Il y a + de 30j

LOUER CHAMBRE OU STUDIO CHEZ L'HABITANT
Profil du voisin
Mina R

Bellaing 59134

150€/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='515962'

  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

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

  7. 0.0001

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

  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.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.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 (110) ORDER BY ssrubr_order ASC

  15. 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 (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.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 (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.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 (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 = 515962

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

  32. 0.0001

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

  34. 0.0001

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

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

  43. 0.0001

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

  44. 0.0049

    SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.3667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.3667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.06667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.917039197041 AND ville_latitude_deg<50.816360802959 AND ville_longitude_deg>2.361723505516 AND ville_longitude_deg<3.771616494484 HAVING distance <= 50 ORDER BY distance ASC

  45. 0.0014

    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 (59500,59552,59553,59553,59552,59553,59450,59169,59128,62112,59187,59119,62117,59950,59286,62112,62490,62490,59169,59287,62970,59194,59169,62490,59194,59167,59182,59287,62790,59151,59283,62490,62141,62950,59169,62490,59182,59169,59283,59151,62119,59151,59162,59151,62490,59176,62118,62490,62490,59148,62320,59146,62320,62580,59176,62110,59234,62118,62860,59259,62320,62640,59310,59151,62156,59870,59165,62590,62156,59246,62740,62118,59234,62860,62860,59490,62580,59239,62860,62420,62320,62580,59261,62860,59265,59310,62710,59234,62820,62860,62156,62580,59580,62156,62118,59580,62580,59235,59870,62118,62680,62220,59265,62156,59239,59551,59870,62118,62440,62860,62430,59710,62860,59490,62880,62156,59247,62580,62580,59870,59252,62218,62221,59310,62156,59247,59310,62118,62182,59179,62860,62580,59551,62860,62860,62210,59252,59215,59133,59710,62880,62880,62182,59247,59133,62580,59171,62223,62880,59252,59870,62300,59242,59112,59265,59172,62223,62128,59265,62128,62860,59710,62300,62182,62860,59310,59171,59111,59554,62580,59710,59265,59870,62128,59147,59870,59310,62410,59185,62128,59268,59242,59554,59111,62410,59310,59295,59295,59251,59178,62182,62223,59172,59124,59554,59113,62128,59554,59112,59156,62223,59273,59111,62217,59310,62410,59230,59221,59147,62860,59171,62580,59242,62580,59141,59178,59147,62223,59293,62138,62128,59400,59554,62410,62800,62223,62217,62750,59230,62000,62128,59175,62860,59175,62860,59830,62153,62223,59161,62128,59310,59263,62860,59220,59690,59310,59272,59111,62217,62128,62128,62143,59178,59141,62223,59496,59273,59400,59161,62138,59141,59184,59830,59554,59135,59282,59255,59226,62217,62217,62217,59155,62147,59139,59267,59282,59139,59810,59400,62128,59136,59830,62128,59178,59496,59274,59830,62147,59161,62153,59262,59220,59267,62138,59400,62175,62160,59830,62159,62128,62128,59830,62160,59296,59135,59790,62144,59195,62144,62138,59226,62147,59220,59161,59134,59830,59320,59480,62000,62160,59320,62161,59121,62161,59159,62980,59134,59230,62121,59211,62124,59195,62138,59780,62175,59134,59277,59400,59152,59152,59480,59400,62121,59121,62147,62149,62147,62173,62149,59494,62217,62980,59260,59120,59267,59152,59134,59198,62159,59281,59224,62161,62147,62175,62670,62149,62144,62124,59320,59320,62159,59400,62124,62114,62149,62172,59188,59780,59159,59129,62175,62161,59158,59320,59320,62124,62121,59494,59590,59174,62144,59000,59800,59777,59350,59160,59320,59152,59241,62530,59159,59224,62123,59158,62113,62113,62173,59188,62840,59217,62121,62530,62175,59125,59249,62450,59320,59233,62124,62123,59134,62450,59230,59410,62690,59370,59249,59510,59320,59192,62121,59400,62121,62690,59158,62530,62144,59227,59227,62173,59400,62290,59230,62149,62840,59110,62147,59130,62123,59227,62123,62124,62450,62660,59231,59780,62173,59292,59188,62690,62113,62690,62124,62690,59400,62121,59217,59217,59160,59158,59258,62450,59300,62116,59840,59199,59350,59213,62123,62123,62121,59510,59258,62124,59217,62450,59390,62136,62116,62123,62123,59300,59860,59300,62690,62620,59269,62450,62124,62124,59214,62116,59700,62450,62150,59157,59258,62124,59840,59199,62116,62690,59213,62123,59290,59170,62123,59294,62450,62131,59280,62131,62131,62450,59840,62123,59880,62690,62121,59770,59157,59520,62620,62136,62450,59127,62124,59266,62150,62690,62400,62111,59390,62123,59269,59118,59390,59231,62136,59390,62690,62620,59970,59237,62810,62840,59213,59213,59655,59491,59493,59650,62450,62150,59231,62124,62121,62400,59191,59278,59990,62124,62123,59540,59730,62232,62400,62620,62940,62123,62450,62196,62450,62450,62840,59266,59269,62690,62123,62690,62116,59540,62450,59990,62690,62232,62232,59730,62232,59730,62150,62150,59191,80360,59730,59930,59910,62810,80300,80360,59271,59420,59970,59213,59213,59990,62810,59280,59115,80360,59297,59100,59163,62810,62690,59266,59264,59990,62690,80300,59730,62840,62111,80360,59990,59191,62199,62116,80300,80240,59970,59127,62690,59530,59193,62158,59116,59150,80360,59940,59225,62920,62136,62232,62700,62150,62810,80360,59540,80122,62111,62111,62450,62810,62158,59243,62122,62127,59890,59200,62111,59253,59144,59225,80360,59127,59530,80360,62450,02420,62810,59540,62158,62920,59127,59236,62150,59530,80300,80300,62111,62158,02420,62127,59850,62127,80360,59142,59126,59250,59223,80240,80240,62150,62810,59730,80240,80740,59980,59218,59218,59127,59360,59163,62810,62122,59990,62127,62127,59990,80360,62350,62111,62127,59890,62460,59980,62540,59154,62150,59530,62158,59144,59530,62920,62760,59218,59181,80360,59218,62350,59530,80360,80360,59940,59163,62460,80300,59920,59660,80112,02420,80300,62450,02420,59530,62810,62127,62111,59144,59960,59940,62760,59560,59980,59980,59238,80740,80760,02420,59144,80300,59980,62470,62810,62540,62810,62127,62127,59222,80300,62350,59222,02420,80200,02110,62127,59144,62157,59360,62111,80560,62158,62460,02110,62470,80240,59166,59117,80240,80560,59360,59530,80240,59560,80300,59530,59144,62810,80240,59530,62760,80560,62127,62350,62260,62127,62810,59530,62810,59530,62130,80560,62158,80300,62810,80300,80300,02420,80360,62350,62810,62350,59222,62760,62760,62760,80300,80560,62260,62127,59530,80360,59530,59360,62151,80240,59570,62127,80600,80240,02110,80300,80200,62270,80300,59137,62190,62760,59550,62550,59288,80560,02420,80200,59270,02420,59360,62550,62810,62550,62130,62127,80560,59144,80360,80300,62550,02420,80360,62810,59550,62350,80560,59232,62760,59270,80200,02420,59360,80240,80240,59144,62810,80300,80300,02110,59270,80240,80200,02110,59360,80300,80560,80240,62130,62130,02490,62130,59570,02490,80200,59570,62190,62130,80200,80360,02110,59570,80560,62260,62550,62190,62270,80200,02420,59270,62810,62130,62330,80600,59530,62130,59570,02110,62760) 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<>'515962' 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='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=11542 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 = 11542 AND W.type_id = 1) OR (W.util_id != 11542 AND W.type_id = 2)) AND (`post_util_id` = 11542 OR `dest_util_id` = 11542) 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 = 11542

  50. 0

    SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 504

  51. 0.0008

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

  52. 0

    SELECT count(*) as nbwish FROM wish

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

53 requetes sql en 0.0588

Taille variable Globale : 75.15 KB