-50kg
qu'à l'achat
Description de l'annonce
Bonjour je cherche une location de piscine privée
#Piscine
Voir les annonces autour de moi Géolocaliser
Poster une annonce
-50kg
qu'à l'achat
Bonjour je cherche une location de piscine privée
#Piscine
Louer une piscine privée entre particuliers ou proposer une piscine privée en location.
Poster une annonce
-50kg
qu'à l'achat
Envoyer 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, 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='585286'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='piscine' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='929'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = '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='176'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('63' 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='448378' 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` = 448378
SELECT util_cp FROM utilisateur WHERE util_id=448378 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 = 585286
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=929 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 448378 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='585286'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='585286' 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=448378 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=448378 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 = 448378 AND W.type_id = 1) OR (W.util_id <> 448378 AND W.type_id = 2)) AND (M.post_util_id = 448378 OR M.dest_util_id = 448378) 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 = '585286'
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='448378' AND wish_id<>'585286' 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 ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='63130'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((45.7667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((45.7667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.05- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>45.317039197041 AND ville_latitude_deg<46.216360802959 AND ville_longitude_deg>2.4053938535912 AND ville_longitude_deg<3.6946061464088 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 ('63130','63400','63000','63100','63870','63830','63122','63110','63540','63170','63830','63122','63530','63530','63112','63118','63170','63200','63510','63670','63119','63450','63360','63530','63450','63210','63670','63970','63450','63670','63450','63200','63510','63210','63370','63960','63450','63800','63210','63200','63200','63450','63360','63210','63730','63111','63115','63230','63530','63230','63800','63200','63450','63230','63430','63800','63230','63360','63730','63210','63800','63730','63410','63230','63450','63140','63210','63800','63210','63320','63720','63430','63270','63270','63210','63970','63730','63117','63230','63730','63200','63410','63730','63200','63710','63720','63230','63910','63160','63720','63720','63200','63710','63270','63116','63210','63460','63200','63320','63200','63910','63320','63910','63200','63114','63114','63720','63720','63200','63320','63270','63270','63790','63160','63740','63160','63320','63230','63190','63270','63320','63840','63460','63720','63270','63320','63320','63190','63210','63190','63200','63350','63350','63200','63720','63160','63410','63160','63230','63320','63320','63720','63500','63460','63350','63320','63500','63500','63780','63790','63210','63260','63320','63320','63790','63230','63270','63770','63260','63320','63320','63320','63610','63410','63410','63160','63460','63460','63320','63500','63190','63410','63780','63740','63160','63190','63500','63350','63160','63820','63320','63460','63260','63240','63470','63270','63500','63500','63500','63260','63610','63500','63350','63380','63320','63190','63160','63460','63160','63160','63270','63260','63380','63260','63310','63500','63380','63820','63440','63160','63820','63500','63350','63150','63150','63260','63310','63470','63340','63440','63190','63390','63440','63190','63380','63340','63350','63500','63390','63350','63260','63440','63310','63470','63520','63500','63500','63340','63640','63500','63380','63260','63340','63260','63500','63390','63610','63340','63470','63520','63310','63500','63490','63950','63520','63490','63420','03800','63340','63340','63390','63760','63490','63440','63290','63440','63380','63340','63310','63420','63500','63260','63340','63300','63290','63520','63120','63680','63440','63490','63340','63610','63440','63310','63920','63380','63520','63310','63440','63290','63490','63490','63490','63390','03800','63340','03800','63470','63680','63120','63570','63380','63760','63310','03800','63640','63520','63340','63340','63560','03800','63120','63560','63470','63340','63380','63440','03450','63420','63120','63570','63640','63290','63690','63113','63290','63690','63570','63760','63340','63340','63520','63390','63390','63390','63570','63470','63620','63380','63340','63310','63420','63420','63570','03450','03450','63420','63590','63300','63580','63560','63340','03800','63380','63300','03110','03800','63310','19340','63560','03800','63680','63750','63490','63290','03450','63580','63120','03800','03450','63590','03700','63340','63570','63580','03800','63420','63290','63850','63340','63850','63850','63580','63880','63570','63810','63590','63120','63650','03110','63620','63930','63120','63330','03110','63330','03450','23700','63550','03270','19340','63330','63330','03450','43410','63330','63700','63750','63620','63700','03110','63980','63700','43410','15190','19340','63330','03800','63850','63580','63250','15190','03330','43250','63570','03270','63330','63550','03330','63580','19340','63880','63890','03800','43410','63690','63980','63570','63580','63690','63620','03270','23420','43390','03330','03140','03700','43250','03200','63550','19340','63810','63700','63880','63810','23100','19200','63590','03140','03200','63420','63330','03330','23700','43450','03110','03110','15190','03140','43450','63580','23260','63290','63250','63120','03270','63580','43360','03200','03110','63330','43390','63980','63690','63700') AND fami_id='5' AND cate_id='176' AND type_id='1' AND ssrubr_id='929' AND wish_id<>'585286' 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='929' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=532984 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 = 532984 AND W.type_id = 1) OR (W.util_id <> 532984 AND W.type_id = 2)) AND (M.post_util_id = 532984 OR M.dest_util_id = 532984) 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 = 532984
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