Prix
Faire offre
Description
Location de 30 chaises pour le 28 mars. #chaise
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Discuter
Prix
Faire offre
Location de 30 chaises pour le 28 mars. #chaise
-8kg
qu'à l'achat
Annonces similaires
Tout voirLouer des chaises (reception) entre particuliers ou proposer des chaises (reception) en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un 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 CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('' USING utf8mb4) COLLATE utf8mb4_general_ci
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='281461'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='chaise' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='859'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'chaise' LIMIT 1
SELECT c.cate_id, c.cate_title, cate_title_aff, cate_title_slug, c.fami_id, f.fami_title, f.fami_url FROM category c, family f WHERE c.fami_id=f.fami_id AND c.fami_id='5' AND c.cate_id='176'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('78' USING utf8mb4) COLLATE utf8mb4_general_ci
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='69665' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 69665
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 = 281461
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=859 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 69665 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='281461'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='281461' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=69665 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 = 69665 AND W.type_id = 1) OR (W.util_id <> 69665 AND W.type_id = 2)) AND (M.post_util_id = 69665 OR M.dest_util_id = 69665) 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='69665' 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 = '281461'
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='69665' AND wish_id<>'281461' 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='78260'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.9667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.06667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.517039197041 AND ville_latitude_deg<49.416360802959 AND ville_longitude_deg>1.3817239280719 AND ville_longitude_deg<2.7516160719281 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 ('78260','78570','78570','78700','78955','78780','78300','78510','78670','78670','78600','95000','95280','95610','78540','78480','78600','95000','95000','78100','95490','78240','78230','95220','78630','95180','78360','78240','78110','95530','95370','78500','95800','78740','95480','78112','78750','95300','78130','95240','95650','95310','78560','78740','78420','78630','78400','78920','78620','95520','78160','95250','78800','95450','95650','95300','78130','95870','78430','78290','78380','78410','92000','78250','78580','95130','95450','78250','95130','95650','78590','78870','95150','95550','95430','78810','78250','95110','78121','92500','78860','95100','95650','95650','78250','78250','95450','78450','78170','95740','95320','92700','78410','95120','95450','95540','78810','78590','95300','78580','78450','78150','78580','92250','95300','92400','95390','92270','78410','95210','95218','95430','95630','95450','78820','95600','78126','95840','92380','78150','95450','78124','95840','92800','92150','95450','95810','78330','95680','78580','92430','92420','78850','95830','95230','78410','78410','92600','95560','78124','92200','95830','95580','95580','92230','78250','92300','92210','95760','93800','78340','95450','92410','95880','78440','95450','78680','78210','95810','92110','78440','78370','95810','78390','78000','78640','95450','92310','78440','95570','78440','78970','95690','95450','78650','95170','95160','92390','93450','78220','95450','95620','92100','93430','95560','95640','95640','95810','95690','78140','95590','78770','95810','95450','95290','78640','95360','95640','95410','95450','78440','95330','93400','92370','78190','78440','95640','95690','78440','95560','78770','78640','78440','95350','78580','95640','95570','93200','93210','95690','92190','92360','78440','93380','78990','78640','92130','95350','78930','78280','78180','95560','78770','95420','78930','78650','92170','95570','95640','78350','78530','95660','95640','95460','93240','95400','95200','78770','78350','95510','78770','75001','75000','75002','75003','75004','75005','75006','75007','75008','75009','75010','75011','75012','75013','75014','75015','75016','75017','75018','75019','75020','75116','78770','95260','92140','78440','78760','95440','93120','93300','78770','95590','78490','92240','95810','95640','78960','95810','78440','95750','95420','95450','95260','95750','78117','92320','78520','60240','78930','92120','95340','78310','95340','78490','92350','95590','92220','95420','95420','95270','95570','78790','78790','93500','78200','78711','95140','78320','78200','95400','78930','93440','95510','78490','94250','78490','78490','92260','92330','93350','60230','78114','60119','95420','78470','95720','78930','93310','78117','78520','60119','60110','78470','78310','91570','95270','95720','92290','95510','95720','95500','95270','78490','94110','78320','91400','60240','78930','78930','78790','95420','95720','78490','78490','60240','94270','78690','78910','60240','91430','95420','95270','78520','78910','93170','78200','95340','60119','91190','95500','92340','60540','60540','91430','91370','91190','94240','94230','94231','94232','94233','94234','94235','94236','94237','94238','94239','93700','93150','93260','93230','60240','95510','78910','78890','94200','94205','78790','95270','95270','60240','78940','94800','60110','95820','60530','95780','95850','78790','93000','95420','93100','78320','78200','78200','95500','60240','60540','95190','95270','60240','78490','92160','94160','95420','60175','78460','78470','95190','78200','60173','60530','94300','78720','95420','78490','60110','78720','95190','78790','78910','93140','94260','60540','60820','78690','94550','91300','78200','78200','78200','95270','91440','94220','78940','78910','95500','78200','93130','95510','95850','91400','91120','60530','95420','78840','60240','95270','95420','91470','60240','60110','60540','94140','95270','95270','78910','78460','78270','94150','94400','78790','78710','91940','91190','95780','60530','78520','78720','94320','78200','60240','60570','95380','60240','93110','78270','91940','91320','95380','78790','60530','60240','95710','78610','91140','94700','60240','95270','93600','93250','95700','78980','91160','94120','94410','60530','78270','60149','91470','60790','78910','91400','95710','60260','78610','94340','78111','93320','93340','60240','91140','95510','95470','94130','60460','94600','93420','78200','95780','78720','91940','95670','60530','95420','91380','91160','94170','78490','94310','94390','93270','60570','60240','78550','27630','78910','93360','91160','78550','78610','60270','60240','60790','60240','91470','91470','78840','95380','78200','60110','93220','78610','91550','60460','60730','91420','60240','60240','60730','60580','95710','94000','78980','93190','93390','91640','60240','78125','60240','60240','78270','95380','94360','60240','60240','27620','78270','95380','94290','93330','78790','60730','93410','94100','94210','94340','78950','60240','95770','94500','60340','91160','91200','60790','78790','78550','78270','93290','60790','91620','93370','60790','60430','27620','60240','60240','60570','78910','27630','60560','60340','94380','78980','78550','94430','27630','94480','78113','94460','60240','78720','91360','95770','95770','95470','91620','77181','93470','93460','94190','95470','60240','60240','94350','78270','77990','78980','60730','27630','27630','91360','95470','60520','93160','78980','60240','78830','60790','91470','27420','60500','91460','60590','91640','78980','78113','78125','91260','78120','91700','91270','78270','78830','91390','91600','78270','77990','27720','60240','91640','60730','60740','91560','60250','28260','78550','78550','60660','91310','91310','60660','60660','60500','28560','28260','78270','94450','77500','28410','94420','77290','60590','78270','60240','91310','77270','27620','77230','60128','60660','60660','28260','77181','91210','91170','60520','94370','94380','60590','27140','94470','94490','94880','94880','91240','91230','91640','60390','78120','28560','77420','91310','77230','60430','91680','78113','27720','60160','78980','27630','27640','60240','27630','27630','28260','60590','60250','60430','91700','91680','77230','27420','91350','91330','27620','60128','27870','77177','60390','91470','60390','60390','60160','78270','27420','27830','60300','60300','60390','91530','28410','60520','77185','60250','78270','91180','94510','28410','60250','77410','91220','91220','60430','78730','78730','78113','78125','91700','77186','91800','77184','78270','91000','91130','77340','28260','60590','60430','77410','28410','78125','94440','27510','27120','77290','60390','28410','91520','91340','94440','60590','60250','77360','77230','60300','60180','60660','60590','78113','27200','91530','91410','77200','27140','60430','27510','78120','91290','77230','60390','27540','28260','78125','27420','60430','60590','60250','91450','91650','91290','60100','27510','27730','78125','28260','78113','91650','91070','27120','28410','60390','78730','91860','27660','27660','60300','28260','91650','60300','60250','77230','78125','91080','94440','28410','77400','27420','27510','60370','94520','94520','27640','77410','77410','77410','77090','77183','27420','60590','60000','77230','60290','78125','77400','60370','91630','60870','91800','91530','91090','91000','77680','27150','27780','27150','27510','27120','77280','77230','60250','91630','27510','28410','77600','77170','28210','60290','60370','91450','60134','27950','60950','28210','78125','60290','27120','27120','60390','60134','77400','27730','91790','91630','91480','77230','77410','60290','60590','60250','77150','78730','27950','60330','28230','78125','77400','28210','27140','28260','77600','77600','60550','91630','28410','91090','91530','28210','91410','91480','60155','60000','91410','77400','60430','60250','91580','60140','91630','27640','27120','27950','77230','60290','60390','60300','60300','27530','77400','91250','27730','77410','28230','27510','27510','77150','60650','91910','91730','77230','28500','60290','27420','60700','27950','28500','78125','77600','77330','28260','78730','27750','27150','77164','27150','60870','91250','28210','77380','77400','91810','27150','60930','91730','60950','27950','77135','27700','60300','60850','27120') AND fami_id='5' AND cate_id='176' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='859' AND wish_id<>'281461' 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='859' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=549118 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 = 549118 AND W.type_id = 1) OR (W.util_id <> 549118 AND W.type_id = 2)) AND (M.post_util_id = 549118 OR M.dest_util_id = 549118) 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 = 549118
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='859' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=549064 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 = 549064 AND W.type_id = 1) OR (W.util_id <> 549064 AND W.type_id = 2)) AND (M.post_util_id = 549064 OR M.dest_util_id = 549064) 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 = 549064
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='859' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=547555 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 = 547555 AND W.type_id = 1) OR (W.util_id <> 547555 AND W.type_id = 2)) AND (M.post_util_id = 547555 OR M.dest_util_id = 547555) 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 = 547555
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='859' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=543176 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 = 543176 AND W.type_id = 1) OR (W.util_id <> 543176 AND W.type_id = 2)) AND (M.post_util_id = 543176 OR M.dest_util_id = 543176) 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 = 543176
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='859' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=521706 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 = 521706 AND W.type_id = 1) OR (W.util_id <> 521706 AND W.type_id = 2)) AND (M.post_util_id = 521706 OR M.dest_util_id = 521706) 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 = 521706
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='859' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=540051 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 = 540051 AND W.type_id = 1) OR (W.util_id <> 540051 AND W.type_id = 2)) AND (M.post_util_id = 540051 OR M.dest_util_id = 540051) 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 = 540051
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='859' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=513432 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 = 513432 AND W.type_id = 1) OR (W.util_id <> 513432 AND W.type_id = 2)) AND (M.post_util_id = 513432 OR M.dest_util_id = 513432) 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 = 513432
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='859' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=506054 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 = 506054 AND W.type_id = 1) OR (W.util_id <> 506054 AND W.type_id = 2)) AND (M.post_util_id = 506054 OR M.dest_util_id = 506054) 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 = 506054
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='859' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=505269 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 = 505269 AND W.type_id = 1) OR (W.util_id <> 505269 AND W.type_id = 2)) AND (M.post_util_id = 505269 OR M.dest_util_id = 505269) 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 = 505269
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='859' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=22114 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 = 22114 AND W.type_id = 1) OR (W.util_id <> 22114 AND W.type_id = 2)) AND (M.post_util_id = 22114 OR M.dest_util_id = 22114) 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 = 22114
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