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.
-
- Theyyam in Thrissur
-
- Pathu and Echo investigating an intruder (cat)
-
- paperd.ink
-
- BuzzWomen Bus
-
- Sir M. Visvesvaraya Terminal
-
- A new mattress for pathu.
-
- TVC
-
- Laptop cover – Hand made by Anjus Amma
-
- 100+ years ago. Gandhi was arrested on the charges on sedition – NYT
-
- On the way
-
- HAB launch at CREST, Hosakote
-
- Geist Brewing Co. Hennur
-
- Equality Day
-
- Ramzan Food
-
- Playtime
-
- 2023 Assembly Elections
-
- Students gave me flowers at the end of the session. I like the flowers (not the plastic), and the guest house had no flower vases. So I had to use the water jug as a vase.
-
- Board at IITM. I didnt know about this. It will be interesting to see what kind of snakes live there. I have seen all kinds of insects and plants there.
-
- Statue of Dr. Rajkumar in Malleshwara
-
- Picture from 2021, Pathu and Me.
-
- Sandeep and I at BMST.
-
- Pathu is still very suspicious of Roomba.
-
- SONOFF SNZB-02 – ZigBee Temperature and Humidity Sensor
-
- Spent time with friends and their families
-
- Brass tumblers for coffee
-
- Cameras at the junction of Brigade Road and Church Street. Initially it had one I think. Now has five. Why?
-
- Echo at CUPA.
-
- She loves picture books
-
- Sleep Pattern
-
- Echo, Pathu and Me
-
- Closeup front view. away luggage box
-
- Vadanapally Beach
-
- Snehatheeram Beach. I think crows make good outdoor pets.
-
- Echo and Pathu on our trip.
-
- The child is father of the man
-
- Bekkina Kaadu – Savandurga Hills in the background.
-
- Echo
-
- Appa busy with news
-
- Izumi, Bandra, Mumbai
-
- Tree in Cubbon Park. They have numbers now.
-
- She never stops until she learns a new skill—she is such an inspiration to adults.
-
- Near Erode, we took a break.
-
- WikiConference Kerala, Thrissur, 2023
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, […]