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%)
[...]
12,817 comments
**yu sleep**
yusleep is a gentle, nano-enhanced nightly blend designed to help you drift off quickly, stay asleep longer, and wake feeling clear.
**zencortex**
zencortex contains only the natural ingredients that are effective in supporting incredible hearing naturally.
inspiredideas.shop – Their products look inspiring and the site feels very polished.
inspiredgrowthteam.shop – Clean design and motivating content — exactly what I need right now.
Снятие интоксикации, восстановление организма и наблюдение — так проходит вывод из запоя в стационаре «Частный Медик 24».
Разобраться лучше – vyvod-iz-zapoya-v-stacionare23.ru/
startsomethingnew.shop – Found a few things I’d like to explore further later.
buildlastingtrust.bond – I can sense authenticity, which is rare these days.
brightfuturegroup.bond – I found their mission clearly stated, very motivating and transparent.
https://clocks-top.com/
findnewtrend.shop – Found something I might actually buy — good selection.
Где сейчас играет Неймар и под каким номером? Нужны быстрые ответы для мобил фанатов mobil futbol. Интересует «неймар рост вес возраст» по годам — удобнее видеть в одной инфографике. Нужны «неймар обои 4к» без водяных знаков и с правильным соотношением сторон. неймар обои 4к. Где играет Неймар 2024/2025 и как выглядит его роль? Интересно для анализа комбинаций.
Неймар Бразилия: обои в национальной форме, стадионный свет и динамика движения. Неймар религия: редкая тема, важно корректно и без спекуляций — есть проверенные источники? Аманда Кимберли и Неймар — встречал упоминания, нужна верификация фактов. Где играет Неймар 2025 — обновляю карточки игрока в своём блоге.
Неймар барса обои 4К — важно проверить соотношение сторон под ультраширокие мониторы. Неймар лучшие фото — интересны кадры из туннеля и разминки, редко попадаются.
dailyvaluehub.shop – Navigation feels intuitive and the filters work really smoothly.
mostbet online скачать https://www.mostbet4182.ru
startsomethingnew.shop – Shares the kind of inspiration I enjoy in lifestyle and creativity.
Курсы по информатике ЕГЭ https://courses-ege.ru
buildlastingtrust.bond – Really impressed by the focus on credibility and long-term relationships.
https://t.me/Official_1xbet_1xbet/1746
trustandunity.shop – The tone is respectful and uplifting, very nice experience browsing.
mostbet uz ro‘yxatdan qanday o‘tish mostbet uz ro‘yxatdan qanday o‘tish
findnewtrend.shop – Loved how clean and straightforward the product pages are.
smartstylehub.shop – Great range of items, something stylish for every taste.
brightfuturegroup.bond – I found their mission clearly stated, very motivating and transparent.
Полный курс ЕГЭ https://courses-ege.ru
startsomethingnew.shop – The site’s vibe motivates me to try something different.
buildlastingtrust.bond – Design is clean, message is clear — feels very sincere.
globalpartnershipteam.bond – Love the global vision here, feels inclusive and ambitious.
visionaryleadersclub.bond – Clean site design, feels professional and motivational.
trustandunity.shop – Images are quality, site feels polished — positive first impression.
findnewtrend.shop – Love the vibe here—very up-to-date and stylish items.
smartstylehub.shop – Looks like a good place for both trend seekers and minimalists.
https://t.me/Official_1xbet_1xbet/1754
modernchoice.store – I like how clean the design is, space makes browsing relaxing.
Сливы курсов по подготовке к ЕГЭ 2026 https://courses-ege.ru
trustedbusinesslink.shop – I like how professional the graphics and presentation are here.
buildlastingties.bond – I found the resources relevant and genuinely helpful.
brightfuturegroup.bond – Already sharing with friends — this has serious potential.
online connect
globalpartnershipteam.bond – Visuals and copy work well together — no confusing parts.
trustandunity.shop – I’ll revisit this one for sure; it’s growing on me.
smartstylehub.shop – Definitely recommending this to friends who love fashion innovation.
modernchoice.store – Definitely bookmarking this, feels like a go-to for modern finds.
trustedbusinesslink.shop – Nice user experience, smooth navigation between pages.
visionaryleadersclub.bond – Clean site design, feels professional and motivational.
buildlastingties.bond – Feels like a place where commitment and values come first.
https://t.me/Official_1xbet_1xbet/1658
globalpartnershipteam.bond – The site seems well structured, easy to understand partnerships.
trustedbusinesslink.shop – Their about section is clear; good to see transparency.
buildlastingties.bond – Clean interface, easy to navigate and understand.
Если вы ищете надежную клинику для вывода из запоя, обратитесь в «Детокс» в Краснодаре. Услуга вызова нарколога на дом доступна круглосуточно. Врачи приедут к вам в течение 1–2 часов и окажут необходимую помощь.
Ознакомиться с деталями – вызвать нарколога на дом краснодар
visionaryleadersclub.bond – Clean site design, feels professional and motivational.