For speed-kini.de we have two types of tables:
- Tables which show the current rankings overall, women, juniors, foil..
- Tables which show rankings of previous years (archive) for overall, women, juniors, foil…
The initial approach was having two different wpDataTables: one for the current year and one with the year as variable. This duplication should ring all your software engineer alarm bells!
Another possibility would have been to use the archive tables for the current rankings by just setting the variable to 2021, 2022 etc… this would mean work every year to edit the wordpress pages and manually increase the variable to the current year. So this is a bit nicer but still means regular maintenance work.
After some thought, I ended up with a neat approach how to use one table for both: current and archive.
For the current year you just leave the variable empty and for archive you specify the variable to your desired year.
The mechanism to default to the current year in case no year is specified consists of two parts:
#1 Setting the default value of %VAR1% to a very high number (> 5000 should be enough 😉 )
#2 Small SQL modifications to the places which use %VAR1%
[...]
WHEREYEAR(date) = LEAST(year(curdate()), %VAR1%)
[...]
13,376 comments
bestforexstrategies – Very interesting site, found some fresh ideas for trading I’ll try soon.
successfultradersclub – Found a tip I hadn’t seen on other sites, that was a nice bonus today.
futuregrowthteam – Impressed with the packaging and timely delivery, will shop again.
ultimateprofitplan – Well-structured content, made complex concepts easy to understand.
nextleveltrading – Secure looking site and good user experience, felt comfortable signing up.
Стационар «Частного Медика 24» — условия, где пациент может спокойно пройти вывод из запоя без страха и дискомфорта.
Получить дополнительные сведения – вывод из запоя в стационаре анонимно
shoplocaltrend – Found unique items not available elsewhere, great shopping experience.
yourtradingmentor – Credible guidance, made me more confident in my trading decisions.
Госпитализация в стационар помогает быстрее и надежнее справиться с последствиями запоя.
Исследовать вопрос подробнее – быстрый вывод из запоя в стационаре в нижний новгороде
bestforexstrategies – The site feels trustworthy, though I’ll still test ideas on demo first.
successfultradersclub – Some of the methods seem advanced, great resource if you’ve got experience trading.
Если нужен профессиональный вывод из запоя, обращайтесь в стационар клиники «Детокс» в Сочи. Все процедуры проводятся анонимно и под наблюдением специалистов.
Подробнее можно узнать тут – вывод из запоя капельница на дому сочи
freshfashionfinds – Easy shopping experience, fast checkout and smooth navigation.
В Самаре стационар «Частного Медика 24» предлагает персонализированный подход — лечение запоя, детоксикация и дальнейшее восстановление под наблюдением специалистов.
Выяснить больше – наркология вывод из запоя в стационаре
nextleveltrading – Great value for the time invested, very pleased with what I found.
futuregrowthteam – Impressed with the packaging and timely delivery, will shop again.
yourtradingmentor – This will be one of the first places I check before entering trades now.
В стационаре «Частного Медика?24» пациент получает комплексное лечение, включая капельницы и медикаменты.
Получить дополнительные сведения – http://vyvod-iz-zapoya-v-stacionare-voronezh23.ru
bestforexstrategies – The layout is clean and the strategy descriptions are clear and helpful.
successfultradersclub – Navigation was smooth and I found useful content without too much fluff.
shoplocaltrend – This site has become my favorite for online shopping recently.
ремонт водонагревателей https://servis-vodonagrevateley-msk.ru/
nextleveltrading – Secure looking site and good user experience, felt comfortable signing up.
everydaytrendshop – Trendy styles at great prices, found exactly what I needed.
uniquedecorstore – Packaging arrived neatly and item condition was excellent, happy customer.
strongfoundation – Found quite a few useful tools and insights today, well done.
Госпитализация в стационар помогает быстрее и надежнее справиться с последствиями запоя.
Выяснить больше – https://vyvod-iz-zapoya-v-stacionare23.ru
Sou louco pela energia de BacanaPlay Casino, da uma energia de cassino que e pura purpurina. Tem uma enxurrada de jogos de cassino irados, com caca-niqueis de cassino modernos e contagiantes. Os agentes do cassino sao rapidos como um passista na avenida, garantindo suporte de cassino direto e sem perder o ritmo. As transacoes do cassino sao simples como um passo de samba, mas queria mais promocoes de cassino que botam pra quebrar. Na real, BacanaPlay Casino garante uma diversao de cassino que e um carnaval total para os amantes de cassinos online! Alem disso o site do cassino e uma obra-prima de estilo carioca, o que torna cada sessao de cassino ainda mais animada.
casino bacanaplay bГіnus|
strongpartnershipnetwork – Easy to follow tips and strategies, really improved my approach.
https://t.me/s/topslotov
Adoro a chama de BR4Bet Casino, e um cassino online que reluz como um farol na nevoa. O leque do cassino e um brilho de delicias. oferecendo sessoes ao vivo que reluzem como chamas. O atendimento e solido como um farol. com ajuda que ilumina como uma tocha. O processo e claro e sem apagoes. entretanto mais giros gratis seriam brilhantes. No fim das contas, BR4Bet Casino vale explorar esse cassino ja para os amantes de cassinos online! De lambuja o design e um espetaculo visual iluminado. tornando cada sessao ainda mais brilhante.
br4bet download apk|
futuregrowthteam – Helpful product descriptions and reviews, made decision-making easier today.
Наша миссия — помочь каждому человеку преодолеть алкогольную зависимость с минимальным дискомфортом и максимальной эффективностью. Мы исходим из следующих принципов:
Получить дополнительные сведения – наркологическая клиника цены в ростове-на-дону
freshfashionfinds – Trendy styles at great prices, found exactly what I needed.
classyhomegoods – Excellent customer service, quick responses and helpful support.
simplelivinghub – Felt safe and comfortable reading the articles, very user-friendly site.
shoplocaltrend – Excellent value for money, definitely my go-to marketplace now.
globalmarketinsight – The site gave me ideas I hadn’t seen elsewhere, very valuable.
strongpartnershipnetwork – Clean design and fast loading, makes exploring partnerships enjoyable and simple.
uniquedecorstore – Secure checkout and responsive site, felt safe to purchase.
everydaytrendshop – Impressed with the product variety and timely delivery.
strongfoundation – Helpful content, practical suggestions that seem applicable immediately.
classyhomegoods – Helpful product descriptions and reviews, made decision-making easier today.
simplelivinghub – Great visuals and clear guidance, inspired me to declutter today.
Ищете надёжные, проверенные способы избавиться от алкогольной зависимости? Тогда вам стоит прочитать статью «Лучшие методы лечения алкоголизма». Ознакомиться с деталями – http://mymoscow.forum24.ru/?1-6-0-00030432-000-0-0
freshfashionfinds – Loved the packaging, items arrived in perfect condition.
globalmarketinsight – This will be part of my regular go-to list for market insights.
smartbuytoday – Great customer service and helpful responses, made me return quickly.
trendandstyle – Excellent customer service, quick responses and helpful support.
strongpartnershipnetwork – Practical strategies and useful recommendations, saves time and effort today.