Réserver
Description de l'annonce
Shampouineuse Canapé, Nettoyeur pour Tapis, Moquettes, Meubles, Tissus, Voiture…
Moteur Puissant de 750W #shampouineuse
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Réserver
Shampouineuse Canapé, Nettoyeur pour Tapis, Moquettes, Meubles, Tissus, Voiture…
Moteur Puissant de 750W #shampouineuse
Autres annonces du voisin
Tout voirAnnonces similaires
Tout voirLouer une shampouineuse entre particuliers ou proposer une shampouineuse 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='625999'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'shampouineuse' 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='110'
SELECT dpt_url, filtre_dptnom FROM filtredpt WHERE filtre_dpt='68'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='457528' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 457528
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 = 625999
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=747 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='625999'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='625999' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 457528 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=457528 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 = 457528 AND W.type_id = 1) OR (W.util_id <> 457528 AND W.type_id = 2)) AND (M.post_util_id = 457528 OR M.dest_util_id = 457528) 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='457528' 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 = '625999'
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='457528' AND wish_id<>'625999' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
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='723' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=457528 AND note_visu IN (1,3,4)
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 457528
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='68128'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((47.5833*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((47.5833*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((7.56667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>47.133639197041 AND ville_latitude_deg<48.032960802959 AND ville_longitude_deg>6.9000225747284 AND ville_longitude_deg<8.2333174252716 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 ('68128','68300','04056','68128','04057','68330','04055','04031','04018','04010','04091','04075','04070','04030','04020','04005','04000','04009','04002','04019','68220','04001','04041','04089','04089','04041','04089','04039','04039','04089','04051','04054','68220','04058','68220','04123','04123','04102','04102','04053','04052','04052','68128','04059','04101','04125','04127','04125','68730','04103','04124','68220','04104','68220','04126','04040','04142','04042','04042','68220','04142','68730','68730','04132','04132','04105','68870','68220','04106','04153','04153','68220','68870','68220','68220','68510','04144','04112','04112','04108','68220','68510','04133','68640','04133','68510','68680','04107','04112','04147','68510','68510','04143','68220','04302','68220','68220','04114','04402','04115','68510','04145','68510','68130','04303','04148','04303','04118','04304','68640','68510','68480','04414','68510','04223','04224','04202','68130','04116','68490','68680','04146','04412','68130','68510','68480','04203','04410','68130','68480','04421','04222','68640','68510','68440','04243','04413','04305','04422','68130','68440','04411','04117','68130','68130','04225','68480','68440','68480','04310','68480','68480','04204','68480','04419','04310','68440','68480','04244','04206','68440','68960','68480','68960','68480','68130','68640','04423','68440','04415','04312','68480','04226','68440','68480','04416','04417','04242','68960','68960','04232','68440','68130','04453','68440','68130','04245','68130','68130','68480','04208','68490','04246','04452','04433','68560','04313','68720','68130','68640','04227','04207','04451','04234','04450','04424','04464','68480','04432','68480','68560','04254','04233','68720','68490','68480','04418','04425','04247','68640','68480','04455','04252','04253','04252','02814','04434','04435','04228','04314','68720','68130','68560','68560','68400','04426','04461','04462','68350','68170','68480','68130','04463','68720','04441','04436','68350','04323','04456','02805','68720','68720','02828','04229','02813','04436','68200','68100','68720','68480','04442','04315','68720','68490','68480','04460','68130','68480','68118','04431','04322','04437','02812','04466','02826','68130','04465','04457','04443','68720','68390','04719','02823','68580','02827','68580','02825','04316','04447','02806','04444','02824','04717','02822','02827','68480','68490','68110','68390','04446','04324','02807','68720','04492','68580','04497','68720','02800','02800','68480','04317','68790','04467','68990','04332','02800','04438','68460','04458','04445','68580','68260','68120','68740','68480','02829','68990','04493','68480','68720','68580','68580','04448','04333','04496','68210','02807','04325','68120','04712','68210','04714','68390','68950','02747','04718','02830','02832','68480','68270','68210','68580','68210','68480','02842','02803','68210','04710','68270','04334','04713','02947','04469','04615','68210','04633','68210','05074','04495','02953','05064','04634','04715','02802','68580','68210','68580','04494','68740','04614','68210','68210','02944','02747','02830','68520','04622','04625','02843','02852','05073','68210','68210','04716','04632','04468','02762','02953','02935','68740','02946','68210','02746','68210','68210','02857','05072','04613','68210','05070','02954','02943','04704','02744','04655','04702','02745','04539','90370','04524','04539','68520','68850','68310','68210','05063','04654','04612','68740','05017','68520','68210','68190','90100','04524','02853','04524','68840','68780','68210','68210','04525','05082','04652','02952','04605','90100','04617','04623','04535','04626','04624','04616','04600','04716','04609','04609','04601','02856','05062','04704','02854','04655','04703','04536','68210','02933','90100','68740','02933','68740','68740','05080','68700','68780','02942','02743','02740','04523','05028','90100','04538','04535','68210','02864','04515','05083','68210','04618','04653','68540','90100','04537','68740','05018','05027','04656','04522','68190','05015','02932','05075','68210','04663','68210','90100','04657','02950','90100','68890','68210','04534','02742','04628','04533','68210','05013','68780','04629','05084','68700','04515','02883','68700','04911','68540','68190','68500','05025','02950','68700','68700','03380','05026','68210','68780','04852','02924','03380','04532','68740','02882','02882','05024','05076','04514','68210','68210','05085','04913','68210','02748','04513','68800','04853','04853','04658','68890','68250','02855','04923','03377','68700','02863','05012','68116','90100','04542','02735','68210','02884','04543','05012','05746','68500','68780','05077','04853','90150','05275','04665','04665','05022','04665','03376','03374','02738','90100','90100','05014','02900','02900','02900','04912','02923','05079','90150','05012','68360','02545','02888','68500','02748','04512','04501','68780','04503','04509','04502','02902','05273','04500','68250','04528','68700','05000','05001','05078','03376','03373','02922','05274','02925','05004','68800','68800','90130','90100','90130','04803','05112','68600','05272','68600','68500','04802','03373','04553','90150','90150','05023','90100','90100','03375','04914','04856','68250','68250','05035','68600','04922','05745','02544','68500','90150','02903','02926','02716','02717','05326','90150','90150','05237','02885','90100','68290','04552','05032','02873','02715','02736','68127','03372','90360','90140','05036','04574','90130','02733','05742','04556','68500','68500','68780','04800','04812','02735','04809','04801','04807','04807','04808','04810','04809','04809','04801','04809','04808','04900','90150','05276','04554','68250','04901','05033','68600','02735','68800','68800','04562','02735','90360','03360','05225','02905','04554','05108','04922','04574','02732','02717','90140','02540','02540','90340','04557','05277','03362','90100','02715','90150','04566','02718','02889','68290','90600','90100','05034','02732','05107','68500','02904','04566','04915','04813','90140','04805','90110','68620','02915','02364','04573','05043','04556','05105','05325','04563','90150','68500','68250','68500','04566','90140','05236','90150','04556','68600','90340','68500','04806','05213','02732','03363','03297','68600','68250','05037','68290','04814','02886','04558','06264','04924','02713','05318','04571','68760','90110','04916','90110','03366','05106','03368','02538','05102','90100','04932','04564','68500','05317','02543','90150','68600','04565','90100','03367','68760','04564','05502','90110','02718','04571','05116','02732','02712','03296','04558','02362','90140','03366','05223','06260','68250','68530','90120','04558','03365','06260','05324','05053','06265','25190','05042','03428','68290','05222','90110','04932','90110','02906','04556','05040','90160','05722','68600','02603','03315','04581','68600','04917','68600','68530','04933','90150','05234','90150','25490','05113','05232','05245','02536','03475','90100','03425','05103','06262','05316','06260','04576','90400','02537','90140','05246','05058','05053','05503','02542','05315','68290','90340','90120','03429','04582','04578','90170','04586','68280','02710','03429','68250','05235','90160','02916','68570','02714','03295','06260','05201','05702','05200','03367','90380','02554','25490','06263','68280','03365','03425','68610','25190','02887','06147','05212','05726') AND fami_id='5' AND cate_id='110' AND type_id='1' AND ssrubr_id='747' AND wish_id<>'625999' 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='747' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=470403 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 = 470403 AND W.type_id = 1) OR (W.util_id <> 470403 AND W.type_id = 2)) AND (M.post_util_id = 470403 OR M.dest_util_id = 470403) 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 = 470403
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='747' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=465156 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 = 465156 AND W.type_id = 1) OR (W.util_id <> 465156 AND W.type_id = 2)) AND (M.post_util_id = 465156 OR M.dest_util_id = 465156) 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 = 465156
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='747' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=456114 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 = 456114 AND W.type_id = 1) OR (W.util_id <> 456114 AND W.type_id = 2)) AND (M.post_util_id = 456114 OR M.dest_util_id = 456114) 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 = 456114
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='747' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=452645 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 = 452645 AND W.type_id = 1) OR (W.util_id <> 452645 AND W.type_id = 2)) AND (M.post_util_id = 452645 OR M.dest_util_id = 452645) 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 = 452645
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='747' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=431354 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 = 431354 AND W.type_id = 1) OR (W.util_id <> 431354 AND W.type_id = 2)) AND (M.post_util_id = 431354 OR M.dest_util_id = 431354) 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 = 431354
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='747' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=397884 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 = 397884 AND W.type_id = 1) OR (W.util_id <> 397884 AND W.type_id = 2)) AND (M.post_util_id = 397884 OR M.dest_util_id = 397884) 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 = 397884
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='747' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 397884
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='747' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=276986 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 = 276986 AND W.type_id = 1) OR (W.util_id <> 276986 AND W.type_id = 2)) AND (M.post_util_id = 276986 OR M.dest_util_id = 276986) 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 = 276986
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='747' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=259541 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 = 259541 AND W.type_id = 1) OR (W.util_id <> 259541 AND W.type_id = 2)) AND (M.post_util_id = 259541 OR M.dest_util_id = 259541) 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 = 259541
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='747' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=151633 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 = 151633 AND W.type_id = 1) OR (W.util_id <> 151633 AND W.type_id = 2)) AND (M.post_util_id = 151633 OR M.dest_util_id = 151633) 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 = 151633
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 747
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