Year 2023 in Weekly Pictures

Below is the gallery of featured images from my 2023 weekly notes. It represents the year pictorially. It's an exciting way to look at the year. At some point, I want to make a yearly flip book using these pictures, with locations and characters involved. It will be a good yearbook. Also, I should stick to horizontal images as much as possible. It makes the gallery look good.

I used SQL on my WordPress Database to pull out the images that are used as featured images on Weekly posts.

SELECT
    p.ID AS post_id,
    p.post_title,
    p.post_name,
    p.post_date,
    pm.meta_value AS featured_image_url
FROM
    wpress_posts p
JOIN
    wpress_term_relationships tr ON p.ID = tr.object_id
JOIN
    wpress_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
JOIN
    wpress_terms t ON tt.term_id = t.term_id
LEFT JOIN
    wpress_postmeta pm ON p.ID = pm.post_id AND pm.meta_key = '_thumbnail_id'
WHERE
    tt.taxonomy = 'category'
    AND t.term_id = 717
    AND p.post_type = 'post'
    AND p.post_status = 'publish'
    AND year(p.post_date) = 2023
ORDER BY
    post_id

Creating the gallery using short code, because that's the easiest way to add images to gallery. The short code looks like this.

[gallery ids="24030,24141,24258,24352,24426,24531,24642,24707,24766,
24901,24990,25108,25168,25260,25304,25367,25449,25511,25591,25689,
25792,26040,26278,26366,26439,26482,26562,26710,26847,27016,27116,
27167,27299,27389,27479,27575,27676,27772,27889,27984,28102,28182,
28215,28379,28566,28626,28788,28859,29037,29346,29483,29491"
columns="3" size="large" order="ASC" orderby="ID" link="file"]

Currently I have not linked the images to post. That's the next thing I want to do.


You can read this blog using RSS Feed. But if you are the person who loves getting emails, then you can join my readers by signing up.

Join 2,222 other subscribers

1 Response

  1. January 20, 2024

    […] 2023 in Weekly Pictures https://thejeshgn.com/2024/01/20/year-2023-in-weekly-pictures/ #Code, #WordPress, […]