Discuter
Description de l'annonce
Je souhaiterais connaitre le prix d'une location d'un nettoyeur vapeur pour 3 fauteuils en tissu. #nettoyeur vapeur
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Discuter
Je souhaiterais connaitre le prix d'une location d'un nettoyeur vapeur pour 3 fauteuils en tissu. #nettoyeur vapeur
Annonces similaires
Tout voirLouer un nettoyeur vapeur entre particuliers ou proposer un nettoyeur vapeur 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='573225'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='nettoyeur-vapeur' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='983'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'nettoyeur-vapeur' 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='91'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='433953' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 433953
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 = 573225
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=983 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='573225'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='573225' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 433953 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=433953 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 = 433953 AND W.type_id = 1) OR (W.util_id <> 433953 AND W.type_id = 2)) AND (M.post_util_id = 433953 OR M.dest_util_id = 433953) 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='433953' 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 = '573225'
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='433953' AND wish_id<>'573225' 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='91640'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.6*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.6*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.11667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.150339197041 AND ville_latitude_deg<49.049660802959 AND ville_longitude_deg>1.4367102977943 AND ville_longitude_deg<2.7966297022057 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 ('91640','91640','91530','91470','91680','91640','91470','91650','91530','91650','91530','91470','91640','91680','91650','78830','91410','91470','91400','91340','91520','91580','91530','91470','91940','78830','91730','91910','91790','91580','91940','91190','91460','91410','91180','91940','78730','78730','91310','91290','91620','91410','91630','91470','91290','91730','78470','91310','91310','91630','91580','91440','78460','91730','91400','78460','91620','91630','91140','91580','91310','78720','91190','91190','78720','91410','78720','78730','91240','91630','78720','78730','91160','91410','91160','91510','91510','91700','91220','91140','91220','78117','91870','78720','91630','91400','78114','78120','91580','78470','91160','91430','91120','91700','91850','91360','91430','78470','91410','78117','91150','78730','91410','78660','78120','78960','91150','91380','91160','91360','91770','91150','91580','78320','91570','91760','78320','78350','78530','91600','91390','91150','91700','91810','91780','78350','91780','78280','91710','91300','91590','78125','91420','78180','91070','91370','91410','91350','78610','91410','91590','78690','78320','91410','91590','91590','91080','91170','91540','92160','91610','91590','78120','92290','91540','91410','91260','91320','78660','91090','78190','91780','78125','94260','78310','78660','78000','91150','78660','91550','78610','78220','78210','91130','91000','78140','91590','91880','92370','91590','78660','92350','78390','91540','91540','78310','28700','78990','92330','92260','78690','94150','91210','92340','91750','91200','91100','78330','78125','91270','78610','78660','91090','91000','92140','91150','92310','92190','92360','78660','78150','91450','91740','94550','92320','28700','94480','91150','91590','92410','91820','78760','94232','94239','94230','94231','94233','94234','94235','94240','94236','94238','94237','78150','91690','91690','78125','91450','92220','78340','91690','91750','92430','92420','91740','78590','91820','92130','94290','78490','28700','91150','94390','94310','91230','78450','94320','91100','91250','78370','92380','91150','94110','78490','92240','91890','91560','92100','28700','91690','92210','78870','78170','91690','91720','91830','78590','91150','91250','92120','91930','91720','78125','91280','28700','78125','78490','78490','91250','91250','91830','78125','28700','94190','28320','78860','94600','78610','94800','28700','94250','78640','91740','91150','94400','92170','78450','78640','28700','78430','28700','91720','78380','78290','78160','28700','91690','78620','91150','78490','78490','91800','78640','94270','28700','91750','28310','78640','94460','28230','91490','28700','94450','91840','91860','92150','92800','91330','94200','94205','91490','94140','78850','91150','28700','28700','78560','91480','28320','78400','78750','91660','78810','78112','28700','91720','91490','28700','78490','28700','28700','28700','78125','28230','91800','78125','28320','77127','92500','94700','78490','45300','77240','77310','78810','94220','91670','94380','28700','78490','94000','78490','91720','77930','77176','91150','78650','94440','78650','28700','28320','78110','92200','78230','91660','75015','75006','75005','75001','75008','75014','75003','75002','91150','75000','75007','75009','75004','75016','75017','75018','75011','75019','75013','75012','75010','75116','75020','78100','78490','28310','91480','94520','94520','94470','77380','78240','92000','45300','77310','78940','78770','94160','91720','91490','78240','78121','28130','77930','77310','77930','92400','77176','92250','28310','94410','28700','28700','91720','77930','28320','78125','94440','28700','94340','45300','78360','45300','94440','78125','92300','78420','45330','77350','77550','91490','77240','78800','94380','94370','78940','94340','94100','94210','28700','92110','28310','77930','78890','78770','94300','78113','78124','45330','78630','92700','78113','77170','92600','77550','28130','94430','92270','28700','78770','93170','93400','28130','77240','28310','78113','45480','28700','28210','28130','94130','78300','77930','78600','78580','78770','93100','93310','94880','94880','94490','95870','45480','77190','78950','77170','77123','28150','77350','94500','77630','45300','78124','78580','78910','77123','78113','28130','78770','78770','77760','77166','45330','94120','28310','77350','78113','78600','77630','28700','45300','93230','93260','94360','78500','77190','28130','93500','77630','28700','28310','78955','92230','78630','28310','45300','94170','78910','78113','77150','45300','28130','28150','78550','78670','78670','94510','28700','28150','45330','93110','78910','95100','45480','28210','78580','93300','93120','92390','93450','28130','77550','28130','77950','77123','77950','78770','93130','77150','45480','28310','94420','78260','78910','94350','95530','93200','93210','28210','78550','77000','77000','45480','93330','78580','93000','28300','93800','45330','28150','77166','78920','28130','77550','93360','78910','77950','28210','78126','95110','78540','45300','77000','28210','77111','28130','93140','77340','28410','93250','77760','77760','77173','95210','95218','78700','45480','28150','28300','77000','78570','78580','95370','78550','78550','78130','77950','78790','95240','78570','78550','93350','28210','93430','93160','28310','28630','28210','28210','45480','77950','77760','95880','28310','28630','78910','95130','78510','77170','93240','78930','78790','78790','78480','78410','45300','93220','77184','95120','28360','78410','78410','95360','28210','28300','45300','45300','93460','93150','93700','93340','93320','28410','77330','77111','28150','45300','78780','95220','95230','93440','78680','78410','93380','28210','28310','77590','77185','77680','77420','78930','28300','78410','45330','95130','77390','45330','77760','77590','95170','28130','28410','77950','28210','95410','78550','28150','78790','95600','78910','28210','95140','45480','95610','77760','45390','95580','95580','95480','95000','78930','78790','77390','77760','77760','95280','95250','77760','78130','95500','78970','78790','93370','45390','77186','45390','28410','28310','28410','95000','77760','78910','77115','95160','78250','28140','95320','95180','28500','28210','28150','77500','93390','78790','28410','93190','77390','28300','78740','95390','77220','28310','28300','28410','28150','95680','78250','78740','77390','95400','77090','77183','78910','77200','78930','93270','78930','28310','77390','95350','77760','28310','78440','28630','77135','78200','28360','77220','95000','28210','28000','28630','77300','45480','95490','95200','95400','78820','78250','45300','45390','78790','78930','93600','95550','95150','45300','95800','28300','28310','78250','28310','77220','28500','77390','77360','93470','77181','95500','28300','45390','45300','45480','77115','77177','78930','95350','28500','77210','77920','78111','77590','78440','93410','45390','77164','95450','45300','28630','45390','77220','28560','77600','28260') AND fami_id='5' AND cate_id='110' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='983' AND wish_id<>'573225' 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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=541036 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 = 541036 AND W.type_id = 1) OR (W.util_id <> 541036 AND W.type_id = 2)) AND (M.post_util_id = 541036 OR M.dest_util_id = 541036) 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 = 541036
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=152094 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 = 152094 AND W.type_id = 1) OR (W.util_id <> 152094 AND W.type_id = 2)) AND (M.post_util_id = 152094 OR M.dest_util_id = 152094) 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 = 152094
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=536536 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 = 536536 AND W.type_id = 1) OR (W.util_id <> 536536 AND W.type_id = 2)) AND (M.post_util_id = 536536 OR M.dest_util_id = 536536) 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 = 536536
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=535587 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 = 535587 AND W.type_id = 1) OR (W.util_id <> 535587 AND W.type_id = 2)) AND (M.post_util_id = 535587 OR M.dest_util_id = 535587) 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 = 535587
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=490643 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 = 490643 AND W.type_id = 1) OR (W.util_id <> 490643 AND W.type_id = 2)) AND (M.post_util_id = 490643 OR M.dest_util_id = 490643) 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 = 490643
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=474078 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 = 474078 AND W.type_id = 1) OR (W.util_id <> 474078 AND W.type_id = 2)) AND (M.post_util_id = 474078 OR M.dest_util_id = 474078) 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 = 474078
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=457747 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 = 457747 AND W.type_id = 1) OR (W.util_id <> 457747 AND W.type_id = 2)) AND (M.post_util_id = 457747 OR M.dest_util_id = 457747) 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 = 457747
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=404091 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 = 404091 AND W.type_id = 1) OR (W.util_id <> 404091 AND W.type_id = 2)) AND (M.post_util_id = 404091 OR M.dest_util_id = 404091) 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 = 404091
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=451122 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 = 451122 AND W.type_id = 1) OR (W.util_id <> 451122 AND W.type_id = 2)) AND (M.post_util_id = 451122 OR M.dest_util_id = 451122) 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 = 451122
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='983' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=134765 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 = 134765 AND W.type_id = 1) OR (W.util_id <> 134765 AND W.type_id = 2)) AND (M.post_util_id = 134765 OR M.dest_util_id = 134765) 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 = 134765
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 983
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