Discuter
Description de l'annonce
Bonjour, je recherche un barbecue a gaz sur le 94 pour ce week end
merci. #barbecue
Indiquer un code postal ou une ville Indiquer un code postal
Poster une annonce
Discuter
Bonjour, je recherche un barbecue a gaz sur le 94 pour ce week end
merci. #barbecue
Annonces similaires
Tout voirLouer un barbecue entre particuliers ou proposer un barbecue en location.
Poster une annonceEnvoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Réserver maintenant !
Prix estimé
50€
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='362812'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='barbecue' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='701'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'barbecue' 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='94'
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='172959' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5)
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 172959
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 = 362812
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=701 LIMIT 1
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='362812'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='362812' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 172959 AND util_tel != ''
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=172959 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 = 172959 AND W.type_id = 1) OR (W.util_id <> 172959 AND W.type_id = 2)) AND (M.post_util_id = 172959 OR M.dest_util_id = 172959) 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='172959' 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 = '362812'
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='172959' AND wish_id<>'362812' 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='94300'
SELECT ville_cp,ville_nom,ville_latitude_deg,ville_longitude_deg, ROUND((((acos(sin((48.85*pi()/180)) * sin((ville_latitude_deg*pi()/180))+cos((48.85*pi()/180)) * cos((ville_latitude_deg*pi()/180)) * cos(((2.43333- ville_longitude_deg)* pi()/180))))*180/pi())*60*1.1515* 1.609344),2) as distance FROM villes WHERE ville_latitude_deg>48.400339197041 AND ville_latitude_deg<49.299660802959 AND ville_longitude_deg>1.7499817637462 AND ville_longitude_deg<3.1166782362538 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 ('94300','93100','94160','93170','94120','93230','93260','94220','94130','93110','94410','93310','94340','93130','94170','94200','94205','94700','93000','94140','93140','93500','94270','93250','93360','94360','75007','75006','75005','75004','75003','75002','75000','75001','75008','75009','75010','75019','75116','75017','75016','75018','75015','75014','75013','75012','75011','75020','94500','93330','94210','94100','94340','94800','94400','94000','94250','93220','94430','93340','93320','93300','93120','94350','94110','93400','92120','93350','93700','94600','93150','93160','92170','93460','94320','94380','94237','94238','94236','94239','94233','94240','94232','94234','94235','94230','94231','92240','94420','93200','93210','94550','93440','93370','92110','92220','93390','93190','94880','94490','94880','94390','94310','94460','93240','93270','92390','93450','94370','94380','92340','77420','92300','92320','93600','94150','94470','77500','92200','92130','92600','95500','95140','94190','94290','93470','77181','92330','92260','94510','92140','93410','92230','94450','77185','92100','93430','77340','93380','77184','94260','92400','92270','92350','95360','93800','92250','77186','92150','92800','92190','92360','92160','94480','95500','91560','95400','93420','91320','91200','77177','77181','92700','92290','95880','94440','91550','91330','93290','77200','92210','77360','95410','77270','91370','95170','94440','91230','91270','77680','95500','95210','95218','91300','95500','95200','95400','77183','77090','95350','91800','95100','92500','92310','77410','95230','94440','95700','92410','92000','92370','95160','91420','77600','92380','95870','77400','77170','95720','91210','78800','95110','77400','77150','95190','94520','94520','95440','91260','92430','92420','78140','95120','95580','95580','91380','91160','91570','77330','77600','95350','77600','91860','77150','77400','78420','91800','95600','77290','91120','77164','77135','78220','95720','91430','91160','91170','78170','77400','95130','77600','95380','95460','77400','78400','91480','91390','91600','78500','91140','77410','77400','91430','95680','78350','95330','91480','91360','78360','77410','78290','78380','95380','91360','95130','77990','95390','91160','77400','91130','95190','91000','91450','95720','77600','95530','77410','91350','95240','77380','77173','78000','78150','95320','77170','95570','77990','91160','77144','78430','77600','78150','77410','95380','95570','91400','78560','78600','95370','91140','95380','77410','78110','78530','78350','77290','95850','91090','91000','95190','95720','91450','95570','91700','95380','78600','77410','91700','91250','77700','77144','91400','78230','77230','95250','77230','91700','77166','95560','91620','77450','77220','95560','77127','78870','77700','77230','95220','78160','91440','78117','95550','95150','78750','95840','77230','95850','95270','95470','95560','91240','91080','77450','78100','91070','95270','77166','91250','95570','95670','91280','91310','91190','91620','78590','95480','78620','91940','77230','91310','91310','78112','77174','77410','77220','95740','95560','91220','91220','77700','78210','77220','91190','77410','78117','77220','95470','77230','95270','95270','91090','77410','95270','77230','95470','91100','77700','78590','77700','95590','95840','77230','91460','91250','91940','77170','78330','78280','95270','78700','77450','77550','77230','91940','91190','77230','77111','77450','95470','91310','77450','77174','78300','95540','77165','77450','77410','77220','95270','95270','91100','77390','95270','78260','77450','78240','78114','60128','77450','78960','77230','91640','77111','78860','77165','77165','77580','78450','78470','77165','95610','78570','77860','77610','78180','77550','91180','91400','78470','78240','95430','78390','95430','95630','77550','95590','77176','78955','91540','91540','78780','91540','77280','77230','77550','95270','91810','91830','91250','77860','77610','60128','91290','95310','95270','60560','60520','95270','60330','91290','95000','78190','95760','91680','91630','77610','78460','78570','77124','78450','95590','95300','77230','91630','77100','77390','95290','78340','78470','91640','60950','95260','60260','77860','77176','60580','91540','77124','77100','78670','78670','95620','77610','91340','77165','91520','95000','91470','91710','78630','91470','95260','91630','77240','91470','77390','78810','77580','77580','95660','77950','91630','95300','77240','77390','60520','77240','77122','95280','77580','91680','60330','91640','77124','78510','60520','91750','78540','77100','95300','91830','77163','95340','91630','77950','77580','78370','95490','91470','78460','60820','77390','91470','77950','77610','78720','77610','91770','95520','77178','78480','77124','77610','77310','78990','77163','91640','77390','95820','91610','95690','77950','91650','95340','77310','78320','78810','95000','78720','77390','78121','77163','77178','60330','95300','91790','77580','60950','60270','91650','91750','78320','95650','77470','95800','60230','91530','95690','77165','77165','95650','78630','95180','77910','91760','78850','78720','95650','77910','77390','91730','77350','77580','91650','60950','77310','91850','78320','78580','60330','95340','95690','60530','77350','77139','77950','77580','77390','77470','78130','78740','77470','78310','60500','91510','91510','95810','78640','60500','78830','77000','77000','77515','78640','77580','60460','91750','77390','95690','77470','78920','91590','77350','78310','77390','60300','60300','60300','60300','77470','91730','91910','78760','78720','60440','78740','77390','95810','77950','77540','77190','77720','91470','60530','77515','77910','91730','60300','78640','78580','77115','91530','77139','95450','60530','60300','60740','60340','91590','77390','60340','77470','91580','95650','95650','60440','78830','78410','77720','91590','78130','77910','95810','60440','77000','91530','60300','78650','77580','60300','77580','78124','78640','60530','77930','77470','95450','77540','78690','78690','78124','77139','60460','77515','95450','60540','60540','78250','60440','95810','78490','77115','60530','77720','77131','77930','78250','78580','60440','95830','77000','91580','77190','91890','77139','95810','91840','78720','77515','60300','91590','60300','91410','60300','77930','78250','77720','77540','77440','78580','60540','91580','95830','78490','78490','78410','91590','91580','91530','78610','78126','60530','78250','95450','91580','77720','77120','77540','78650','95450','77930','91590','78250','77930','77660','78490','77120','60540','60810','77580','95810','77820','78730','78730','60160','60660','91490','77515','78410','77131','60530','91580','95450','77440','77120','60440','91590','77440','95640','78770','78770','60110','60810','77590','78410','78410','60110','78770','77930','78490','60810','60540','77540','78125','95810','77660','77720','78490','78490','77440','78820','60700','91590','91410','78610','77540','77630','95450','91820','60160','78770','78770','77540','60180','91490','78680','91490','95640','60100','60660','60660','78490','60440','77120','60660','60660','91410','78490','91820','78120','95450','77139','95640','60620','77590','60620','95450','77640','78250','95640','95640','95640','60440','77820','77630','91880','60800','77590','77440','77440','78770','91150','77120','77720','60620','77440','95450','60110','60810','60119','95450','77720','77440','77440','78440','78440','78970','78580','95640','78610','91720','60870','78730','60620','60570','60550','60810','60730','60800','77720','60240','60800','77120','77260','77260','95450','60620','77120','78770','60250','95450','77720','77370','95640','78940','78440','78440','78120','78930','60119','78490','60730','60730','77820','77630','91410','78930','77260','91150','60175','91870','60810','60570','95450','60620','78730','77145') AND fami_id='5' AND cate_id='207' AND type_id='2' AND wish.wish_id NOT IN (SELECT wish_id FROM `match`) AND ssrubr_id='701' AND wish_id<>'362812' 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='701' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=101282 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 = 101282 AND W.type_id = 1) OR (W.util_id <> 101282 AND W.type_id = 2)) AND (M.post_util_id = 101282 OR M.dest_util_id = 101282) 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 = 101282
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='701' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=511068 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 = 511068 AND W.type_id = 1) OR (W.util_id <> 511068 AND W.type_id = 2)) AND (M.post_util_id = 511068 OR M.dest_util_id = 511068) 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 = 511068
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='701' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=458984 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 = 458984 AND W.type_id = 1) OR (W.util_id <> 458984 AND W.type_id = 2)) AND (M.post_util_id = 458984 OR M.dest_util_id = 458984) 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 = 458984
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='701' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=437673 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 = 437673 AND W.type_id = 1) OR (W.util_id <> 437673 AND W.type_id = 2)) AND (M.post_util_id = 437673 OR M.dest_util_id = 437673) 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 = 437673
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='701' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=355019 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 = 355019 AND W.type_id = 1) OR (W.util_id <> 355019 AND W.type_id = 2)) AND (M.post_util_id = 355019 OR M.dest_util_id = 355019) 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 = 355019
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='701' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=344885 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 = 344885 AND W.type_id = 1) OR (W.util_id <> 344885 AND W.type_id = 2)) AND (M.post_util_id = 344885 OR M.dest_util_id = 344885) 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 = 344885
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='701' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=340171 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 = 340171 AND W.type_id = 1) OR (W.util_id <> 340171 AND W.type_id = 2)) AND (M.post_util_id = 340171 OR M.dest_util_id = 340171) 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 = 340171
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='701' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=287743 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 = 287743 AND W.type_id = 1) OR (W.util_id <> 287743 AND W.type_id = 2)) AND (M.post_util_id = 287743 OR M.dest_util_id = 287743) 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 = 287743
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='701' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=318588 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 = 318588 AND W.type_id = 1) OR (W.util_id <> 318588 AND W.type_id = 2)) AND (M.post_util_id = 318588 OR M.dest_util_id = 318588) 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 = 318588
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='701' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=243061 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 = 243061 AND W.type_id = 1) OR (W.util_id <> 243061 AND W.type_id = 2)) AND (M.post_util_id = 243061 OR M.dest_util_id = 243061) 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 = 243061
SELECT ssrubr_bt2 FROM ssrubr WHERE ssrubr_id = 701
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