Réserver
Description de l'annonce
Je mets en location un appareil de raclette pour 8 personnes #appareil a raclette
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Réserver
Je mets en location un appareil de raclette pour 8 personnes #appareil a raclette
Autres annonces du voisin
Tout voirAnnonces similaires
Tout voirLouer un appareil (raclette) entre particuliers ou proposer un appareil (raclette) en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
20€
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='375273'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='appareil-a-raclette' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='688'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'appareil-a-raclette' 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='207'
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='190828' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 190828
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 = 375273
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=688 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='375273'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='375273' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 190828 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=190828 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 = 190828 AND W.type_id = 1) OR (W.util_id <> 190828 AND W.type_id = 2)) AND (M.post_util_id = 190828 OR M.dest_util_id = 190828) 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='190828' 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 = '375273'
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='190828' AND wish_id<>'375273' 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='1104' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=190828 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 = 190828
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='1027' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 190828
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='1027' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 190828
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='78711'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.9667*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.9667*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((1.71667- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.517039197041 AND ville_latitude_deg<49.416360802959 AND ville_longitude_deg>1.0317239280719 AND ville_longitude_deg<2.4016160719281 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 ('78200','78711','78930','78200','78930','78520','78200','78440','78930','78930','78930','78200','78200','78200','78200','78200','78930','78520','78790','78970','78440','78200','78930','78200','78200','78710','78440','78580','78520','78790','78790','78680','78440','78790','78440','78980','78520','78790','78200','78410','78410','78270','78790','78440','78270','78790','78200','78410','78440','78770','78440','78111','78820','78126','78270','78790','78410','78910','95780','95510','78980','78580','95510','78910','78580','78840','78770','95510','78770','78270','78250','78980','78440','78840','78250','78770','78910','78910','95510','78270','95450','78124','78440','78910','78770','78410','78440','78790','95780','78980','78250','78980','78790','78270','78580','78980','95780','78770','78124','78250','78250','78270','78920','95510','78910','78910','78910','78130','78270','28260','27620','78270','95450','95420','95420','95510','78250','78580','28260','78980','78130','27640','78270','27620','78910','78630','78270','78770','78550','28260','95710','78890','95450','78650','95420','78650','78550','27630','27620','78270','78490','28260','28560','78740','78270','78121','95450','95420','95450','78940','27120','95450','28560','95420','78490','78550','78940','78740','95420','95710','95450','78810','78270','95450','28260','78540','78490','78850','78480','27730','95420','78550','28410','78640','78640','27120','95180','78630','95710','95450','27540','78640','27640','95420','78490','78510','78670','78670','95420','95450','95420','27620','95450','78810','27200','28260','78640','95000','27780','27630','78490','78490','95800','27120','27120','27630','28260','78550','95450','27120','27730','28260','95420','78950','78490','78490','27630','95450','27630','27640','78240','78490','78570','27120','78955','95450','78550','78450','27730','95450','95640','95750','95280','95650','78370','95420','78490','95770','95490','27630','95420','78240','27750','27630','78113','27510','28410','95650','95650','78760','28410','28260','27950','27950','27530','27120','78300','28410','27120','95640','95640','28410','78860','28260','27630','60240','78260','78490','78570','27950','27220','95650','27950','78340','27510','78780','60240','27220','95770','95770','27120','95000','27420','78113','60240','28410','78450','95830','27950','27120','95000','78990','78310','28410','27220','27220','60240','27120','27510','60240','27510','78690','78112','95750','27510','27420','95830','60240','27950','27120','78100','27220','95520','27120','27220','78620','27720','27120','28410','78610','78700','95640','78310','28410','78113','60240','27220','27120','78750','27420','27950','27920','27920','95610','78590','95650','78590','78390','78113','78230','78160','27510','27220','27940','28570','78190','27220','27120','95300','78320','78330','28500','95640','28520','28520','60240','78870','27120','60240','60240','95640','27870','95300','27120','78600','78110','27700','27510','95640','60240','95810','27950','78610','78113','95810','27120','95310','78560','27600','28500','78113','78690','27420','27940','27420','78610','78430','27120','27720','27810','78210','27710','78125','28210','27950','95300','27220','27600','78600','60240','78320','27120','28500','27220','78125','27120','60240','27220','78610','28210','78180','78360','60240','27120','78380','78290','27220','27510','27220','27420','78320','60240','95810','60240','78150','27220','60240','78400','28210','60240','95220','27930','27700','27930','95480','78125','78150','27420','95300','60119','28500','78280','60240','78470','95530','27120','95370','78500','27150','60240','95640','78170','27220','78960','27220','78420','95810','27600','27940','95810','27650','95430','28500','27930','28500','27650','28500','27930','27490','78125','27940','95810','27150','27150','28210','78720','27830','27930','28210','78125','95240','60119','27930','28500','27930','60240','28500','60119','27140','27600','78470','78000','95250','27600','78800','27700','60240','27320','27220','27420','28210','27490','27220','92000','27700','28500','78720','60590','78120','60240','60240','28210','28100','78114','27220','92500','95690','92420','92430','27600','95870','92380','95810','27770','27700','27700','27220','28210','95540','78720','27660','27660','27930','95550','95150','27150','78125','28210','60240','60173','95430','95630','95690','95740','27930','27150','28210','28210','28500','27650','78350','78530','95130','78220','27150','28500','27220','27490','95130','78117','60590','28210','78720','27420','27930','92410','78117','95760','60590','27700','27930','78460','78460','27930','27150','27600','95690','60590','27930','95690','78140','27220','95110','78125','95100','78125','60240','28230','27940','60110','92310','60240','27140','92210','60590','60240','95840','95320','92700','92800','92150','60240','27320','28130','27700','60240','92250','78350','27320','27930','91470','27150','92400','27700','60175','92370','27940','78470','95840','95620','27490','95120','27930','60240','60240','91190','28500','28130','27600','95390','60790','92270','27240','27600','28380','27140','60240','28230','28500','78720','27490','27860','28500','27930','28130','27430','27150','95560','27930','95290','92200','27720','91190','28500','27700','95218','95210','95600','27180','27240','27150','92100','27000','95680','78120','27150','60240','60590','91400','28500','60149','92600','92300','91470','27700','60110','28210','28500','92360','92190','27320','28210','60110','28210','28130','95230','27150','78125','95340','27150','95580','95580','27930','60790','27400','92230','60590','28350','91470','78125','27440','60110','27240','95660','28210','60590','27930','93800','92110','78125','27930','27930','95590','27320','28500','27700','92130','95570','27700','27150','28130','95880','91570','27180','91940','27320','91190','91430','27400','95560','60590','27440','78830','95260','91470','92140','60790','91440','78120','91400','27150','60240','28320','60590','27150','27400','60540','60540','27930','27400','60230','60540','91430','27700','60110','95340','27180','60390','95170','27150','28170','28130','27430','92350','92170','95560','95160','93450','92390','28500','91400','95260','78830','27320','92320','60570','27430','27430','27180','95330','95560','93430','93400','27440','60390','95590','91940','28170','92240','95570','28270','92290','27240','27430','27400','28500','60790','27240','27150','28270','27930','27930','92260','92330','95360','95410','27180','27930','27440','27430','27140','60590','28320','27400','95590','27150','92220','28170','27440','27180','95350','60590','27400','60540','27440','91940','28500','78730','78730','91370','28130','92120','27430','60540','93200','93210','28350','95570','27930','28130','60790','27440','60390','28130','78730','27430','27150','28130','75009','75020','75019','75005','75116','75001','75000','75018','75002','75015','75012','75011','75010','75016','75008','75007','75006','75017','75013','75004','75003','75014','91640','93380','27400','27400','28170','95350','60570','27240','60530','60530','27150','60790','60390','60430','91120','28130','95340','91470','95460','27240','94250','27100','27100','27430','27150','28320','78730','60390','95270','28320','60390','27380','95270','60570','27930','93240','91640','27400','94110','27400','27240','92340','95400','95200','27180','27400','60530','91300','95440','27240','93300','93120','27790','92160','60390','28270','91140','95820','28170','78660','27930','95570','91140','27400','27850','27480','27590','94235','94239','94231','94233','94238','94237','94236','94230','94232','94240','94234','60730','27380','60390','27110','60850','95270','60530','91470','60730','27190','60530','27400','27480','91160') AND fami_id='5' AND cate_id='207' AND type_id='1' AND ssrubr_id='688' AND wish_id<>'375273' 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='688' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=485155 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 = 485155 AND W.type_id = 1) OR (W.util_id <> 485155 AND W.type_id = 2)) AND (M.post_util_id = 485155 OR M.dest_util_id = 485155) 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 = 485155
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='688' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=484382 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 = 484382 AND W.type_id = 1) OR (W.util_id <> 484382 AND W.type_id = 2)) AND (M.post_util_id = 484382 OR M.dest_util_id = 484382) 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 = 484382
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='688' 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='688' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=457174 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 = 457174 AND W.type_id = 1) OR (W.util_id <> 457174 AND W.type_id = 2)) AND (M.post_util_id = 457174 OR M.dest_util_id = 457174) 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 = 457174
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='688' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=436961 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 = 436961 AND W.type_id = 1) OR (W.util_id <> 436961 AND W.type_id = 2)) AND (M.post_util_id = 436961 OR M.dest_util_id = 436961) 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 = 436961
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='688' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=434119 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 = 434119 AND W.type_id = 1) OR (W.util_id <> 434119 AND W.type_id = 2)) AND (M.post_util_id = 434119 OR M.dest_util_id = 434119) 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 = 434119
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='688' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=420057 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 = 420057 AND W.type_id = 1) OR (W.util_id <> 420057 AND W.type_id = 2)) AND (M.post_util_id = 420057 OR M.dest_util_id = 420057) 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 = 420057
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='688' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 420057
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='688' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=188930 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 = 188930 AND W.type_id = 1) OR (W.util_id <> 188930 AND W.type_id = 2)) AND (M.post_util_id = 188930 OR M.dest_util_id = 188930) 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 = 188930
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='688' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=232602 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 = 232602 AND W.type_id = 1) OR (W.util_id <> 232602 AND W.type_id = 2)) AND (M.post_util_id = 232602 OR M.dest_util_id = 232602) 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 = 232602
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 688
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