Réserver
Description de l'annonce
Offrez-vous un moment de détente inoubliable #jacuzzi
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Réserver
Offrez-vous un moment de détente inoubliable #jacuzzi
Annonces similaires
Tout voirLouer un jacuzzi entre particuliers ou proposer un jacuzzi en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
90€
Pour appeler mon voisin & organiser le 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 filtre_dpt=''
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='637091'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='jacuzzi' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='827'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'jacuzzi' 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='92'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='91'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='531626' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 531626
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 = 637091
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=827 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='637091'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='637091' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 531626 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=531626 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 = 531626 AND W.type_id = 1) OR (W.util_id <> 531626 AND W.type_id = 2)) AND (M.post_util_id = 531626 OR M.dest_util_id = 531626) 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='531626' 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 = '637091'
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='531626' AND wish_id<>'637091' 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='91360'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.6667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.6667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.31667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.217039197041 AND ville_latitude_deg<49.116360802959 AND ville_longitude_deg>1.6358107950714 AND ville_longitude_deg<2.9975292049286 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 ('91360','91360','91700','91160','91600','91390','91160','91380','91420','91700','91240','91160','91620','91310','91170','91160','91310','91310','91700','91260','91350','91220','91220','91140','91140','91620','91550','91460','91070','91120','91310','91320','91210','91130','91000','91300','91270','91200','91080','91180','94480','94260','92160','94150','91370','91290','91450','91430','94290','91090','91230','91090','91000','91400','91290','91940','91940','94310','94390','91630','91630','91560','91430','91680','94550','91440','91450','91810','91630','92290','91570','91520','91340','92340','91630','94320','94190','91640','91540','94235','94239','94238','94237','94230','94231','94232','94233','94234','94236','94240','92330','92260','91400','94600','91250','91640','92350','91710','91100','91630','91190','91940','91800','91250','91540','91540','94450','91680','91100','94400','91540','94460','91190','91330','91280','91400','91860','91650','92220','94110','91770','91790','92320','92140','94800','91250','78350','91650','91190','91640','91480','91800','91730','91640','91610','94380','94140','92190','92360','92120','91760','91850','92240','94250','91650','94440','91470','94000','91510','94270','91510','92130','94700','92370','91750','91470','78117','94470','91530','94205','94200','78350','78530','91250','91830','94520','94520','78470','78117','77127','78140','91730','91910','91480','94220','91730','91470','77380','78220','92170','94440','91590','92310','92100','94440','91580','91830','91750','94370','94380','91530','94410','91470','91470','78114','92410','78460','94160','94340','94100','94340','78000','94210','77170','91580','91590','91470','77176','92210','94430','78470','92430','92420','91580','78280','94880','94880','94490','91530','77240','78830','77550','91580','75007','75008','75009','75010','75018','75017','75000','75016','75011','75012','75013','75015','75006','75014','75003','75001','75002','75005','75004','75020','75116','75019','78960','91590','92380','78460','94300','77170','94130','94500','91580','91590','91590','91590','77310','78150','77176','91530','91580','91750','92800','92150','77150','78470','77550','77166','93170','94510','78720','78180','78210','77240','91410','77310','94360','78150','78170','94120','93100','91890','78830','91590','91590','92200','77150','94170','78720','77240','78720','94420','77310','93310','94350','93110','91840','93260','93230','92500','91410','91150','78330','78720','77340','77350','77166','93330','93400','92110','78380','91880','78290','91820','92300','92400','91820','78730','78730','77173','77550','92250','93130','91490','78390','91410','78190','78870','93360','78430','93500','77930','77930','78320','78590','77111','78400','78720','92600','92000','77950','77930','93160','78590','78320','77550','93250','77184','77350','91150','77350','93000','77930','91490','77330','91720','77950','92270','78160','91870','77170','93140','78560','91490','92700','93120','93300','78320','77680','91150','77185','78450','77190','93460','78620','91410','93220','78800','77420','77950','91410','77190','77111','78420','78750','77930','78340','77950','77930','93450','92390','92230','77000','77000','78110','93320','93340','93210','93200','78990','91150','78860','91720','78112','78730','78360','78230','93350','95870','78730','78120','78310','77186','77950','78100','91150','78690','77390','93150','93700','78310','77220','91720','93800','91490','78370','77090','77183','77000','77000','93370','77135','77500','77630','91780','91780','77200','78450','77630','77390','95100','93240','78610','91150','91150','91410','77220','93440','78125','93430','93190','93390','77390','91410','91720','78500','77360','78600','77390','78690','78120','78760','78240','77220','77164','77390','78730','77950','95880','77177','95210','95360','95218','78660','93380','77630','91490','93270','95110','77600','78600','77220','91150','78810','77181','93470','78240','95140','95500','91150','78610','91720','77600','77600','93600','95530','77590','78640','93410','77400','91410','77115','91150','95230','95170','95410','95120','91150','77181','78490','78300','77390','91690','91720','78120','77390','78850','78640','95130','91150','78810','77400','78640','77590','91410','95400','77220','77123','77115','77400','77600','91410','95240','91780','91690','95500','95370','91410','78490','78490','78490','77720','77600','77400','77610','78610','77270','91150','77123','93420','78640','91690','78630','78121','77410','95580','95160','95580','95600','95350','91720','91690','77600','95200','95400','93290','77390','95130','91690','78955','78125','77400','78260','77390','77123','78660','77720','78660','91740','77820','78700','77610','95500','95220','91690','78660','78650','77144','77590','77400','78490','78490','95680','95350','95500','95390','91150','78670','78670','77400','91150','77390','78490','77174','95320','95440','28700','78660','77610','45300','77760','78570','77760','77700','95720','95250','95700','91740','77920','78650','77820','28700','78125','91930','77410','78580','95190','95480','77390','77610','77390','78125','78490','78610','77720','45330','95330','77144','78124','78630','77700','45330','78570','95460','77300','77850','78580','78770','77700','78660','77760','78660','78780','78540','77174','78490','77610','95150','95550','95720','45330','77290','78125','45300','77210','78124','77610','95610','77410','77870','77720','78510','77410','77760','91740','77720','28700','77210','78490','77760','77410','91660','95570','95570','45330','95570','95560','78480','77700','78770','77390','77720','95840','95380','77450','91660','77133','78940','95000','78920','78770','95720','77450','28700','78125','95740','77820','77760','77410','78130','77760','95190','77610','78490','78770','78125','77700','78770','45300','78580','77990','95280','28700','95380','78580','45300','28310','95560','95560','28700','45330','95000','78890','28320','77720','77450','77450','95840','95720','28700','45300','78770','77580','77133','77410','28700','77290','95310','77990','45300','78410','77410','78126','78940','95000','95850','95540','91670','28700','77810','95380','95300','77760','95190','77540','95490','28700','95430','77163','77450','95380','77860','28230','28700','95180','77720','77760','95380','78125','95560','77430','95590','95570','77230','77410','77760','77540','95270','78740','77230','77780','78910','28700','28700','28230','78125','77410','78410','77230','95800','95270','45300','77860','78770','77450','28700','77830','28700','95430','95630','77450','77760','45330','95300','78130','77540','45480','78740','95850','78910','77450','78410','78410','77760','28700','45300','28320','77163','78410','77540','28700','77230','95650','78580','78250','28310','95470','95520','77880','77690','28700','77580','77580','77163','45300','95670','95270','77760','78113','77580','78680','28320','77370','77720','28700','45300','45330','77670','28700','78113','77720','77230','78250','45390','28700','77250','95450','78910','95760','45390','45390','78930','77860','78950','78125','77515','78125','77540','78250','77410','28320','77230','95650','77830','95270','95270','78113','78910','95270','77760','77230','78250','77230','77131','28130','77165','28310','77140','45480','77250','95470','77230','95470','95650','77670','78550','78910','78790','78790') AND fami_id='5' AND cate_id='92' AND type_id='1' AND ssrubr_id='827' AND wish_id<>'637091' 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='827' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=503171 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 = 503171 AND W.type_id = 1) OR (W.util_id <> 503171 AND W.type_id = 2)) AND (M.post_util_id = 503171 OR M.dest_util_id = 503171) 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 = 503171
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='827' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=441640 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 = 441640 AND W.type_id = 1) OR (W.util_id <> 441640 AND W.type_id = 2)) AND (M.post_util_id = 441640 OR M.dest_util_id = 441640) 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 = 441640
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='827' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=118871 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 = 118871 AND W.type_id = 1) OR (W.util_id <> 118871 AND W.type_id = 2)) AND (M.post_util_id = 118871 OR M.dest_util_id = 118871) 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 = 118871
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='827' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=382884 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 = 382884 AND W.type_id = 1) OR (W.util_id <> 382884 AND W.type_id = 2)) AND (M.post_util_id = 382884 OR M.dest_util_id = 382884) 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 = 382884
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='827' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=322190 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 = 322190 AND W.type_id = 1) OR (W.util_id <> 322190 AND W.type_id = 2)) AND (M.post_util_id = 322190 OR M.dest_util_id = 322190) 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 = 322190
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='827' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=229781 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 = 229781 AND W.type_id = 1) OR (W.util_id <> 229781 AND W.type_id = 2)) AND (M.post_util_id = 229781 OR M.dest_util_id = 229781) 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 = 229781
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='827' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=214500 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 = 214500 AND W.type_id = 1) OR (W.util_id <> 214500 AND W.type_id = 2)) AND (M.post_util_id = 214500 OR M.dest_util_id = 214500) 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 = 214500
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='827' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=206852 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 = 206852 AND W.type_id = 1) OR (W.util_id <> 206852 AND W.type_id = 2)) AND (M.post_util_id = 206852 OR M.dest_util_id = 206852) 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 = 206852
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='827' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=204283 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 = 204283 AND W.type_id = 1) OR (W.util_id <> 204283 AND W.type_id = 2)) AND (M.post_util_id = 204283 OR M.dest_util_id = 204283) 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 = 204283
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='827' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=140667 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 = 140667 AND W.type_id = 1) OR (W.util_id <> 140667 AND W.type_id = 2)) AND (M.post_util_id = 140667 OR M.dest_util_id = 140667) 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 = 140667
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 827
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