Discuter
Description de l'annonce
Bonjour, je cherche à louer pour mon chantier à Vaucresson prévu le 17/05, un echafaudage roulant de 8m de hauteur pour une durée de 10 jours. Merci #echafaudage
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Discuter
Bonjour, je cherche à louer pour mon chantier à Vaucresson prévu le 17/05, un echafaudage roulant de 8m de hauteur pour une durée de 10 jours. Merci #echafaudage
Autres annonces du voisin
Tout voirAnnonces similaires
Tout voirLouer un echafaudage entre particuliers ou proposer un echafaudage en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
350€
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='354220'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='echafaudage' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='66'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'echafaudage' 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='87'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='92'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='161132' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 161132
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 = 354220
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=66 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='354220'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='354220' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 161132 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=161132 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 = 161132 AND W.type_id = 1) OR (W.util_id <> 161132 AND W.type_id = 2)) AND (M.post_util_id = 161132 OR M.dest_util_id = 161132) 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='161132' 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 = '354220'
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='161132' AND wish_id<>'354220' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
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='65' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=161132 AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 161132
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='92420'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8333*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8333*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.175- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.383639197041 AND ville_latitude_deg<49.282960802959 AND ville_longitude_deg>1.4918795760945 AND ville_longitude_deg<2.8581204239055 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 ('92430','92420','92380','92410','92310','78170','92210','78220','78140','78150','92370','78150','78000','78290','78380','92100','92360','92190','78430','92800','92150','92500','78400','78870','92130','78560','78350','92000','78160','92140','78350','78530','78590','78110','92200','78750','92350','78620','92320','78210','92400','92170','78590','92250','78230','78420','78330','92240','78800','78360','78112','92330','92260','91570','92220','78100','92290','78117','92120','92700','92300','78280','91400','91430','91370','92270','91430','95870','78450','78860','94250','92110','92600','78600','94110','78390','92340','78117','78240','75011','78180','75000','75013','75010','75008','75018','75012','75003','75004','75005','75015','75014','75007','75002','75006','75009','75016','75019','75017','75001','75116','75020','94232','94240','94238','94236','94233','94234','94239','94230','94235','94231','94237','78500','92160','78960','78600','91190','91190','91300','78114','78240','93400','94260','78190','91120','95100','78340','78450','94270','92230','78300','78470','94800','94550','91400','91440','95530','94205','94200','78810','91140','95110','94150','93450','92390','78470','91320','93800','78470','91160','78370','78955','95370','95240','91940','78260','95218','95210','78630','91190','91940','94320','95130','91140','93310','94400','78990','93200','78460','93210','91380','91160','78700','94160','94220','93120','93300','95120','91160','93500','78810','93170','94140','95880','78670','78670','78570','93430','78121','91940','95220','91420','78320','78320','94390','94310','78850','94300','91400','95130','95230','91470','91550','94600','93100','94700','95360','78720','78570','93230','93260','93240','78720','78640','95600','78780','91470','91160','78640','95170','78310','78460','93380','95480','78540','91640','95250','95580','95580','94410','91620','78630','93350','78760','94290','91200','78320','95410','78510','78580','78310','95320','95610','91360','78640','94340','93000','95390','91620','91470','78480','78720','95160','91360','95000','95680','93440','94480','93130','94000','91470','91700','95550','95150','91390','91600','94130','93140','78580','91260','94120','78650','91460','78640','93110','95280','78920','93150','93700','94190','95140','78130','91270','78124','91310','91310','95350','78490','78690','94460','95000','91310','78124','94380','94170','78690','91560','95400','95200','91170','95500','78720','91240','95350','95000','94340','94100','94210','91640','95740','95400','91210','93250','78490','78490','91640','95310','95490','91470','91310','95300','95840','95180','78410','94360','95560','78650','91230','95330','78490','94500','91700','78580','94450','93360','94430','95440','78740','91350','78580','95800','95570','95430','78610','91680','91680','95540','93340','93320','95500','78740','78830','91220','78770','91220','78126','95460','91640','93330','95840','91700','78130','78770','91180','95300','94470','78490','95570','95650','78770','93220','78490','78490','78410','91000','91130','91330','95520','95570','94380','94370','78830','78250','94350','78770','95560','78490','95450','78720','78770','78490','78250','95720','95630','95430','95650','95560','91520','91340','78410','94880','94880','94490','91800','78610','91530','78410','93600','78410','95500','91290','95720','93270','78125','78250','91070','91290','78250','91450','93160','94420','93460','95650','95590','78770','91470','93390','93190','95720','95450','95500','91080','78680','94440','95190','93370','94440','91650','91650','95560','78250','95760','95300','91090','91000','91860','93420','78580','78940','78820','91630','78610','95300','78770','91630','94510','78490','91650','95650','95650','91530','95720','93410','91450','91630','95700','91800','95570','95450','78730','78730','77420','78970','78890','94520','94520','77181','78930','93470','95190','95450','78120','91410','91630','91090','94440','77500','95450','91790','95620','95270','77340','91530','95290','78930','78440','95850','91480','91630','95270','78120','78910','77185','93290','78910','77184','95810','95380','78250','78940','91250','77170','78610','95190','95590','91810','95450','95270','91250','91480','78790','78790','78440','95450','91910','91730','95690','91580','95690','95830','77186','77181','91730','95810','78490','78910','95660','78440','91280','91540','78790','77177','95830','95260','91530','78440','78440','77270','78930','77380','77150','95260','95850','95450','91100','95450','95380','91100','91710','78730','95810','95590','78440','78910','77200','91410','77360','77680','78120','78440','91540','91540','95690','91250','95690','78440','95380','95270','91410','91770','91730','78125','77127','77150','91580','95270','91540','95380','95810','95270','95450','95270','95270','91510','91510','95340','78930','77410','78910','77090','77183','95810','95450','95270','78910','95270','78520','77290','91850','77170','78930','78930','95380','78930','95270','95670','78200','78711','95270','78790','95450','77330','78440','95640','91580','91760','91580','78790','77990','95640','95640','95340','77990','95470','95450','77600','78125','95450','78730','77400','78550','78730','78200','60230','91610','77400','95640','78790','78950','91830','91250','95340','78440','78125','77173','95640','78200','78440','91750','78113','77600','77600','95820','77400','95470','77135','95510','95420','77164','78790','91410','78113','78200','77410','78550','77166','91580','78520','95640','60820','91590','95810','78200','77550','95640','95810','60530','77166','77400','78910','77600','95470','60260','78200','95640','78125','77176','77400','77230','77230','91410','77400','78790','91830','78660','95470','78125','77290','77230','95510','78200','77410','91750','91410','78113','77410','78200','60540','60540','95420','95450','60240','91590','60110','78910','95750','78550','78125','91580','78200','60580','77410','95750','95420','95420','78520','77400','77230','91870','60530','77600','95510','77550','78111','91590','78550','60560','60119','60530','77240','77410','78200','78125','60128','91590','77600','78550','77176','77144','78980','77410','60520','95420','60119','77220','78550','77111','78200','77230','60110','91150','60540','78125','78125','77170','60270','91590','91150','91410','91590','60540','78660','78113','77310','77240','60460','77230','95780','78910','91590','60530','28230','77550','78125','28230','78113','91150','78790','77700','77144','78710','60240','95510','60530','77240','78660','95420','78200','95420','77310','91750','77220','60119','91590','78660','60128','78790','78980','28410','77450','77230','77230','60240','77550','60240','91410','91150','77230','78520','77700','28410','60540','60110','60520','77111','78113','77220','60530','60240','91890','60175','77450','77220','28410','91780','91780','28320','78270','60460','78840','77390','95420','78270','95510','60530','91880','77310','60240','77950','95420','78270','77230','60173','60340','91410','78200','77410','28210','28560','28260','77174','77220','77410','60500','60240','60520','60340','95420','60240','77350','91410','77700','78980','78660','77410','60570','78660','28410','95780','77280','28130','28210','28700','91820','60500','91820','91840','60110','77950','78660','77700','28210','28560','91410','77165','28700','77700','60740','77230','95420','77230','28410','60330','77350','77410','77450','77950','60950','28130','77390','28260','77450','95420','77950','28320','77930','91490','95710','77165','77350','77930','77390','91780','28210','77165','77165','60240','60570','91150','77450','78980','77174','28320','28210','60240','95780','28700','60730','78840','77930','60300','60300','95510','77450','91720','78270','78980','91150','78980','77450','60240','77390','28410','77610','60730','60240','60149','77190','28260','77450','60240','28410','91490','77000','77000','60660','60240','77930','28700','60790','77610','91490','95710','77230','77610','77390','77580','28320','28410','27630','78270','77860','77950','60240','77190') AND fami_id='5' AND cate_id='87' AND type_id='1' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='66' AND wish_id<>'354220' 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='66' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=47931 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 = 47931 AND W.type_id = 1) OR (W.util_id <> 47931 AND W.type_id = 2)) AND (M.post_util_id = 47931 OR M.dest_util_id = 47931) 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 = 47931
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='66' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 47931
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='66' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 47931
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='66' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=117081 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 = 117081 AND W.type_id = 1) OR (W.util_id <> 117081 AND W.type_id = 2)) AND (M.post_util_id = 117081 OR M.dest_util_id = 117081) 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 = 117081
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='66' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=529626 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 = 529626 AND W.type_id = 1) OR (W.util_id <> 529626 AND W.type_id = 2)) AND (M.post_util_id = 529626 OR M.dest_util_id = 529626) 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 = 529626
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='66' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=517152 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 = 517152 AND W.type_id = 1) OR (W.util_id <> 517152 AND W.type_id = 2)) AND (M.post_util_id = 517152 OR M.dest_util_id = 517152) 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 = 517152
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='66' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=502359 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 = 502359 AND W.type_id = 1) OR (W.util_id <> 502359 AND W.type_id = 2)) AND (M.post_util_id = 502359 OR M.dest_util_id = 502359) 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 = 502359
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='66' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 502359
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='66' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=475225 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 = 475225 AND W.type_id = 1) OR (W.util_id <> 475225 AND W.type_id = 2)) AND (M.post_util_id = 475225 OR M.dest_util_id = 475225) 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 = 475225
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='66' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=435369 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 = 435369 AND W.type_id = 1) OR (W.util_id <> 435369 AND W.type_id = 2)) AND (M.post_util_id = 435369 OR M.dest_util_id = 435369) 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 = 435369
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 66
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