Descripción del anuncio
Loue une chambre étudiant axe carvin oignies
Gare à proximité libercourt
#Chambre en colocation
Indica un código postal o una ciudad Indica un código postal
Publicar un anuncio
Loue une chambre étudiant axe carvin oignies
Gare à proximité libercourt
#Chambre en colocation
Alquile Chambre; chambre en colocation entre particulares u ofrezca Chambre; chambre en colocation para alquiler.
Publicar un anuncioenviar un mensaje
Podrás chatear y organizar una reunión.
Inicie su búsqueda para ver los anuncios.
Asistencia de soporte Kiwiiz
¿Cómo podemos ayudarte?
Script : /wiiz-annonce.php
SELECT filtre_dptnom, filtre_villes, dpt_url FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('' USING utf8mb4) COLLATE utf8mb4_general_ci
SELECT cate_title_slug FROM category WHERE fami_id IN (3,5) AND cate_title_slug<>'' AND cate_title_slug IS NOT NULL
SELECT DISTINCT ssrubr_slug FROM ssrubr WHERE ssrubr_visu=1 AND fami_id IN (3,5) AND ssrubr_slug IS NOT NULL AND ssrubr_slug<>''
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='537451'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='chambre-en-colocation' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='505'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'chambre-en-colocation' LIMIT 1
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'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('62' USING utf8mb4) COLLATE utf8mb4_general_ci
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='388534' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND wish_area='ES'
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 388534
SELECT util_cp FROM utilisateur WHERE util_id=388534 LIMIT 1
SHOW TABLES LIKE 'pays'
SHOW COLUMNS FROM pays LIKE 'pays_tel_%'
SELECT pays_code, pays_nom, pays_actif, pays_NDD, pays_drapeau, pays_lang, pays_tel, pays_nb_annonces, pays_tel_masque, pays_tel_max, pays_tel_fmt_paires, pays_tel_mode FROM pays ORDER BY pays_nom ASC
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 537451
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=505 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 388534 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='537451'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='537451' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=388534 LIMIT 1
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)
SELECT COALESCE(SUM(CASE WHEN M.match_step <> 3 THEN 1 ELSE 0 END), 0) AS h, COALESCE(SUM(CASE WHEN M.match_step = 3 THEN 1 ELSE 0 END), 0) AS cancelled FROM `match` AS M INNER 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 (M.post_util_id = 388534 OR M.dest_util_id = 388534) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
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 = '537451'
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify 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='388534' AND wish_id<>'537451' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND w.wish_area='ES'
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='62590'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.4667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.4667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.98333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.017039197041 AND ville_latitude_deg<50.916360802959 AND ville_longitude_deg>2.2768937955549 AND ville_longitude_deg<3.6897662044451 HAVING distance <= 50 ORDER BY distance ASC
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id, ui.util_verify FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_visu IN (1,6,10) AND wish_area='ES' AND wish_cp IN ('62590','62220','62820','62119','59261','62710','59162','62880','59239','62640','62141','59133','62950','59112','59239','62740','59133','62970','62440','62110','62790','62880','62880','59185','59551','59950','59283','59147','59251','62410','59551','59283','62420','59112','62880','59246','59128','59221','59286','62221','62218','59147','59147','62410','59113','62138','62430','59710','59710','59272','62320','62320','59553','59553','59310','62410','59710','59184','62320','59496','62680','62490','59263','62300','62490','59553','62320','62410','59235','62138','59194','59136','59175','59274','59175','59500','59496','59710','62210','62300','62580','59139','59119','59139','62580','59552','59134','62580','59194','59552','59273','62138','59242','59155','62750','59134','59450','59134','62580','59320','59148','62490','59320','59480','59242','59211','62117','62138','62490','59480','59310','59310','59134','62112','59167','62138','59169','59810','62580','59187','62580','62800','59320','62580','59320','62580','59120','59790','59320','59320','62490','59273','59320','62112','62149','62149','62143','59287','59249','62580','59310','62160','62980','59830','62580','62840','62149','59242','59134','59182','59249','59262','62580','59182','59287','59320','62118','59169','59320','62118','62153','59146','62980','59169','62118','62490','59260','62840','59830','59870','62149','59310','62160','59870','59000','59800','59160','59350','59777','59151','62118','62118','59830','62149','59830','62670','62580','59176','62113','62113','59160','62490','59840','59130','62490','59169','62160','62118','59176','62153','59169','59110','62136','59152','59152','59310','62114','62223','62223','59370','59310','59280','59151','62223','59830','59490','62660','59310','59350','59151','59151','59830','62144','59870','59870','59152','62156','59840','59840','62156','62156','62290','62223','59310','59259','62223','62113','62136','59780','59830','62840','62118','62172','59165','59510','59700','59234','59152','62223','07611','62530','62223','62860','62136','59870','62144','59520','59780','59490','62840','59580','62223','59237','62156','62156','62156','62400','62530','62156','62860','59118','62860','59151','62530','59870','07610','59930','62860','62860','62000','59234','59310','59690','59230','62400','62131','62131','62144','59179','59178','59280','62128','59170','59290','62217','59580','62131','59870','62128','62840','59510','59234','59780','07502','59265','62400','59193','62860','62620','59226','62620','59230','59171','62161','62161','59178','59390','59116','62217','62128','07522','59940','62232','59491','59493','59650','59655','07624','62217','59215','62144','62232','62232','62136','62690','62217','62217','07522','07618','62690','59171','62182','59910','62128','62860','59253','62196','59265','07504','62690','62860','62232','59390','62150','59247','07783','62000','59252','59890','62182','62182','62128','62690','59390','59850','59236','59420','62128','62128','62860','62232','62161','62620','62940','62620','59390','07522','07522','07506','59247','59252','62920','62860','07520','07620','62199','62150','59178','62144','59100','62217','62690','07623','62161','59172','07621','62860','59171','59226','59181','59178','59890','62182','07782','62690','62860','59247','59124','07730','59252','07501','62122','07620','07500','62690','59200','62128','62860','59940','62123','62920','62150','59223','59250','59126','62150','62128','07620','59940','59115','62690','62175','59265','62350','59150','59265','59111','07620','62350','07620','62700','59156','59660','62123','59172','62217','62150','59111','59560','07500','07503','62173','59554','62920','62860','62690','59135','62123','59265','07784','07730','62128','62128','62150','62123','62123','62128','59220','59158','62690','59230','59295','59295','59293','59255','62122','07712','07520','59268','59554','07620','62123','59111','07784','07500','07730','07780','07780','62175','62690','62123','62128','62350','59554','07730','08950','07641','59158','62150','62540','59158','07730','59554','62690','62860','07622','62175','59560','62173','59141','59960','62173','62121','62128','59117','62860','62690','59135','07521','08957','62350','62127','59282','08952','62175','07743','59166','62690','59220','62460','62123','59111','07642','59230','59230','59400','62860','62150','62690','59195','59158','59270','59554','07743','62175','07536','62540','07700','07730','07640','62350','07540','62810','59282','07548','07740','62157','62173','62121','62127','62121','62123','62123','59141','08940','59220','59161','07700','62159','07730','62470','62460','62350','59494','59195','07781','59270','62147','59141','59270','59400','59232','59161','62150','62810','62123','62690','59121','07542','08951','59554','08950','08953','62121','07640','07643','62159','59400','59199','62470','59590','59267','62260','07540','07904','62350','07740','08956','62147','62810','59121','62190','07711','62127','59494','62124','62147','59270','59161','62123','59296','62151','62123','07742','62159','62116','08930','59267','62127','59174','59199','59192','08902','62116','59400','07531','62810','62260','62810','59224','62460','07640','08930','08958','62123','62127','62810','07530','59410','59270','62116','62127','08587','08980','62121','62121','07538','07543','08510','62123','62111','59161','08940','62190','08511','07604','62124','62124','62147','62810','62810','59198','62330','62124','62147','62550','08510','59159','59125','08930','08560','07608','62121','62190','59270','62130','62158','62450','62127','62116','59277','62450','62147','62127','08902','08587','62121','62810','59224','62127','59400','59233','62450','59267','59860','62550','59190','62550','62550','59970','59400','62127','08510','08954','07760','62190','62260','59270','07540','59188','07604','59281','07532','62450','62124','08587','08900','59190','08980','62158','59129','07604','62127','59300','62190','62190','08902','59400','62127','62330','62550','62127','59300','62450','62121','59159','62158','59188','59190','07604','08970','59300','62190','62120','62111','07533','62111','62550','59880','08554','59278','59189','08510','07534','59189','62450','59159','59227','62260','62810','59190','62130','07760','07760','59227','59227','59299','62450','62116','59770','59190','62121','59241','62111','59217','62158','62450','62550','08980','59163','07540','62124','59970','62124','62124','62158','62550','59213','62810','62450','62810','59269','62810','62130','62810','07760','07601','62120','62450','62147','08900','08501','07534','59400','08583','07604','08560','07600','62127','08890','07760','59400','59188','59189','62120','62116','62550','59292','62810','59213','59270','62127','62130','62450','59231','62550','62111','07602','62810','80300','59970','62550','62450','62270','59269','07603','62124','59114','62130','62120','80300','07906','62124','08552','59217','62190','62760','59990','08880','62124','62111','08900','59400','59217','08560','59264','08908','08500','62550','62550','62760','62124','62810','62120','59258','08501','62130','62120','59990','59294','08980','08582','62120','80300','07904','62130','62450','59217','59114','07910','62158','59214','62550','62130','59258','59990','08900','62130','59173','62960','62960','62450','59243','62130','59213','59213','08550','07910','62111','59157','62120','62120','62550','07911','59190','62810','59269','62130','08880','59990','62111','59258','62158','07760','08551','62124','59163','62124','62270','59990','07971','59114','62450','80300','62120','62450','08970','59157','62130','62120','62810','62810','59190','07971','62270','62130','07901','59266','62145','59127','07750','80600','07320','59163','59231','62134','08580','07910','59730','80300','07910','07910','59154','80360','62760','07911','07971','08890','08880','08520','07971','62960','07911','80360','59231','62130','59213','59213','62760','62760','62130','59144','07750','59730','08906','59530','07910','07321','62130','07750','07750','59540','59670','62111','80560','80360','80300','08980','62270','80360','80360','59730','62134','59191','62134','80360','80360','62130','59990','07904','59173','08904','59173','59730','07910','08530','80300','59114','08553','09690','59266','62810','62120','62145','62450','80360','62760','59540','62130','59990','59730','80560','62270','59190','07900','07900','62760','59271','59920','59530','80360','07387','07750','62120','80240','59191','62760','80560','59297','07911','80560','07972','07350','59670','08920','59530','07972','62130','62120','80560','80600','08860') AND fami_id='5' AND cate_id='193' AND type_id='1' AND ssrubr_id='505' AND wish_id<>'537451' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 505
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 505
SELECT fami_id as id, fami_title as title, fami_tutotitle, fami_tutodesc, fami_buttontitle, fami_url as slug FROM `family`
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT COUNT(*) AS nbavis FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10) AND wish_area='ES'
Contáctenos