Cherche location robot piscine
Prix
40€/jour
-40kgqu'à l'achat
Description
Bonjour
Je recherche pour une journée la location de robot De nettoyage pour une piscine de 13x4. #robot piscine
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Attiches (59551) · publié depuis 3 mois ou +
Discuter
Prix
40€/jour
-40kgqu'à l'achat
Bonjour
Je recherche pour une journée la location de robot De nettoyage pour une piscine de 13x4. #robot piscine
Annonces similaires
Tout voirLouer un robot piscine entre particuliers ou proposer un robot piscine 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='294253'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='robot-piscine' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='1115'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'robot-piscine' 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('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='83665' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 83665
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 = 294253
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=1115 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 83665 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='294253'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='294253' 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=83665 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 = 83665 AND W.type_id = 1) OR (W.util_id <> 83665 AND W.type_id = 2)) AND (M.post_util_id = 83665 OR M.dest_util_id = 83665) 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='83665' 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 = '294253'
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='83665' AND wish_id<>'294253' 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='59551'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.5*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.5*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.08333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.050339197041 AND ville_latitude_deg<50.949660802959 AND ville_longitude_deg>2.3763958452443 AND ville_longitude_deg<3.7902641547557 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 ('59551','59239','59710','59246','59551','59239','59710','59710','59261','59133','62820','59235','59710','59310','59283','59242','59113','59162','59273','59242','59133','59283','59175','62790','59175','59147','62590','62141','59112','62220','59310','59147','59286','59155','59263','59273','59139','59950','59810','59194','59147','59310','59830','59251','59242','62119','59139','62970','59148','59262','59790','59112','59310','59128','59830','62950','59310','59185','59830','62710','59830','59194','62880','59320','62640','59272','59320','59553','59553','59119','59260','59120','59152','59152','59136','59830','62740','59870','62110','59184','59830','62440','62410','59167','59221','59310','59310','59211','59152','62880','62880','59320','59000','59500','59800','59160','59350','59777','59830','59780','59450','59310','59320','59870','62138','59310','59553','07611','59496','62880','59370','62420','59152','59146','59134','59780','59274','59552','59510','62490','59182','62410','59110','59320','59320','07610','59552','59187','59134','59320','59134','62221','62218','59130','59287','59870','59320','62320','62320','59320','62490','07502','59182','59287','62138','62410','59310','59690','62430','59350','59496','59134','59870','59780','62320','59870','07522','59700','59230','59169','59160','59510','59176','62112','62410','62680','59490','59226','59390','59170','59290','62117','59169','59840','59480','59176','59134','62300','59178','62320','07618','07522','07624','07504','59840','59520','59230','62490','59249','59870','59870','62138','59840','59178','59480','59169','62580','62580','59490','59118','62112','07522','07506','07522','62490','59491','59493','59650','59655','59390','59249','62210','07620','62300','59390','59237','07520','59169','62138','62580','59179','59390','59165','62490','62138','07621','07623','59280','62580','62750','59580','07501','07500','07620','59171','59151','59910','62490','59169','62840','59420','07730','59226','59151','07620','59100','07620','59171','62840','59178','62149','07620','62580','59234','07500','07503','62580','59115','59580','59178','62149','62118','62580','59215','59151','59151','59930','59150','62118','59234','62800','62840','62580','62490','59200','07520','07730','07620','07500','62149','59158','59280','59890','62490','62980','62580','59171','07730','59116','62118','07641','62143','62149','62160','59234','07730','07521','62136','07622','59230','07712','62580','62149','59158','59223','59250','59126','62860','62980','62580','62118','59259','59151','59193','59158','07730','07743','59236','07642','62118','59124','62156','59265','07536','07743','62840','62118','59252','59135','62156','07640','62153','07548','62160','07540','59172','07783','59158','62113','62113','59230','59230','62670','59252','07740','62136','59890','62156','59247','07730','59156','62860','62860','62840','62860','62860','62580','59255','62860','07730','59960','62156','59220','07542','62660','59850','59265','62223','59172','07640','07643','07700','62136','62160','07700','07540','07904','62114','59135','07782','59560','62156','59247','62118','59252','62153','62223','62223','59111','07740','62156','59293','62223','62113','62290','07780','07780','59111','07784','59166','62860','59199','59117','62860','62156','59247','07742','07531','59940','59195','62223','62400','59560','59220','62144','07711','07784','07530','07640','62400','59494','62860','07543','59181','07538','59111','59282','59253','59195','59199','62172','59220','08587','62136','59265','62530','59590','62223','62223','62128','59295','59295','07604','62182','08940','62860','59554','62223','62860','62128','62131','62131','62144','62128','08510','07608','59494','62400','62530','62182','08930','59265','62217','59111','59121','62131','62000','08510','59282','08587','59192','08957','07540','62530','59265','07760','08511','07532','08950','59141','59174','62182','59268','59940','07604','07781','62144','59121','59410','62232','62620','08930','62232','62232','08952','59554','62860','62128','08587','07604','62620','59970','62860','62217','08930','62217','07533','62128','08510','62232','07604','59940','08560','59554','07534','62161','62161','59141','07760','59400','62196','59224','62232','62217','62217','62128','08554','59860','08940','07760','62128','07540','62920','62182','08953','59554','62690','59125','62144','59296','59141','59660','62690','59554','07534','59161','62199','07760','62350','62000','62150','59278','08902','62690','08980','62620','62940','07760','07601','08510','07604','08950','59161','59270','62620','62217','59163','08583','62860','62690','59300','62161','59233','62350','07600','59970','59880','62128','08956','59224','08951','07602','59198','07906','62122','62150','62920','59161','62128','59300','59554','59300','62144','62161','62690','59770','62860','07603','62860','62128','62128','08552','62920','07910','62175','08501','59270','07904','62860','59400','08582','62690','59970','08980','62700','59267','07910','59270','62150','62690','07911','62123','08902','62350','62150','08958','08560','62217','62128','59277','59161','59227','59400','62690','08500','62173','59188','07760','62350','59232','59264','62150','62123','08902','62128','62128','08980','62147','07971','62122','59400','08551','59269','08890','08501','08560','07901','08550','07971','62150','62123','59213','59270','59267','59188','07910','59227','59227','07750','62690','62147','62175','59129','07910','07910','07911','59163','07911','62350','62123','62123','59270','59269','59990','08880','08580','62690','59243','62121','08900','59990','62159','07750','62540','07910','59400','07971','07320','07971','62123','59213','62175','59990','07750','07750','62150','59163','59400','08954','07321','07910','59159','62123','62173','62690','62175','07904','59990','62173','62147','62121','62350','07900','07900','59154','09690','08880','62540','62690','59270','08970','62157','59400','62460','08900','59270','08520','62350','08553','62175','59217','62127','07911','62690','07750','62121','59990','62124','59281','59188','59269','62150','08980','62123','62690','07910','07972','59292','07911','07903','62159','59213','59213','07972','08880','07912','62690','62173','08530','59294','62159','62470','08900','62147','59267','62123','62123','07972','62121','62127','62147','59990','62460','59190','62810','07903','59299','07912','59144','08581','62147','62190','07350','62124','59159','07321','59920','08570','07973','62124','07387','62150','59990','62123','59400','08908','08890','62260','62470','59241','07903','08540','07380','09690','62151','59190','59217','08570','62810','62124','59530','59214','62690','59190','09690','09690','08573','59400','08900','08860','62330','59217','07911','59213','59213','08581','62121','62121','59400','59217','62116','59159','62190','62450','07350','62116','08980','08531','07322','07973','62260','59530','62123','59730','62810','62450','07812','62127','59144','08531','62123','07380','59270','59730','62124','62116','62190','08572','62460','62121','59157','08791','09600','62127','59190','62123','62450','59190','62810','07387','07322','62810','62550','62111','59730','62810','62121','59157','07812','59258','62127','59144','07812','07387','62123','62116','59730','59530','59189','62147','59258','62127','07970','59114','59231','62190','62124','62330','59189','62450','08570','59730','08970','62450','08906','08800','08570','59530','62124','62130','62810','62810','08870','59144','08904','07382','08792','07350','62158','59540','59144','62260','62550','07387','08710','62127','09690','62550','08920','62127','08920','07387','62190','62190','62450','59127','59271','62550','62124','59258','62121','62190','62120','59540','07812','07812','62450','62127','62810','62450','59530','59114','07950','07812','59530','07950','09790','07387','08920','62124','62124','62127','07387','08870','07334','08840','62450','08770','59191','62550','62550','59189','07802','62260','08800','62450','59114','62124','07370','07911','62158','59218','59218','62121','08710','09700','09681','08870','59144','59266','08840','62111','62127','62127','07350','59530','62116','08640','07801','07387','07370','62111','62120','59191','62158','08710','62127','59570','62124','08904','09790','62550','62120','07890','62550','59218','08790','62450','62130','59190','62111','59730','07950','08800','59190','07951','59530','09790','59530','62810','59173','07332','59540','62120','62158','59218') 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='1115' AND wish_id<>'294253' 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='1115' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=5220 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 = 5220 AND W.type_id = 1) OR (W.util_id <> 5220 AND W.type_id = 2)) AND (M.post_util_id = 5220 OR M.dest_util_id = 5220) 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 = 5220
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='1115' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=274825 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 = 274825 AND W.type_id = 1) OR (W.util_id <> 274825 AND W.type_id = 2)) AND (M.post_util_id = 274825 OR M.dest_util_id = 274825) 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 = 274825
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='1115' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=443309 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 = 443309 AND W.type_id = 1) OR (W.util_id <> 443309 AND W.type_id = 2)) AND (M.post_util_id = 443309 OR M.dest_util_id = 443309) 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 = 443309
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='1115' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=266691 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 = 266691 AND W.type_id = 1) OR (W.util_id <> 266691 AND W.type_id = 2)) AND (M.post_util_id = 266691 OR M.dest_util_id = 266691) 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 = 266691
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='1115' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=100486 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 = 100486 AND W.type_id = 1) OR (W.util_id <> 100486 AND W.type_id = 2)) AND (M.post_util_id = 100486 OR M.dest_util_id = 100486) 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 = 100486
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