Description de l'annonce
Chambre a louer chez l habitant
#Chambre en colocation
Voir les annonces autour de moi Géolocaliser
Poster une annonce
Chambre a louer chez l habitant
#Chambre en colocation
Louer une chambre entre particuliers ou proposer une chambre en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Lancez votre recherche pour voir les annonces.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
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
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 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='519595'
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='364280' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 364280
SELECT util_cp FROM utilisateur WHERE util_id=364280 LIMIT 1
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 = 519595
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=505 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 364280 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='519595'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='519595' 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=364280 LIMIT 1
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)
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 = 364280 AND W.type_id = 1) OR (W.util_id <> 364280 AND W.type_id = 2)) AND (M.post_util_id = 364280 OR M.dest_util_id = 364280) 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 = '519595'
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='364280' AND wish_id<>'519595' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND (w.wish_area IS NULL OR w.wish_area='' OR w.wish_area='FR')
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='62157'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.5333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.5333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.5- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.083639197041 AND ville_latitude_deg<50.982960802959 AND ville_longitude_deg>1.7925669533211 AND ville_longitude_deg<3.2074330466789 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 IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp IN ('62157','62540','62151','62122','62540','62190','62260','62920','62122','62260','62190','62470','62350','62550','62190','62920','62470','62190','62190','62260','62190','62199','62700','62190','62120','62260','62550','62920','62232','62460','62196','62550','62232','62232','62350','62550','62232','62350','62120','62550','62232','62460','62150','62330','62550','62400','62550','62620','62940','62150','62550','62190','62330','62350','62550','62620','62120','62131','62131','62131','62120','62350','62550','62960','62960','62550','62620','62120','62150','62350','62150','62120','62460','62400','62550','62120','62120','62113','62400','62350','62620','62145','62550','62960','62150','62290','62660','62120','59189','62120','62150','62134','62130','62530','62145','62150','59660','62550','62113','62113','62150','62127','62127','59189','62120','62550','62136','59189','62130','62960','62127','62150','62149','62136','62114','62134','62670','62120','62145','62136','62980','62130','62120','62149','62130','62530','62134','62134','62149','62130','62690','62690','62980','59940','62172','62960','62136','62127','62690','62149','62530','59253','62134','62134','62145','62120','62130','62149','62960','62127','59190','62690','62690','62960','62127','59173','59940','62160','62160','62690','62134','62120','62160','62960','59173','62134','62134','62138','62129','62130','62138','62130','62134','62130','62840','62134','62120','62127','62130','62130','62690','59190','62127','62690','62840','62120','59232','62690','62129','62127','62130','59480','59173','62690','62138','62129','62690','62840','62144','62310','62134','62143','62144','62130','62690','62134','62750','62130','59190','62127','62310','62310','59270','62690','62690','62130','59940','62153','62560','62130','62840','62130','62800','62134','62120','62144','59190','62129','62310','62410','62129','62134','62130','59173','59190','62127','62120','59270','62130','62560','59496','62310','62310','62138','62310','62129','59480','62575','62127','59173','62130','62144','62127','62690','62410','62153','62127','59190','59249','62310','62127','62690','62130','62130','62144','62130','62380','62560','59134','59190','62580','62310','62410','62130','62570','59249','62310','62380','62300','59496','62810','62810','62310','62310','62310','59190','59274','62138','62570','62300','62270','59134','62810','59114','62560','62575','59270','62130','59270','62130','62130','62810','62130','62270','62770','62840','62123','62770','62310','62880','62510','62130','62130','62130','62560','59221','62270','62123','62123','59181','62130','62310','62310','62410','62270','62123','59134','59270','62310','62570','62130','62580','62810','62380','59670','59670','62210','59670','62810','62810','62161','62161','62770','62810','62880','62880','62810','62221','62218','62310','59184','62810','62161','62570','62560','59134','59114','62810','62310','62770','62380','62770','62270','62270','62161','62430','62380','62580','62219','62223','62560','62770','62270','62219','62270','62580','59272','59185','62500','59136','59670','59114','62440','59193','62500','62810','59670','62770','62270','62223','62680','59850','59280','59670','62810','62770','59270','62270','62123','59114','62560','59134','62310','62880','59670','62500','62270','59112','62123','62380','62380','59320','62560','62270','62420','59270','62580','62223','59270','62270','62123','62740','62810','59670','62810','59143','62000','59280','59251','62380','62810','62320','62770','62580','59285','62123','62270','62770','59320','59320','62380','62710','62500','62810','62123','62500','62770','62223','62580','59670','62310','62500','62223','62640','59211','62310','08951','59930','62270','59299','62770','62580','62320','62270','59147','59112','62560','62140','62560','08950','62380','62770','62110','62580','62810','62270','59670','07783','62810','62220','62500','62270','59670','59670','62223','62270','08958','59320','59320','62810','62158','62770','62770','59285','62320','62320','62580','62810','08954','62500','59147','62770','62770','59147','59133','62000','62390','59840','07782','62500','59143','62650','62310','62123','62380','59116','59320','62380','62140','59320','62590','59285','59143','62123','62123','62223','62580','62217','62217','08950','59320','62158','59160','08952','59263','59470','62910','62158','62650','59470','62270','62173','62217','62770','62580','62140','62119','59320','08956','62380','59840','62990','62217','62380','62270','80600','62123','62140','59470','62910','62810','62123','62650','59133','62950','62910','08970','62990','62270','59236','62140','62140','62490','62650','59139','62820','62140','62158','62158','62500','80600','80600','08978','62217','62380','62173','62223','62990','80600','62158','62173','62118','62650','59120','62140','59143','62650','59113','62380','62490','62910','62650','62140','62140','62270','62390','62390','62390','62990','59261','08957','62123','59840','62173','62118','62390','62910','62390','62217','62380','59890','62970','59162','62140','62650','59143','59470','62140','62490','59551','62390','59470','59470','62760','08953','59237','62890','59175','08970','59239','62140','59470','59139','80600','59239','62118','62141','62158','62380','59143','62140','08900','59470','62111','62217','62990','62380','07784','62140','80600','59560','59130','62140','62380','62380','62990','62990','62650','59470','62650','62910','62390','62390','59175','59470','59155','62990','62118','80600','62175','62111','62650','59890','62760','62760','62490','62760','62128','62128','62140','59350','62890','59470','59553','62118','59950','62760','62760','07784','59143','80600','62175','62390','62118','62175','08972','62760','08902','59710','62128','59551','62116','59000','59800','59160','59350','59777','62111','62128','62175','62790','59128','62128','62140','62140','62111','62140','62118','62240','59110','59470','62175','59118','08908','62128','59283','59553','59553','62650','62390','62650','62650','62760','59380','62240','62760','62850','80370','62990','59283','59630','62990','62117','62111','59520','59246','59790','62390','59380','62890','62990','08902','80600','07781','62390','62390','62140','59122','80600','62121','59286','62240','80370','62128','07780','07780','62156','62116','62650','59710','62850','08972','59700','59710','59810','80600','62144','59552','62890','62890','80150','80600','62116','62156','62850','62240','62390','59500','62890','62990','62240','62390','62890','80600','08972','59380','62650','62370','59260','59380','62760','59122','62760','08900','80600','62128','08900','59370','62760','62850','62890','59560','59710','59273','62490','08902','62156','62112','59380','62650','59552','62121','08906','62490','62760','62370','62170','59380','80150','62156','59310','59630','62121','80600','62111','80370','08640','59630','62156','62116','62850','62111','62990','62112','62890','59169','80370','62128','62128','62140','62240','80370','59284','08980','62890','62128','62990','62156','62240','59910','62170','59235','80560','62870','80560','08640','08640','62760','80560','59630','62760','62370','08900','80600','59194','59117','62116','62760','62111','80560','59119','62850','59223','59250','59126','62140','80370','62490','08940','08691','62490','62240','59380','80150','59242','80370','62121','59242','62870','62650','59273','80600','62111','80370','59262','59450','80600','08904','80150','62182','08640','62850','62610','62240','62170','59151','62140','80560','62830','62870','59259','62170','62170','80560','59187','59170','59290','59491','59493','59650','59655','62370','08980','62156','59194','62650','80600','59420','80560','59380','59122','62116','80560','62610','59380','80560','59830','62850','59166','62850','80150','62850','80560','08904','62370','59630','80150','62240','62121','62650','62142','80150','59169','80370','62128','62128','80150','62182','62870','62610','62860','62121','62240','62159','62610','62240','62170','59830','59510','62170','62121','80630','80370','62650','59148','59151','59310','59380','80370','62182','62182','59152','59152') AND fami_id='5' AND cate_id='193' AND type_id='1' AND ssrubr_id='505' AND wish_id<>'519595' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
SELECT ssrubr_slug, ssrubr_title, 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
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)
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 = 496885 AND W.type_id = 1) OR (W.util_id <> 496885 AND W.type_id = 2)) AND (M.post_util_id = 496885 OR M.dest_util_id = 496885) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 496885
SELECT ssrubr_slug, ssrubr_title, 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
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)
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 = 70077 AND W.type_id = 1) OR (W.util_id <> 70077 AND W.type_id = 2)) AND (M.post_util_id = 70077 OR M.dest_util_id = 70077) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 70077
SELECT ssrubr_slug, ssrubr_title, 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
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)
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 = 469642 AND W.type_id = 1) OR (W.util_id <> 469642 AND W.type_id = 2)) AND (M.post_util_id = 469642 OR M.dest_util_id = 469642) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 469642
SELECT ssrubr_slug, ssrubr_title, 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
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 abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 388534
SELECT ssrubr_slug, ssrubr_title, 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
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)
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 = 364431 AND W.type_id = 1) OR (W.util_id <> 364431 AND W.type_id = 2)) AND (M.post_util_id = 364431 OR M.dest_util_id = 364431) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 364431
SELECT ssrubr_slug, ssrubr_title, 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
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)
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 = 319308 AND W.type_id = 1) OR (W.util_id <> 319308 AND W.type_id = 2)) AND (M.post_util_id = 319308 OR M.dest_util_id = 319308) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 319308
SELECT ssrubr_slug, ssrubr_title, 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
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=320302 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 = 320302 AND W.type_id = 1) OR (W.util_id <> 320302 AND W.type_id = 2)) AND (M.post_util_id = 320302 OR M.dest_util_id = 320302) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 320302
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 IS NULL OR wish_area='' OR wish_area='FR')
Contactez-nous