-15kg
qu'à l'achat
Description de l'annonce
Crêpière Krampouz Électrique pour le samedi 4 février. Autour de Versailles.
#Crepiere
Voir les annonces autour de moi Géolocaliser
Poster une annonce
-15kg
qu'à l'achat
Crêpière Krampouz Électrique pour le samedi 4 février. Autour de Versailles.
#Crepiere
Louer une crepiere entre particuliers ou proposer une crepiere en location.
Poster une annonce
-15kg
qu'à l'achat
Envoyer un message
Vous pourrez dialoguer & organiser un rendez-vous.
Lancez votre recherche pour voir les annonces.
Assistance support Kiwiiz
Comment pouvons-nous vous aider ?
Script : /wiiz-annonce.php
SELECT filtre_dptnom, filtre_villes, dpt_url FROM filtredpt WHERE CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('' USING utf8mb4) COLLATE utf8mb4_general_ci
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='474667'
SELECT ssrubr_photo FROM ssrubr WHERE ssrubr_slug='crepiere' AND fami_id='5' AND ssrubr_photo<>'' AND ssrubr_id='686'
SELECT `ssrubr_keywords` FROM `ssrubr` WHERE `ssrubr_slug` = 'crepiere' 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 CONVERT(filtre_dpt USING utf8mb4) COLLATE utf8mb4_general_ci = CONVERT('78' USING utf8mb4) COLLATE utf8mb4_general_ci
SELECT count(wish_id) as wiizer_nbwish FROM wish WHERE wish_visu IN (1,6,10) AND util_id='307612' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR')
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 307612
SELECT util_cp FROM utilisateur WHERE util_id=307612 LIMIT 1
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 = 474667
SELECT ssrubr_title FROM ssrubr WHERE ssrubr_id=686 LIMIT 1
SELECT `util_tel` FROM `util_info` WHERE `util_id` = 307612 AND util_tel != ''
SELECT count(wiiz_id) as nbwiiz FROM wish_wiiz WHERE wish_id='474667'
SELECT count(match_id) as nbmatch FROM `match` WHERE wish_id='474667' AND match_id NOT IN (SELECT match_id FROM match_back WHERE match_flag='red')
SELECT stripe_account_id, util_verify FROM util_info WHERE util_id=307612 LIMIT 1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=307612 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 = 307612 AND W.type_id = 1) OR (W.util_id <> 307612 AND W.type_id = 2)) AND (M.post_util_id = 307612 OR M.dest_util_id = 307612) AND M.buy_stripe_pi_id IS NOT NULL AND M.buy_stripe_pi_id <> ''
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 = '474667'
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='307612' AND wish_id<>'474667' AND (wish_url='' OR wish_url IS NULL) AND fami_id IN (3,5) AND (w.wish_area IS NULL OR w.wish_area='' OR w.wish_area='FR')
SELECT ssrubr_slug, ssrubr_title, 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='889' LIMIT 0,1
SELECT abo_id FROM util_abo WHERE abo_type=4 AND abo_actif=1 AND abo_expire>SYSDATE() AND util_id = 307612
SELECT ville_cp, ville_latitude_deg,ville_longitude_deg FROM villes v WHERE ville_cp='78870'
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.08333- 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.3999817637462 AND ville_longitude_deg<2.7666782362538 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_area IS NULL OR wish_area='' OR wish_area='FR') AND wish_cp IN ('78870','78590','78160','78620','78590','78150','78430','78750','78112','78290','78380','78150','78330','78560','78860','78170','78450','78100','78210','78230','78110','78400','78240','78000','92430','92420','78450','92380','78240','78390','78340','78220','92410','78810','78360','78140','92500','92310','78280','78300','78190','92210','78180','78350','78530','78600','92000','92370','78630','78420','78370','78350','78810','92800','92150','78800','78960','78117','78121','78955','78600','78850','78990','92100','92190','92360','78670','78670','78260','78114','78117','78470','78500','92250','92400','95870','78640','78470','92200','78640','92130','78580','92700','91400','78630','92140','78320','91570','78570','78700','78540','95530','91190','78640','78570','91190','78310','92270','78760','92350','78320','91430','78580','92300','92320','78650','92170','78510','91430','78124','78640','92600','92240','92290','92260','92330','78920','95100','78310','78480','95370','78470','78780','78124','92110','92220','78460','78130','95240','91370','92120','78490','78320','78720','91440','95220','78720','95110','91400','78580','92230','78650','78690','95130','95000','95610','78580','78490','78490','78410','78490','94250','91470','95280','91940','91190','92340','93400','94110','75001','75000','75002','75003','75004','75005','75006','75007','75008','75009','75010','75011','75012','75013','75014','75015','75016','75017','75018','75019','75020','75116','78460','91120','92160','78126','95000','95480','95210','95218','91300','78770','78770','91940','94240','94230','94231','94232','94233','94234','94235','94236','94237','94238','94239','78770','93800','95180','78720','95130','95120','78690','94260','78740','95250','91470','95000','78410','92390','93450','91400','78130','91140','95490','78770','78770','78490','78490','78740','78490','94270','95800','91940','78410','78410','78250','78490','91160','78410','95880','78490','94800','91140','94550','95230','78770','78720','93200','93210','95600','78250','95320','78610','91470','95300','94200','94205','91470','95310','93430','78680','91320','78250','94150','95450','95150','95550','95650','91640','78250','95390','91160','95580','95580','91380','91160','78580','93120','93300','95360','78770','93310','95170','95680','93500','78940','94320','78820','78610','78250','95520','95300','95450','95740','78930','78490','94400','95650','78970','93380','93170','94160','95410','93240','78890','94220','95160','91420','91620','95430','78930','94140','91160','78125','95840','91550','95540','78910','94300','78440','93100','78910','78610','94310','94390','95450','93260','93230','95560','95650','91470','91620','78720','91640','93350','94600','78790','78790','78830','78940','94700','91640','95450','95840','91460','78440','78250','95350','91360','95650','95650','78830','93440','78910','95350','95450','78790','78930','95570','95430','95630','91700','95330','93000','91360','78610','91200','78440','95400','95200','91310','91310','95140','94290','94410','95300','78440','91640','78490','78440','95300','78910','95450','91310','91680','91390','91600','93130','94340','93700','93150','95400','94480','93140','91310','95500','78440','95440','91260','78440','95570','78120','95450','95560','91240','78930','94000','78440','95460','95450','95760','91680','95450','94120','78910','93110','78910','94130','78120','78930','78930','95560','78520','95570','91270','78930','91470','95810','91530','78200','78711','95590','78790','94190','91170','95830','78790','94460','95830','91700','91180','95450','94170','78730','78730','78200','95500','78125','91210','91560','93250','94380','78790','78440','78550','94100','94210','94340','95560','91220','91220','95620','91520','91340','91350','78200','91530','95720','95810','95810','95450','95290','91230','91410','78440','95720','93360','94360','91700','95690','78950','78790','94500','78200','95450','95450','94450','78440','91290','95720','91650','93320','93340','94430','95690','91650','78200','78550','78113','95450','95510','91290','78520','95500','91650','93330','78910','95640','95640','78200','91000','91130','78120','93220','78113','95570','95420','78790','78730','95810','95810','95720','91530','78125','78200','93600','95190','95590','94470','95500','95640','95690','95640','95660','91630','78200','95690','95270','91330','95270','91070','95640','93270','78910','94350','78200','95260','94370','94380','95510','91630','78111','78550','78520','95260','91790','91800','95190','91080','91450','93190','93390','78200','94490','94880','94880','78113','95510','95850','91530','95590','91630','78980','93420','93160','95420','95420','91410','78550','93460','78550','78125','91410','91580','95270','94420','78200','95640','95700','93370','95420','95450','91630','95340','95640','78730','91910','91730','91630','95190','91090','91000','94440','78550','95270','95750','78125','78125','95340','93410','94440','78910','95380','78790','78125','91860','78730','78710','95750','91730','95780','78125','95420','95270','91090','91450','78200','95810','95810','95640','91580','60230','78113','95850','78980','77181','93470','94510','78790','60240','95270','95270','78520','78125','91810','95510','77420','91800','95380','93290','77500','28410','78113','94520','94520','28410','91730','95270','95420','94440','95270','95270','95340','77340','78270','78270','91480','78200','78270','78840','91250','28410','60119','60110','28560','28260','95510','77185','95420','95820','91540','95270','78113','28230','78125','91250','77184','60119','91410','78125','91710','91580','78980','60240','91510','91510','95270','77170','28230','78660','95380','77181','91770','95380','95420','91480','60240','60530','91580','95420','95780','95670','91100','77270','91280','60540','60540','91410','28410','60820','28560','77186','95470','91850','77177','60240','91100','95420','28260','91540','91540','91540','95380','60240','28210','77380','91410','28410','28210','60119','78660','60530','77150','60110','78980','60240','91250','95420','91760','28210','60240','77200','77360','78660','95710','60540','78980','77290','78980','78840','78270','77990','77127','77680','95780','60530','60260','77990','28260','77410','28320','95510','95420','60240','60540','28130','91580','77150','91610','28210','28410','60175','91870','95470','77090','77183','60173','60110','78270','78660','28130','28410','28210','28410','91410','77170','28260','60530','27630','95710','60580','91590','91750','60540','77330','60240','27620','78270','95470','28260','28320','91250','91830','77600','77400','28700','78270','95470','91410','28260','77400','27640','60240','60460','60530','78270','60240','60530','60270','91580','28700','60110','91150','78980','77410','78270','95710','91150','60560','28500','77230','27620','77230','60570','28410','28210','95420','77230','28320','91590','28260','77600','77600','28260','77400','78660','91590','77173','27540','78660','60240','91150','28500','60530','77135','60520','60240','60240','91410','78270','78660','77164','77290','91750','91830','77166','60128','78270','28130','77550','91590','60460','28210','28210','77176','28210','60240','60149','91780','91780','77400','77410','77600','77230','77400','60790','28130','28320','60240','91150','28210','77166','28700','77400','60240','91410','27620','91590','60340','78270','60570','77410','77410','91590','91410','95770','28130','27730','27630','28700','28210','77410','28320','60340','28260','91590','78270','60730','60240','27630','60520','77400','28130','77240','60730','60240','60500','27630','28700','60128','28130','77550','77600','27120','77230','77230','60240','27780','91590','27630','28570','28500','60110','60790','77176','77410','60240','60240','60240','60240','91780','95770','95770','60500','28130','60740','28260','27530','77144','77600','77310','28500','60240','60730','91880','60240','78270','77230','60240','27640','77240','77111','28500','77220','27420','60520','77230','91750','28210','77170','28130','27730','27630','28700','91890','27120','77230','28500','27620','28210','77310') 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='686' AND wish_id<>'474667' AND wish_url='' ORDER BY wish_publishdate DESC, wish_publishhour DESC, wish_id ASC LIMIT 0,10
SELECT ssrubr_slug, ssrubr_title, 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='686' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=482451 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 = 482451 AND W.type_id = 1) OR (W.util_id <> 482451 AND W.type_id = 2)) AND (M.post_util_id = 482451 OR M.dest_util_id = 482451) 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 = 482451
SELECT ssrubr_slug, ssrubr_title, 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='686' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=472812 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 = 472812 AND W.type_id = 1) OR (W.util_id <> 472812 AND W.type_id = 2)) AND (M.post_util_id = 472812 OR M.dest_util_id = 472812) 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 = 472812
SELECT ssrubr_slug, ssrubr_title, 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='686' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=428087 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 = 428087 AND W.type_id = 1) OR (W.util_id <> 428087 AND W.type_id = 2)) AND (M.post_util_id = 428087 OR M.dest_util_id = 428087) 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 = 428087
SELECT ssrubr_slug, ssrubr_title, 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='686' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=423022 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 = 423022 AND W.type_id = 1) OR (W.util_id <> 423022 AND W.type_id = 2)) AND (M.post_util_id = 423022 OR M.dest_util_id = 423022) 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 = 423022
SELECT ssrubr_slug, ssrubr_title, 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='686' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=380105 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 = 380105 AND W.type_id = 1) OR (W.util_id <> 380105 AND W.type_id = 2)) AND (M.post_util_id = 380105 OR M.dest_util_id = 380105) 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 = 380105
SELECT ssrubr_slug, ssrubr_title, 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='686' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=392929 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 = 392929 AND W.type_id = 1) OR (W.util_id <> 392929 AND W.type_id = 2)) AND (M.post_util_id = 392929 OR M.dest_util_id = 392929) 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 = 392929
SELECT ssrubr_slug, ssrubr_title, 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='686' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=369826 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 = 369826 AND W.type_id = 1) OR (W.util_id <> 369826 AND W.type_id = 2)) AND (M.post_util_id = 369826 OR M.dest_util_id = 369826) 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 = 369826
SELECT ssrubr_slug, ssrubr_title, 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='686' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=286975 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 = 286975 AND W.type_id = 1) OR (W.util_id <> 286975 AND W.type_id = 2)) AND (M.post_util_id = 286975 OR M.dest_util_id = 286975) 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 = 286975
SELECT ssrubr_slug, ssrubr_title, 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='686' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=214040 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 = 214040 AND W.type_id = 1) OR (W.util_id <> 214040 AND W.type_id = 2)) AND (M.post_util_id = 214040 OR M.dest_util_id = 214040) 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 = 214040
SELECT ssrubr_slug, ssrubr_title, 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='686' LIMIT 0,1
SELECT ROUND(AVG(note), 1) AS note_moy, COUNT(note) AS nb_avis FROM `note` WHERE dest_util_id=191391 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 = 191391 AND W.type_id = 1) OR (W.util_id <> 191391 AND W.type_id = 2)) AND (M.post_util_id = 191391 OR M.dest_util_id = 191391) 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 = 191391
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 WHERE note_visu IN (1,2,3,4) AND post_util_id<>7
SELECT count(*) as nbwish FROM wish WHERE wish_visu IN (1,6,10) AND (wish_area IS NULL OR wish_area='' OR wish_area='FR')
Contactez-nous