Discuter
Description de l'annonce
Bonjour, j'aurais besoin de louer un échafaudage pour 1 journée pour installer un luminaires hauteur 5m20. #echafaudage
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Discuter
Bonjour, j'aurais besoin de louer un échafaudage pour 1 journée pour installer un luminaires hauteur 5m20. #echafaudage
Annonces 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é
35€
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='409545'
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='77'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='230220' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 230220
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 = 409545
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=66 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='409545'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='409545' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 230220 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=230220 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 = 230220 AND W.type_id = 1) OR (W.util_id <> 230220 AND W.type_id = 2)) AND (M.post_util_id = 230220 OR M.dest_util_id = 230220) 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='230220' 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 = '409545'
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='230220' AND wish_id<>'409545' 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='77164'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.8214*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.8214*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.70472- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.371739197041 AND ville_latitude_deg<49.271060802959 AND ville_longitude_deg>2.0217617813923 AND ville_longitude_deg<3.3876782186077 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 ('77164','77135','77183','77090','77600','77600','77600','77600','77600','77600','77680','77400','77400','77200','77400','77144','77186','77360','77184','77700','77185','77330','77400','77174','77400','77400','77340','77700','77144','77420','77700','77220','77177','77400','77174','77700','94510','77220','94420','77500','77450','93160','77410','77220','77150','77700','77610','93460','77410','94350','77450','77450','77150','77580','77173','77450','94880','94880','94490','77220','77181','77410','77860','77450','93330','93370','77610','77860','77410','94500','77181','93470','94360','94370','94380','94430','77270','77450','77220','77610','77410','93220','77170','93360','77450','94440','77580','77580','94100','94210','94340','94170','77580','77410','94440','93390','93190','77163','77166','77390','77860','77610','94470','77450','93410','77163','77410','94130','93340','93320','77610','77410','93250','94120','77170','77163','77410','93110','77580','94440','77100','77170','94380','94340','77610','94520','94520','93270','93290','94000','77610','77410','94410','77124','77100','93130','77580','77410','77100','94450','91330','77111','77111','77290','91480','94460','77166','77580','77515','93140','77390','77124','77470','91800','93600','77230','77380','77580','77580','94700','77290','94300','77515','91800','77390','77165','77540','93420','93100','93000','91860','77165','77165','93260','93230','94190','94220','94160','94140','91480','77390','77124','93170','77230','77390','77515','77230','77470','77230','77470','94600','91560','77165','77580','77124','93150','93700','77390','77131','77580','94400','77550','77515','77390','77550','77470','77390','77470','77990','91230','77230','77470','94290','93310','77540','94205','94200','77230','77122','94310','94390','77127','77390','93500','77550','77390','77120','94480','77230','95700','77120','94320','77515','77910','93350','77165','77540','94270','77120','77390','94800','77131','77470','77720','91270','77990','91200','77910','77550','93440','77230','77230','77580','95500','95500','91250','93120','93300','77230','95500','77390','77910','91210','95380','77540','77230','95500','77950','77120','95140','77540','77950','94550','91450','75011','75015','75019','75007','75116','75020','75008','75012','75009','75018','75017','75016','75010','75014','75013','75004','75006','75001','75000','75002','75005','75003','77910','77540','77660','77139','77390','94150','94250','91450','91280','77230','94110','91550','77720','93240','94239','94235','94236','94238','94234','94237','94240','94232','94233','94231','94230','77165','77165','95400','77120','95380','95190','77720','95380','77540','91250','91000','91090','91260','77178','93210','93200','77230','95380','77176','77950','92120','91130','91000','77950','77178','93400','77440','91250','77120','77139','92340','77115','91320','77660','77440','77240','95470','77120','60330','77280','91170','77640','60330','77240','95720','91100','77720','93380','94260','92240','92170','77176','92220','92390','93450','77950','77440','77139','77950','77720','91350','91420','77120','95360','93430','92160','95400','95200','95470','92110','92320','77370','60950','92330','92260','77260','77260','91390','91600','77720','60330','77139','77169','60440','77260','95190','77720','95410','95720','95350','95380','77141','60330','77440','91080','95440','92300','91830','91250','92130','92230','77440','77440','92140','77000','77000','60440','91360','77115','60128','92600','77240','93800','92350','77440','77440','91300','91100','91700','91090','77350','95170','91160','91380','77720','95880','92290','95670','77169','91070','92200','77820','77120','95470','77510','95190','77370','91370','91360','92100','77720','77310','95160','77970','60128','77640','95850','92270','95720','95350','77000','92190','92360','77720','77120','77310','95460','92400','91700','92250','77190','60950','77260','77350','60440','95850','91540','91540','95230','60950','77440','95218','95210','91160','77139','92800','92150','92700','95470','77350','77169','77370','95720','91700','91120','91160','77310','60440','77440','95270','91160','95580','95580','60620','92210','77320','77970','77000','95270','91830','95330','91140','91540','95270','95270','77440','95100','60620','95570','91240','77145','77169','77260','60620','77820','91220','91220','77750','91570','95600','95120','60620','60520','92310','95110','92370','91430','77370','95570','77260','77750','60560','77820','91310','91620','95270','77510','77370','92410','91540','92500','77590','77320','60520','91810','95680','91750','95870','91140','77590','92000','60440','77320','77370','95570','92380','60520','78140','91430','91310','91310','95270','77190','78800','60300','60300','60300','77440','77138','60620','77370','95390','91750','77320','91750','92420','92430','77510','77320','95130','77370','95570','95270','91710','77970','77260','77370','77930','77840','95560','77590','91620','78220','78420','77750','77730','95270','60620','95320','60620','95130','77930','60440','78350','60890','77510','91630','60440','77370','95560','60300','91610','95270','91310','91460','77930','60580','77510','91400','77970','77750','91400','95560','60440','60620','78500','78170','77730','95560','91630','95240','77370','77440','78400','77320','77840','95530','77920','91180','60620','77730','77850','60260','91290','77970','91440','77930','60620','95840','77370','77133','78000','78360','77630','77750','91770','78290','78380','60890','95370','77320','02310','77930','78530','78350','91940','77320','77320','95590','77133','60300','78150','95270','91290','77510','91840','95150','95550','95250','77930','91630','77160','02310','77830','78600','77730','60300','91940','78150','60800','91590','95270','78430','77830','77840','77870','91190','91760','78560','60890','02810','91630','95740','77320','78117','77370','78110','60300','60300','95840','60810','77160','95270','60810','95220','91630','77750','95590','78600','60800','91890','91590','02310','77630','60300','91680','60800','77560','91340','91520','60620','91190','77520','91940','91190','02310','60800','91490','77510','02810','95480','91640','77154','91850','60620','60500','78230','77830','77210','60890','02310','77154','78117','60270','60890','60800','60500','95590','78870','77510','91590','78160','77560','02310','95540','60810','77320','60810','78750','60620','02810','78100','60820','77160','95260','77320','91400','77630','91490','60890','91640','60300','02810','91510','91510','77320','78210','78590','91790','77300','77210','91490','78620','77160','95430','95630','91590','02310','77160','78280','91730','95260','78112','77810','60800','77560','02310','77430','02810','60117','77510','78470','02310','77650','95290','02310','91680','91650','95820','60740','78700','78114','60300','95430','60141','77520','78330','78590','60800','95660','60890','77560','95760','60800','77160','95340','77520','95620','77650','77320','60700','77520','77130','95340','91650','78960','91590','77510','60340','02460','91640','60460','78470','77520','77160','60141','91820','02810','95610','60340','91730','02400','77670','02810','02310','77520','78260','91470','77670','77148','78300','91590','60810','60810','78180','91640','77650','77560','77320','02810','91650','60810','77520','91470','78460','91470','78240','91730','91910','95310','78570') AND fami_id='5' AND cate_id='87' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='66' AND wish_id<>'409545' 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=264968 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 = 264968 AND W.type_id = 1) OR (W.util_id <> 264968 AND W.type_id = 2)) AND (M.post_util_id = 264968 OR M.dest_util_id = 264968) 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 = 264968
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=34164 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 = 34164 AND W.type_id = 1) OR (W.util_id <> 34164 AND W.type_id = 2)) AND (M.post_util_id = 34164 OR M.dest_util_id = 34164) 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 = 34164
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=157450 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 = 157450 AND W.type_id = 1) OR (W.util_id <> 157450 AND W.type_id = 2)) AND (M.post_util_id = 157450 OR M.dest_util_id = 157450) 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 = 157450
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=499872 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 = 499872 AND W.type_id = 1) OR (W.util_id <> 499872 AND W.type_id = 2)) AND (M.post_util_id = 499872 OR M.dest_util_id = 499872) 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 = 499872
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=495841 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 = 495841 AND W.type_id = 1) OR (W.util_id <> 495841 AND W.type_id = 2)) AND (M.post_util_id = 495841 OR M.dest_util_id = 495841) 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 = 495841
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=464382 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 = 464382 AND W.type_id = 1) OR (W.util_id <> 464382 AND W.type_id = 2)) AND (M.post_util_id = 464382 OR M.dest_util_id = 464382) 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 = 464382
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=180117 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 = 180117 AND W.type_id = 1) OR (W.util_id <> 180117 AND W.type_id = 2)) AND (M.post_util_id = 180117 OR M.dest_util_id = 180117) 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 = 180117
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=439233 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 = 439233 AND W.type_id = 1) OR (W.util_id <> 439233 AND W.type_id = 2)) AND (M.post_util_id = 439233 OR M.dest_util_id = 439233) 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 = 439233
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=321076 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 = 321076 AND W.type_id = 1) OR (W.util_id <> 321076 AND W.type_id = 2)) AND (M.post_util_id = 321076 OR M.dest_util_id = 321076) 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 = 321076
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=418051 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 = 418051 AND W.type_id = 1) OR (W.util_id <> 418051 AND W.type_id = 2)) AND (M.post_util_id = 418051 OR M.dest_util_id = 418051) 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 = 418051
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