Cherche à louer petit appartement ou pièce meublée
Prix
380€/mois
Description
Je suis à la retraite et recherche un petit appartement ou d'une pièce meublée pas trop chère #chambre meublee
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Maxéville (54320) · publié depuis 3 mois ou +
Discuter
Prix
380€/mois
Je suis à la retraite et recherche un petit appartement ou d'une pièce meublée pas trop chère #chambre meublee
Annonces similaires
Tout voirLouer 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 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='466465'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='chambre-meublee' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='1087'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'chambre-meublee' 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('54' 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='296819' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 296819
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 = 466465
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1087 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 296819 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='466465'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='466465' 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=296819 LIMIT 1
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 = 296819 AND W.type_id = 1) OR (W.util_id <> 296819 AND W.type_id = 2)) AND (M.post_util_id = 296819 OR M.dest_util_id = 296819) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='296819' AND note_visu IN (1,3,4)
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 = '466465'
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='296819' AND wish_id<>'466465' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='54320'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.7167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.7167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((6.16667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.267039197041 AND ville_latitude_deg<49.166360802959 AND ville_longitude_deg>5.4851343365919 AND ville_longitude_deg<6.8482056634081 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_cp IN ('54320','54250','54220','54130','54136','54520','54130','54690','54000','54100','54510','54770','54270','54600','54390','54690','54340','54140','54770','54420','54280','54180','54425','54180','54410','54770','54670','54770','54460','54670','54500','54760','54230','54280','54710','54770','54510','54760','54840','54280','54820','54230','54710','54840','54420','54850','54110','54670','54380','54610','54760','54940','54230','54210','54460','54380','54230','54210','54760','54760','54630','54610','54850','54610','54840','54210','54200','54550','54280','54110','54550','54385','54110','54840','54840','54760','54210','54380','54200','54380','54760','54760','54280','54114','54380','54210','54110','54280','54110','54210','54550','54760','54280','54110','54110','57170','54380','54550','54630','54160','54380','54380','54700','54610','54210','54200','54700','54990','57590','54380','54110','57170','57590','54123','54380','54110','54385','54370','54110','54160','54385','57590','54200','54280','54160','54280','57590','54700','54330','54385','54110','54210','57590','54370','57170','54200','57590','54200','54700','54134','54700','54330','54610','54110','57170','54610','54200','54360','54160','54200','54200','54370','54610','54610','54210','54700','54610','54700','54330','54385','54110','57590','54110','54200','57590','54210','54700','54330','54290','54380','54170','54290','54170','54170','54134','54610','54700','54370','54370','54385','54385','54740','54700','54610','54200','54360','54470','54610','54700','57170','54200','54200','54200','57170','54300','54113','54200','54370','54113','54290','54610','57590','57420','54330','54740','57420','57420','54610','54330','54370','57590','57590','54360','54370','54200','54385','54200','54700','54330','54370','54470','57590','54740','54200','57590','54470','54170','54330','57590','57590','54360','57420','54290','57170','54113','54370','54290','57590','54113','57590','54360','54740','54700','54290','54290','54740','54170','54113','54300','54200','54330','57420','54570','54700','54360','54330','54119','57170','54470','57590','54700','54370','54330','54370','57420','54300','54330','54360','57590','54470','54370','57420','57590','54700','54113','54300','57170','54470','54300','54300','54113','54121','54740','54740','57420','57630','54170','54360','54116','54740','57420','54290','54330','54170','54740','54170','54570','57420','54330','54300','54300','54470','54700','54470','57590','54740','57630','54700','54290','54300','54290','54170','54290','54370','54570','54370','57420','54470','54200','57630','54570','57590','57170','57170','54300','57420','54170','57420','54370','54300','54290','54115','57590','54300','54330','57170','54470','57590','57420','54740','54360','54370','54470','57170','57420','57420','54330','54290','57590','54290','54170','57580','54360','54115','57590','57420','57420','54740','54740','54530','54470','54300','54112','54470','57170','54830','57420','54116','57580','54370','54115','54115','54530','57420','54740','54330','54300','57680','54330','57590','57580','54290','54115','54115','54290','54290','57340','54530','54115','54470','57590','57630','54370','57630','57630','57170','55300','55190','57580','54830','54740','57580','57420','54930','57420','57420','57580','57340','55300','57340','57420','54470','54112','54170','54115','54290','57420','54290','54470','57170','57590','88300','57810','57170','54290','55190','54830','54470','57630','57420','54330','88130','54370','55300','57580','54470','57580','55190','54890','54300','55300','54470','54112','57340','57340','55140','88300','54300','54112','57420','88130','57420','54740','55200','54830','54890','57420','54930','54290','54930','54740','54470','54830','57580','57810','55140','57420','54290','54370','54930','88130','57630','54890','57680','57260','54930','54930','55200','55140','54470','57170','55300','54470','57680','54300','55140','54890','54890','88630','54115','57340','57340','54950','57580','54830','55210','57580','57580','54170','57420','88130','88130','54290','88130','54370','57580','54115','57580','54290','57245','54470','54830','57340','57130','57245','55140','57260','57380','57580','57260','57340','57340','55300','54950','54830','57810','55210','57130','57170','57580','54930','57810','57580','54115','57155','57170','54830','54300','57580','57380','57580','54470','57580','54115','55200','57340','55140','88500','55140','55140','57680','54115','88130','57176','57580','55190','57810','54115','88300','54930','88630','54118','55140','54830','54930','54115','57130','57245','88500','88130','57530','57340','57260','88500','54370','54830','55140','54470','88170','57340','57530','88130','54115','55140','57340','88300','57530','55200','55300','54370','54370','88170','54450','55140','57810','55190','88130','88630','55200','57380','55140','54470','57260','57260','88500','88500','57340','88500','88130','57380','57340','88170','54122','88330','55140','54122','88130','57245','88130','88500','57340','57580','55300','88630','88170','57130','88500','54470','57530','57380','88130','54129','55300','55210','57260','55200','57580','57530','54450','55140','55200','55140','54890','55140','57340','57530','88330','88500','54370','57260','57130','54450','54115','88170','55190','57158','57950','88500','88500','57380','55300','57340','55190','57160','57130','88700','88500','88130','54122','55200','88330','57340','55140','57160','57130','54450','57340','88170','88500','55140','57340','88130','57530','55140','57340','57260','57530','88500','57260','55210','88700','54800','57530','54450','57130','57260','88450','88500','88700','57530','57810','88500','57260','54450','57530','55190','54450','57530','57530','57130','88450','88700','54450','57050','88500','57050','57160','88500','88500','54800','88500','57260','57160','88330','88500','54450','57340','55210','57160','88500','88130','55200','57340','88300','88330','88500','88450','88630','57770','88500','57380','55190','54800','57530','57645','88170','55200','57130','57260','57340','88300','57690','54800','54450','88170','54450','55130','55200','57340','55190','54450','88630','88630','57070','57050','57000','88500','54450','57070','88500','57380','88630','57050','55190','55130','57690','57070','57070','88300','88300','88500','88700','88300','54450','57810','57530','88500','54800','55210','57530','57117','55300','88450','88500','88170','88700','54122','57810','54122','57117','55190','54800','54120','54122','88170','57117','88700','57810','88450','88700','55210','57050','88630','88170','54120','57260','54450','57530','54450','88170','57810','57260','55300','54450','57660','88500','57690','55160','57340','57690','88170','55130','88700','55160','88170','57670','57380','57140','88500','88170','88700','88500','88500','55190','54120','54450','88500','57220','55200','57070','88170','55210','57690','57640','88500','88630','88700','57385','57380','57385','57385','88700','88700','57640','88450','88440','55210','57670','55130','57220','54800','54120','88450','88500','55130','88700','54120','55200','55300','57260','55300','54120','88330','57930','54450','88270','55300','88700','54800','88330','57530','57130','54540','54800','88170','88170','57380','54450') 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='1087' AND wish_id<>'466465' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
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
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=83816 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 = 83816 AND W.type_id = 1) OR (W.util_id <> 83816 AND W.type_id = 2)) AND (M.post_util_id = 83816 OR M.dest_util_id = 83816) 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 = 83816
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
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=415279 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 = 415279 AND W.type_id = 1) OR (W.util_id <> 415279 AND W.type_id = 2)) AND (M.post_util_id = 415279 OR M.dest_util_id = 415279) 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 = 415279
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
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=383161 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 = 383161 AND W.type_id = 1) OR (W.util_id <> 383161 AND W.type_id = 2)) AND (M.post_util_id = 383161 OR M.dest_util_id = 383161) 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 = 383161
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
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=147800 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 = 147800 AND W.type_id = 1) OR (W.util_id <> 147800 AND W.type_id = 2)) AND (M.post_util_id = 147800 OR M.dest_util_id = 147800) 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 = 147800
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
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=67464 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 = 67464 AND W.type_id = 1) OR (W.util_id <> 67464 AND W.type_id = 2)) AND (M.post_util_id = 67464 OR M.dest_util_id = 67464) 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 = 67464
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
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=50991 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 = 50991 AND W.type_id = 1) OR (W.util_id <> 50991 AND W.type_id = 2)) AND (M.post_util_id = 50991 OR M.dest_util_id = 50991) 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 = 50991
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 n INNER JOIN util_info dest ON n.dest_util_id=dest.util_id INNER JOIN util_info post ON n.post_util_id=post.util_id INNER JOIN wish w ON n.wish_id=w.wish_id WHERE n.note_visu IN (1,2,3,4) AND n.post_util_id<>'7'
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10)
Contactez-nous