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