-150kg
qu'à l'achat
Description de l'annonce
Je loue mon déshumidificateur d'air/clim mobile de très bonne qualité.
#Deshumidificateur
Voir les annonces autour de moi Géolocaliser
Poster une annonce
-150kg
qu'à l'achat
Je loue mon déshumidificateur d'air/clim mobile de très bonne qualité.
#Deshumidificateur
Louer un deshumidificateur air entre particuliers ou proposer un deshumidificateur air en location.
Poster une annonce
-150kg
qu'à l'achat
Envoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
-150kg
qu'à l'achat
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='415371'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'deshumidificateur' 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='87'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('59' 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='236940' 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` = 236940
SELECT util_cp FROM utilisateur WHERE util_id=236940 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 = 415371
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=775 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 236940 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='415371'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='415371' 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=236940 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=236940 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 = 236940 AND W.type_id = 1) OR (W.util_id <> 236940 AND W.type_id = 2)) AND (M.post_util_id = 236940 OR M.dest_util_id = 236940) 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 = '415371'
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='236940' AND wish_id<>'415371' 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 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='65' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 236940
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='49' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 236940
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='72' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 236940
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='756' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 236940
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='25' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 236940
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='41' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 236940
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='33' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 236940
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='59169'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.3167*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.3167*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.16667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>49.867039197041 AND ville_latitude_deg<50.766360802959 AND ville_longitude_deg>2.4624652035945 AND ville_longitude_deg<3.8708747964055 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 ('59169','59169','59151','59234','59182','59287','59287','59169','59234','59176','59234','59169','59165','59187','59176','59265','59182','59580','59151','59151','59580','59450','59247','59151','59252','62860','59169','59151','59167','59265','59247','59252','59552','59490','59119','59146','62860','62112','62112','62490','59247','59500','59252','59552','59194','62490','62860','59215','59172','62860','59265','59490','59111','62490','59870','62860','62860','59870','62860','59554','62117','59179','59259','59553','59553','62860','59265','59295','59295','59111','59194','59265','59268','59172','59553','59171','59111','62860','59554','59148','62490','59128','59141','59286','62860','62156','59554','59156','59870','59171','62156','59124','62490','59400','59293','59950','62860','59554','59554','59870','59141','62490','62156','59111','59283','59870','59161','62118','59141','62790','62860','59161','59310','59171','62182','62970','59220','62118','59282','59554','59282','59283','62156','62141','62860','59161','59870','62182','62490','62156','59400','59870','62490','59310','59267','59255','62156','59296','62950','62860','59310','59400','59135','59178','59162','59161','59220','62118','59310','62580','62118','62156','62119','59178','59277','59267','59235','62860','59246','59310','59400','59121','59230','59178','62182','59220','59400','62320','62320','59198','59195','62118','59400','62147','59230','59135','62118','62860','62147','59159','62110','59188','62128','59121','62182','59129','62580','62118','59224','59239','59310','59400','62320','62580','59195','62860','59710','59281','59261','59310','62580','62128','59188','62640','59178','62590','59217','59551','59310','62820','62320','62128','59224','59494','62420','62740','59310','59690','59239','62580','59227','59227','62710','59242','59159','59125','59400','59710','59267','59241','62580','59233','62128','59226','62580','59174','62223','59188','59292','59230','59400','62147','62147','62128','62128','59494','59227','62680','62128','62220','59217','59226','59400','59217','59590','59551','59310','62223','62580','62128','62430','62440','59242','62159','59217','62147','59710','59410','59213','62880','59242','59159','62128','59214','59133','59192','59710','59258','59300','59157','62128','62221','62218','07624','59294','59258','59269','62147','62210','62128','62580','62217','59213','07611','62124','59157','59133','62124','59300','62217','59273','59830','59231','62223','62880','62880','59158','62580','59300','59127','59112','59830','59258','62124','07623','62147','59830','62300','62128','59730','62880','59860','62159','59540','59213','59213','62300','62223','62128','59269','59147','59191','59230','59770','62000','59113','07621','62217','62124','59880','62217','59158','59273','59540','62223','07620','59266','59730','62124','59830','59730','62128','62124','59230','07610','59271','62175','59730','59990','59830','59185','62223','62223','59191','59251','62410','59158','62580','59269','59175','62124','59830','59213','59213','59199','62217','62217','62121','62121','59175','59147','62124','07618','62410','59730','62159','59112','62450','62580','07620','62124','59147','62223','59191','07620','59990','59262','59990','59830','59231','59266','59810','59231','07620','59199','59225','59221','07620','59158','59540','62410','62450','59127','59530','62175','07502','59263','62124','59780','07622','62800','59278','62153','59155','62138','59139','62124','59225','59540','59990','62750','62410','59970','59990','07620','59530','07504','59266','62175','62121','62121','59272','62450','62450','07506','59139','59127','59297','62143','59152','59152','59264','62450','59152','59790','59144','62121','59730','59127','59780','62121','59184','59496','62173','62000','59360','59530','59980','59970','02420','62175','59218','59218','62124','62124','62138','62217','80360','07641','59970','07500','07522','62153','59243','07500','62450','59980','62124','59127','59142','59136','62450','59163','62121','62161','62161','59218','80360','59530','62144','62450','62175','59218','59274','59260','59152','02420','59530','59320','80240','07608','59496','62450','62173','80122','62144','59530','62121','07522','59320','62160','80360','07522','62138','59144','07640','59980','59980','62161','59980','07501','59530','62160','59990','62450','62450','59238','62450','07604','07642','59990','07640','59222','62160','59222','59134','59120','62116','59211','62450','80360','62138','62450','07521','62121','59360','59510','07522','80740','07640','07643','59480','59144','59780','59360','62161','59144','62173','02420','62123','59134','80240','02420','59134','59320','62980','62144','59000','59800','59160','59350','59777','07500','62123','62116','62450','07536','59154','62116','07387','59320','62173','59163','59530','59134','80240','80360','59920','02110','59530','62138','62116','59530','59370','07503','59480','02110','59530','07604','59144','80240','62144','62149','62980','59144','07538','59390','62149','59222','07600','62670','62121','02420','80740','62123','59530','59510','62172','59320','59320','07603','02420','07520','07548','07604','59360','62114','59163','62149','80112','59530','07387','07387','59110','59320','62149','62123','62123','59530','07530','62144','62530','62123','07387','59320','07601','80360','59550','07380','62690','62450','80360','59137','59288','80300','59360','59130','62690','62530','07380','59320','02110','07604','07320','62111','59249','80360','07904','80300','62113','62113','62840','07350','59134','59170','59290','80240','62450','62116','62123','59550','59570','59390','07540','62123','62123','80300','59360','07520','59350','59390','62690','07540','07387','07602','59249','59700','07604','07531','02420','80360','62123','80360','59144','62123','02110','59360','62530','59390','07730','80360','59160','02110','62690','80760','80240','80240','02420','62116','62290','07382','07387','62123','62690','59840','62149','62840','07534','62123','80240','07387','62690','59144','07321','07387','07350','59520','62123','07730','80300','59840','02420','59491','59493','59650','59655','62660','07743','07743','62113','80360','07542','59360','80240','02420','02110','62690','80200','59115','59530','02420','80300','07971','59570','07971','59840','62690','59570','62111','80360','07532','59570','07321','59118','62810','07730','07904','02110','02110','62150','07971','62620','07730','02420','02110','07322','02110','62111','62136','62690','07971','62123','59280','02110','07543','07370','59237','80240','02110','62450','80300','62111','07350','07370','59100','02490','59570','02490','59420','80240','59150','80240','59570','59360','80200','07533','07740','62150','07972','62131','59910','62111','07540','62690','62131','62131','07534','62810','07973','62111','59550','07906','62620','80240','62810','59360','07387','80240','02420','62158','07387','62136','07322','62150','80200','62158','07730','59570','62690','62810','59570','02110','62400','62690','62620','62840','80200','02420','62111','80360','80300','62158','59570','07370','07350','62690','62136','07540','62810','07973','59200','02230','07730','80300','02490','80300','07387','62620','62940','07904','07712','80360','62400','07730','62232','02420','07742','59930','80300','59360','80200','07740','62690','80300','62400','59360','07972','62196','62690','62150','59570','62810','07760','62840','62158','02420','62690','62150','59280','80300','02630','80200','80360','07901','07760','80200','80200','07370','62232','62232','62760','07760','62232','07911','59890','02420','02630','80300','80300','07972','59116','62810','80360','07334','59550','59570','07300','02490','59193','62111','02490','80200','02110','62840','62158','59223','59250','59126','08587','80200','80240','02110','80240','62199','80560','80560','59550','62127','62111','80560','02110','80300','07700','07711','62150','62127','07903','59570','62810','62760','59145','59236','07911','07340','59940','07910','80300','02110','62810','62700','02450','07903','80300','80360','02630','07900','07900','80300','08587','07903','07700','62136','62920','02100','02100','62232','07783','07970','80200','62122','59145','80560','07334','07911','62127','59960','02490','62810','59253','80240','62150','80240','02100','08510','07330','59570','62127','02100','07760','07301','62127','59138','08587','59850','62760','59550','07910','80300','59890','02450','62127','07333','62920','07332','80200','07950','80560','62150','62810','59138','59620','62158','80560','02110','07760','80200','02100','80340','07910','62760','07340','07911','59620','62127','62150','80340','59550','07340','62810','59570','07782','80200','07910','07910','59550','02110','02110') AND fami_id='5' AND cate_id='87' AND type_id='1' AND ssrubr_id='775' AND wish_id<>'415371' 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='775' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=392478 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 = 392478 AND W.type_id = 1) OR (W.util_id <> 392478 AND W.type_id = 2)) AND (M.post_util_id = 392478 OR M.dest_util_id = 392478) 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 = 392478
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='775' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=114058 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 = 114058 AND W.type_id = 1) OR (W.util_id <> 114058 AND W.type_id = 2)) AND (M.post_util_id = 114058 OR M.dest_util_id = 114058) 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 = 114058
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 775
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 775
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