Discuter
Description de l'annonce
Recherche une piscine chauffée pour passer un petit moment de détente avec les garçons autour de Saint-amand les eaux
#piscine
Indiquer un code postal ou une ville
Poster une annonce
Discuter
Recherche une piscine chauffée pour passer un petit moment de détente avec les garçons autour de Saint-amand les eaux
#piscine
Annonces similaires
Tout voirLouer une piscine privée entre particuliers ou proposer une piscine privée en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
110€
Pour appeler mon voisin & organiser le rendez-vous.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom FROM filtredpt WHERE filtre_dpt=''
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='347367'
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 filtre_dpt='59'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='152913' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 152913
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 wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id FROM wish LEFT JOIN util_info ui ON wish.util_id=ui.util_id WHERE wish_id = 347367
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=929 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='347367'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='347367' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 152913 AND util_tel != ''
SELECT `stripe_account_id` FROM `util_info` WHERE `util_id` = 152913 AND stripe_account_id IS NOT NULL AND stripe_account_id != ''
SELECT M.match_step FROM `match` as M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 152913 AND W.type_id = 1) OR (W.util_id != 152913 AND W.type_id = 2)) AND (`post_util_id` = 152913 OR `dest_util_id` = 152913) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT round(AVG(note),1) as note_moy FROM `note` WHERE dest_util_id='152913' 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 = '347367'
SELECT w.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id 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='152913' AND wish_id<>'347367' 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='59230'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((50.45*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((50.45*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((3.35- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>50.000339197041 AND ville_latitude_deg<50.899660802959 AND ville_longitude_deg>2.6438131645938 AND ville_longitude_deg<4.0561868354062 HAVING distance <= 50 ORDER BY distance ASC
SELECT wish.*, ui.util_photo, ui.util_prenom, ui.util_nom, ui.stripe_account_id 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 (59230,59230,59178,59178,59870,59226,59310,59870,59690,59178,59226,59178,59310,59310,59310,59870,59230,59870,59870,59158,59158,59310,59230,59310,59158,59310,59230,59171,59171,59870,59171,59179,59135,59870,59158,59490,59310,59199,59135,59310,59490,59255,59494,59199,59590,59146,59148,59830,59195,59192,59124,59220,59195,59242,59494,59215,59220,59830,59410,59970,59830,59220,59174,59176,59235,59830,59580,59182,59156,59242,59860,59167,59194,59830,59176,59165,59310,59278,59194,59242,59121,59830,59780,59580,59121,59163,59970,59293,59172,59282,59880,59172,59287,59300,59182,59710,59125,59246,59710,59770,59287,59970,59710,59780,59224,59119,59273,59300,59282,59111,59283,59273,59830,59450,59300,59283,59152,59233,59234,59264,59169,59286,59252,59551,59262,59169,59152,59152,59252,59187,62790,59243,59224,59163,59111,59234,59111,59152,59990,59111,59710,59990,59252,59163,59990,59234,59239,59154,59950,59269,59151,59239,59990,59128,59269,59780,59500,59810,59296,59162,59227,59247,59551,62141,59553,59553,59552,59261,59295,59295,59198,59213,59169,59990,59990,59169,59510,59213,59920,59390,59247,59175,62820,62970,59169,59552,59990,59144,59269,59265,59141,59790,59141,59510,59247,59133,59260,59175,62112,59155,59113,59227,59227,59553,59390,59554,59151,59151,59265,59213,59213,59390,59139,59265,59144,62112,62590,62119,59151,59141,59188,62950,59530,59188,59390,59151,59530,59400,59115,62490,59144,62117,59133,62860,62490,59554,59370,62220,59147,62490,59268,59294,62860,59277,59139,62860,59144,59129,59170,59290,59263,59213,59213,59144,59161,59265,59112,59147,59161,59777,59350,59000,59160,59800,59530,59161,59265,59730,62490,59188,62490,62860,59530,59147,59150,62710,62640,62110,59554,59251,59655,59493,59650,62490,59491,59320,59161,62860,59110,59570,62860,59292,59530,62860,59120,59144,59259,59700,59530,59100,59730,59554,62880,62740,62860,59554,59320,59112,62490,59730,59570,59530,59530,59554,59217,59730,59130,59185,62320,62320,62860,59530,59400,59420,59214,59350,59320,62440,62118,59570,62420,62860,62156,59520,59570,59218,59218,62490,62156,59570,59400,59272,62580,59530,62320,59211,59200,59730,62118,59144,59910,59218,59144,62156,59320,62880,62880,59267,59136,59217,59217,62410,59118,62860,59530,59400,59184,59530,59221,62320,59320,59218,59400,59400,59570,62880,62221,62218,62860,62580,59271,62430,59840,59730,62680,59320,59320,59320,59134,59570,62580,62156,62118,59570,62182,62138,59160,62156,59217,59400,59157,59157,59400,59496,62580,62580,59540,62410,59540,62860,59320,59267,59530,59237,62118,62182,59274,59840,62156,62860,59134,59960,59840,62118,59281,59530,59134,59400,62300,59570,59159,59126,59250,59223,62410,59570,59570,62156,62210,62118,62580,59360,59400,59222,62138,59134,59496,59540,62580,59222,59134,62118,59570,62410,62300,59540,62147,59288,62860,59530,59241,62580,59222,59570,62182,59890,59480,62580,59159,59191,59550,62147,59191,59127,62128,59249,59225,59258,62860,59258,59550,62138,59360,62182,59280,59980,62128,59166,59480,62223,62860,62750,59249,62128,62223,62580,59267,59360,62138,59191,62128,59225,59930,59570,59117,62138,59116,59980,62800,59258,62147,59236,59980,59138,62128,59280,62580,62840,59360,59159,59890,59560,59127,62223,62147,62143,62840,62128,62128,62840,59360,62149,62580,62223,59138,62217,59138,62149,59550,62153,59980,59980,62128,59145,62223,62147,59560,62128,59750,59231,59145,62160,62980,62159,59193,59360,62128,62217,59266,62149,59330,62128,62223,59620,59360,62000,59600,59127,59127,62223,62147,59238,59127,59330,62160,59138,62147,62980,62149,62223,62217,62149,59550,62124,62124,59620,62153,62136,59600,59266,59850,62217,62128,62840,62124,62670,62217,62217,62160,59550,62128,62113,62113,02110,59360,59142,62144,59231,02420,62159,62840,62175,59330,62128,59330,59550,59137,62124,59360,62124,59360,62136,62114,59266,59600,62144,62124,59620,02110,59231,59550,62124,59600,62660,59360,62121,02110,59720,62136,59620,62121,62124,62161,62161,59600,62124,59297,62290,62172,62000,62113,59181,62159,02110,59620,62175,62450,59600,02420,59940,62144,62124,62530,62400,02110,02110,62530,62450,62175,59330,59330,62530,62173) AND fami_id='5' AND cate_id='176' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='929' AND wish_id<>'347367' AND wish_url='' ORDER BY rand() 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='929' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=102093 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 102093 AND W.type_id = 1) OR (W.util_id != 102093 AND W.type_id = 2)) AND (`post_util_id` = 102093 OR `dest_util_id` = 102093) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 102093
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='929' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=510508 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 510508 AND W.type_id = 1) OR (W.util_id != 510508 AND W.type_id = 2)) AND (`post_util_id` = 510508 OR `dest_util_id` = 510508) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 510508
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='929' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=436581 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 436581 AND W.type_id = 1) OR (W.util_id != 436581 AND W.type_id = 2)) AND (`post_util_id` = 436581 OR `dest_util_id` = 436581) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 436581
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='929' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=189424 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 189424 AND W.type_id = 1) OR (W.util_id != 189424 AND W.type_id = 2)) AND (`post_util_id` = 189424 OR `dest_util_id` = 189424) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 189424
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='929' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=256705 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 256705 AND W.type_id = 1) OR (W.util_id != 256705 AND W.type_id = 2)) AND (`post_util_id` = 256705 OR `dest_util_id` = 256705) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 256705
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='929' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=532245 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 532245 AND W.type_id = 1) OR (W.util_id != 532245 AND W.type_id = 2)) AND (`post_util_id` = 532245 OR `dest_util_id` = 532245) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 532245
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='929' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=102316 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 102316 AND W.type_id = 1) OR (W.util_id != 102316 AND W.type_id = 2)) AND (`post_util_id` = 102316 OR `dest_util_id` = 102316) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 102316
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='929' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=278122 AND note_visu IN (1,3,4)
SELECT M.match_step FROM `match` AS M LEFT JOIN wish AS W ON W.wish_id = M.wish_id WHERE ((W.util_id = 278122 AND W.type_id = 1) OR (W.util_id != 278122 AND W.type_id = 2)) AND (`post_util_id` = 278122 OR `dest_util_id` = 278122) AND buy_stripe_pi_id != '' AND buy_stripe_pi_id IS NOT NULL
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 278122
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 929
SELECT AVG(note) as note_moy FROM note WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT count(*) as nbwish FROM wish
SELECT note.*, post.util_prenom as postp, post.util_nom as postn, dest.util_prenom as destp, dest.util_nom as destn, w.wish_id, w.wish_desc, w.fami_id FROM note, util_info dest, util_info post, wish w WHERE note.wish_id=w.wish_id AND note.post_util_id=post.util_id AND note.dest_util_id=dest.util_id AND note_visu IN (1,2,3,4) AND post_util_id<>'7' ORDER BY note_date DESC, note_hour DESC
Contactez-nous