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