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.
1 Response
[…] 2023 in Weekly Pictures https://thejeshgn.com/2024/01/20/year-2023-in-weekly-pictures/ #Code, #WordPress, […]