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