Discuter
Description de l'annonce
Cherche un monospace à louer. Pour partir en vacances en famille en Vendée besoin d'un 6 places mini. #monospace
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Discuter
Cherche un monospace à louer. Pour partir en vacances en famille en Vendée besoin d'un 6 places mini. #monospace
Annonces similaires
Tout voirLouer un monospace entre particuliers ou proposer un monospace en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
900€
Pour appeler mon voisin & organiser le 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 filtre_dpt=''
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='411088'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='monospace' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='994'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'monospace' 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='81'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='59'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='232193' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 232193
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 = 411088
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=994 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='411088'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='411088' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 232193 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=232193 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 = 232193 AND W.type_id = 1) OR (W.util_id <> 232193 AND W.type_id = 2)) AND (M.post_util_id = 232193 OR M.dest_util_id = 232193) 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='232193' 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 = '411088'
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='232193' AND wish_id<>'411088' 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='59920'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.3833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.3833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.66667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.933639197041 AND ville_latitude_deg<50.832960802959 AND ville_longitude_deg>2.9614767973589 AND ville_longitude_deg<4.3718632026411 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 ('59920','07387','07380','59990','07387','07380','59243','07382','59990','59154','07387','07387','59264','07387','07387','07350','59970','59990','07387','07387','07370','07370','07350','59163','59990','07350','59144','59144','59144','59163','07387','59278','07370','59570','59970','59990','59144','59570','07387','59880','07350','59570','59770','07387','59144','07322','59860','59163','59570','07370','59300','07320','59990','59570','07300','07322','07321','59990','59970','59570','59144','07340','59300','59530','59192','59410','59144','59269','59570','07301','59300','07330','59590','07334','59530','07321','59570','59494','59530','59570','59269','07340','07603','59144','59174','07340','07973','07340','07333','59199','59530','07334','07973','07390','59570','59494','07080','07600','59530','07080','59125','59570','59530','59199','07972','59570','59570','59269','07390','07080','59195','07971','59233','07332','07331','07040','07080','59530','07012','59135','59530','07608','59213','59530','59195','59530','59121','07601','07971','59230','07040','59230','59220','07012','07040','59213','59213','59213','59530','07971','59158','59224','59230','59224','07971','59570','59121','59227','07602','07080','07332','59530','59220','59213','59213','07040','59135','07033','07950','07040','07970','07604','59255','07040','07011','07604','59178','59138','07604','59158','07972','07604','59750','07040','07024','59158','07040','59178','59138','59530','07040','59730','59220','59600','59218','07050','07904','59158','59330','59226','07904','59218','59218','07972','07950','07022','07604','59171','07022','07022','07000','07050','07622','07640','59138','59600','59282','59530','07950','59530','59730','07041','07050','59294','59227','59227','59330','07022','07903','07020','59282','59145','59218','07620','59198','59178','59124','07032','59138','07951','59620','59230','07538','59156','07903','59600','59171','07640','07050','59870','07623','59600','59330','59293','59288','59145','07020','07950','59178','07802','07534','59330','07812','07620','07870','07643','59230','59600','07950','59870','59171','07030','59720','07022','59296','59226','07621','59620','59730','59172','07620','59870','59600','07050','59730','07620','07903','07906','07640','59188','07041','07641','59730','07624','59111','59550','59550','59179','59690','59310','07530','59222','07034','07901','59188','59600','59215','07812','59222','07812','07620','07050','07031','59131','07812','59620','07900','07900','07801','07940','07642','59111','59600','59490','07534','59188','07811','59730','59620','59870','59172','59550','07940','07941','59600','07034','59222','07942','07120','07810','59330','59330','07620','59550','59680','59620','07870','59111','07870','59550','59310','59330','59310','07061','07812','59870','07021','59550','07800','07500','59292','59129','07521','07911','07870','07536','07532','59680','07120','07120','59310','59245','59168','07911','07943','59440','07120','06560','59271','59490','07531','07618','59360','07812','59141','59214','59680','07533','07070','07904','59870','07803','59580','59111','59277','59440','07548','07911','59580','59252','07911','07120','07070','07120','07611','07500','59440','07110','59440','59870','59360','07540','59440','07061','07870','07506','59310','59164','59295','59295','59680','07120','07120','59252','59165','07911','07063','07110','59252','59360','07130','07800','07540','07500','07861','07911','07070','07804','59360','59550','07610','59146','59141','59141','59680','07830','59360','07830','59310','07540','59460','59176','07504','59680','07822','59440','59360','59310','07830','07120','07823','59440','59540','07760','07070','06560','59217','59540','59740','07911','07822','59217','07063','59540','59161','59740','59680','07501','07502','59234','59244','07910','59176','59216','59360','59540','07804','07130','07910','59217','07110','59244','59830','07822','07543','59310','59400','59680','59182','59244','59550','07760','59247','07910','07540','59161','59440','59157','07120','07131','59247','07503','59980','59148','59216','59216','07830','07100','07134','59310','07522','59830','07890','59234','07830','59740','59161','59554','59149','59157','07910','07910','59440','59360','07910','07130','59167','59400','07542','59234','07134','06560','07110','59287','59182','07861','59440','59980','59440','59830','59830','07100','07522','59440','59740','59554','59161','06567','07060','59242','59265','07062','07830','59225','59740','07912','59169','07910','59247','06567','07060','59400','59217','07866','59194','59980','06560','59740','07522','59360','59287','59740','59780','59268','07522','59169','06567','07100','06560','59440','07912','59360','59149','02110','59191','59400','07743','07890','07830','59265','59830','59151','07520','59830','07110','59554','59440','02450','59265','59194','07910','59554','59780','59400','59740','07133','59550','59360','59235','02110','07760','07860','07134','07862','59225','59242','07070','07866','59980','59980','59265','07743','07100','59191','06542','06560','59149','59310','59740','59740','07100','59119','59450','02450','59360','59400','06543','07890','59242','59187','02170','59400','59177','07760','59177','06567','07750','59191','62860','07863','07880','59400','07134','07520','59152','59151','59265','59169','59127','07730','06540','07141','07090','09600','07090','07190','02450','07190','07864','59830','02450','59273','07190','59152','59152','59169','07740','59554','59267','02630','07170','59710','59152','59238','59740','59710','07750','07742','07750','59554','07830','59780','02110','59246','06470','02170','59137','07170','59286','07181','02170','07730','59219','59710','59283','07750','59151','07140','07140','62860','59262','01547','06500','59740','06500','59283','07191','06530','59273','59127','02110','02110','07850','07141','07850','62860','07090','07740','59219','07730','59281','07170','59177','59258','07170','62860','06533','59500','59552','01541','06500','06540','59740','59127','07750','59151','62790','06470','59390','59400','59169','06150','07760','02110','01430','59258','08587','59551','59219','09660','08587','62860','59151','02260','08587','59241','09500','07730','07090','59553','59553','59128','06500','59950','09500','59552','07730','59159','07170','59390','06470','59267','59510','62112','06530','07760','09500','59510','62112','02510','07850','59115','08583','59710','09500','59127','06532','59127','07160','09690','09500','62490','59390','59810','08582','02170','09690','02260','59239','09690','09690','62860','62860','07160','62141','02630','59390','06500','07180','62860','59159','07730','59258','59162','07090','01430','07730','62490','59239','09661','07160','09660','07181','09690','06511','01540','09500','09500','02110','06531','59551','09681','59553','08554','02260','08510','59610','59261','62970','62860','62490','02450','02450','02510','08580','62117','02510','01570','09570','01570','07090','09688','06470','06140','59132','06141','07711','59260','59790','59259','59132','59142','02170','59400','62860','09660','09660','08581','01430','06536','02630','02110','59175','08552','02110','59212','59132','06142','01430','62860','06500','62860','62820','59150','62860','07181','09500','08581','01460','62147','06500','09680','02620','08551','59155','06183','09572','09680','05650','59175','02510','06536','02420','59290','59170','02450','06470','59133','59266','06181','59132','02120','09570','62156','09700','62490','06111','59113','02260','62950','09660','09680','62490','06182','09506','62119','62490','07712','59370','06534','59139','59132','09506','01570','09571','62156','59267','08573','62590','08572','62860','06030','01404','07181','06440','59266','09790','02260','59100','59491','59493','59650','59655','62147','02110','09506','07700','01480','09660','62182','02110','62860','09506') AND fami_id='5' AND cate_id='81' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='994' AND wish_id<>'411088' 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='994' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=546985 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 = 546985 AND W.type_id = 1) OR (W.util_id <> 546985 AND W.type_id = 2)) AND (M.post_util_id = 546985 OR M.dest_util_id = 546985) 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 = 546985
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='994' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=361537 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 = 361537 AND W.type_id = 1) OR (W.util_id <> 361537 AND W.type_id = 2)) AND (M.post_util_id = 361537 OR M.dest_util_id = 361537) 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 = 361537
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='994' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=312998 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 = 312998 AND W.type_id = 1) OR (W.util_id <> 312998 AND W.type_id = 2)) AND (M.post_util_id = 312998 OR M.dest_util_id = 312998) 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 = 312998
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='994' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=94184 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 = 94184 AND W.type_id = 1) OR (W.util_id <> 94184 AND W.type_id = 2)) AND (M.post_util_id = 94184 OR M.dest_util_id = 94184) 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 = 94184
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='994' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=91698 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 = 91698 AND W.type_id = 1) OR (W.util_id <> 91698 AND W.type_id = 2)) AND (M.post_util_id = 91698 OR M.dest_util_id = 91698) 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 = 91698
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='994' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=25973 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 = 25973 AND W.type_id = 1) OR (W.util_id <> 25973 AND W.type_id = 2)) AND (M.post_util_id = 25973 OR M.dest_util_id = 25973) 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 = 25973
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 994
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