Louer un aspirateur laveur karcher FC7
Prix
25€/jour
-65kgqu'à l'achat
2x moins cher qu'en magasin
Description
Je souhaite louer le modèle avec 4 rouleaux qui aspire et lave en même temps. #nettoyeur vapeur
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Longeville (25330) · publié depuis 3 mois ou +
Discuter
Prix
25€/jour
-65kgqu'à l'achat
2x moins cher qu'en magasin
Je souhaite louer le modèle avec 4 rouleaux qui aspire et lave en même temps. #nettoyeur vapeur
Annonces similaires
Tout voirLouer un nettoyeur vapeur entre particuliers ou proposer un nettoyeur vapeur 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='340814'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='nettoyeur-vapeur' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='983'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'nettoyeur-vapeur' 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='110'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('25' 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='145011' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 145011
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 = 340814
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=983 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 145011 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='340814'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='340814' 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=145011 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 = 145011 AND W.type_id = 1) OR (W.util_id <> 145011 AND W.type_id = 2)) AND (M.post_util_id = 145011 OR M.dest_util_id = 145011) 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='145011' 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 = '340814'
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='145011' AND wish_id<>'340814' 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='25330'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((47.05*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((47.05*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((6- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>46.600339197041 AND ville_latitude_deg<47.499660802959 AND ville_longitude_deg>5.3400471084369 AND ville_longitude_deg<6.6599528915631 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 ('25330','25440','25330','25330','25440','25440','25440','25330','25440','25440','25290','25330','25440','25290','25330','25440','25330','25440','25330','25330','25330','25440','25440','25440','25290','25270','25290','25440','25440','25440','25440','25440','25330','25440','25440','25290','25330','25440','25620','25440','25270','25660','25440','25330','25440','39110','25440','25270','25270','25270','39110','25330','25440','25440','39110','25440','39110','25440','25330','25660','25320','25320','25290','39600','25440','25620','25320','25270','39110','25320','39110','25320','39110','25440','39110','39600','25620','39110','25410','25320','25270','25720','25440','39600','25320','25720','25270','25320','25840','25111','25330','25620','39110','25320','25320','39110','25270','25620','39110','25840','25720','25720','39330','25660','39110','25580','39110','25270','25720','25620','39700','25410','25580','39330','25330','25610','39110','39110','25410','25620','39110','39600','39110','25270','25410','25320','25580','25520','25930','39110','25660','25580','39600','25410','25560','39110','25580','39600','25620','39700','25320','25410','25920','25410','25580','39700','25620','39600','39600','25770','25660','39600','39110','25660','25520','39380','39110','25580','25620','39700','39380','39700','25770','25660','25560','25520','25000','25410','39600','39300','39700','25620','25170','25770','25115','39110','39380','39700','25580','39700','25520','25170','25170','39600','25580','25520','25580','25410','25520','39380','25660','25410','39600','25170','39600','25480','39300','25580','25580','25560','39600','25410','39700','39250','39600','25560','25480','25560','25220','25220','25300','39350','39700','25520','25360','25520','39380','25560','39600','25170','25170','25580','25480','39300','25170','25560','39600','25360','25170','39300','39250','39380','39700','39250','25220','25170','25170','25220','39300','39380','25580','25560','25170','25520','39350','25170','39700','39600','25300','39600','25410','39250','25300','25800','39700','39600','25170','25360','25170','39250','25870','25220','39250','39250','39380','25870','39250','25870','25870','39700','39800','39600','25300','25300','39300','25220','25580','39350','25800','25220','39300','39250','25520','25170','25360','39350','25800','39350','39800','25560','39700','25300','39250','25640','39800','39250','25870','39250','39300','39250','39700','25580','39380','39250','25170','25220','25170','39800','39300','39300','39350','25300','25360','25170','39300','70150','25170','25170','25360','25530','25170','39380','70150','39700','39700','25300','39700','25360','25640','25170','39800','70150','39800','39800','39250','25870','39800','70190','25870','39250','25960','39380','25870','39250','39350','39380','25870','39250','25870','39300','70150','25690','25360','70150','25870','39300','70190','70150','25360','39700','25160','25160','39800','39800','25170','70150','39350','39800','25300','39380','39700','25360','39350','39300','25110','39700','39380','25820','25530','25650','25640','39250','25650','39700','39800','39350','39300','70190','70190','39250','39300','25530','39700','70150','25160','25160','25530','39800','39700','70150','25640','25640','39250','39300','25160','39300','25690','70700','25530','70150','25300','25870','25640','25160','39380','70140','39700','39800','39800','39700','25360','25650','39800','25640','25160','39300','39250','25690','25650','70190','25530','39800','25690','39700','39800','25870','70700','70190','39100','70150','39250','39300','25650','70150','39300','25300','25160','39250','25640','70150','25650','39300','39800','25160','25870','25870','39300','25530','25690','25530','39290','39800','70150','25640','25650','25160','39800','70140','70140','25640','25640','39800','25530','39800','39100','39380','25650','70190','70190','39120','25110','25640','70140','39250','39120','25640','25640','70190','25640','70700','25240','39100','25510','39290','25360','39230','70190','25110','25870','70150','25300','70140','39800','39290','39290','39100','39120','39800','70700','25530','39290','39230','70150','25110','70700','70140','39230','39300','25360','25110','39100','25370','39300','39150','39800','02126','25510','39300','70190','25240','25240','39300','39100','25240','25360','70140','25240','39100','70190','39300','25390','39120','39120','25640','25110','39210','39300','25240','25530','25510','39230','25300','25370','25370','25510','39290','39300','39230','39290','39800','25640','39300','25370','25370','39290','39150','39100','70190','25240','25240','39230','25110','25370','39100','25240','39300','25640','25110','25530','39290','25370','70190','39230','70190','39230','70190','39230','39290','25640','39100','70190','70700','02406','39230','70700','39300','70700','39290','39290','25390','39120','70140','70190','39120','39210','25370','70700','25500','25530','39100','70190','70140','25360','25240','39290','25510','39100','39210','39120','70140','39210','39230','25790','39290','25640','02117','39100','70700','25110','39290','25240','25240','39150','39150','39290','39210','70140','25390','25640','25640','39230','39460','39290','02127','01454','25390','39100','25110','25640','70700','25570','70100','70190','02116','25110','39230','39230','01454','39290','39210','39210','39120','39210','25370','70700','70700','25640','39570','39230','25360','39130','39230','39500','70700','25110','70100','39130','70700','70140','25390','25110','39230','39120','39210','70140','25390','21130','39500','39120','70230','25640','70190','02406','39150','70190','70700','70100','70100','25530','39130','39120','25430','70190','25640','39120','39230','39230','39230','25390','39120','70230','02123','02115','70140','25110','25640','70100','39500','25110','70140','25510','39210','39210','70700','39230','01450','21270','25110','39130','39230','39230','25680','39120','70100','21130','70190','21130','39570','70190','01450','39230','39520','39210','02406','39130','70230','39120','39500','21130','25500','25390','25500','70700','70230','02124','39500','70100','01338','70700','70700','70190','39130','01452','70230','25110','39230','70100','25110','25680','25510','21270','25680','01343','70140','01337','70700','70190','39140','39210','39230','01357','02113','39130','25680','02114','39210','21130','39150','70190','39570','25430','21270','01453','25110','25110','25500','21170','39230','01450','01446','25680','70100','39230','39120','25500','21130','70190','25680','70100','25110','70700','39210','70190','70230','01345','25680','70130','39130','25210','71270','25430','39210','39230','39410','01355','25110','39120','02406','39150','01345','39570','25340','70230','70190','21130','02112','01342','25210','39120','21170','39130','70100','01439','70100','70100','39570','01325') AND fami_id='5' AND cate_id='110' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='983' AND wish_id<>'340814' 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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=411997 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 = 411997 AND W.type_id = 1) OR (W.util_id <> 411997 AND W.type_id = 2)) AND (M.post_util_id = 411997 OR M.dest_util_id = 411997) 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 = 411997
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=24151 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 = 24151 AND W.type_id = 1) OR (W.util_id <> 24151 AND W.type_id = 2)) AND (M.post_util_id = 24151 OR M.dest_util_id = 24151) 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 = 24151
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=359441 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 = 359441 AND W.type_id = 1) OR (W.util_id <> 359441 AND W.type_id = 2)) AND (M.post_util_id = 359441 OR M.dest_util_id = 359441) 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 = 359441
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=326402 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 = 326402 AND W.type_id = 1) OR (W.util_id <> 326402 AND W.type_id = 2)) AND (M.post_util_id = 326402 OR M.dest_util_id = 326402) 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 = 326402
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=317201 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 = 317201 AND W.type_id = 1) OR (W.util_id <> 317201 AND W.type_id = 2)) AND (M.post_util_id = 317201 OR M.dest_util_id = 317201) 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 = 317201
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=208531 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 = 208531 AND W.type_id = 1) OR (W.util_id <> 208531 AND W.type_id = 2)) AND (M.post_util_id = 208531 OR M.dest_util_id = 208531) 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 = 208531
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=151979 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 = 151979 AND W.type_id = 1) OR (W.util_id <> 151979 AND W.type_id = 2)) AND (M.post_util_id = 151979 OR M.dest_util_id = 151979) 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 = 151979
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=46093 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 = 46093 AND W.type_id = 1) OR (W.util_id <> 46093 AND W.type_id = 2)) AND (M.post_util_id = 46093 OR M.dest_util_id = 46093) 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 = 46093
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