List all enabled products with no images in Magento 2 with this SQL query

Sometimes when you are working on a webstore, your client might ask you totally reasonable questions like how many products have no images uploaded. To answer this question is not so easy when there are 3000+ products in said shop. As the admin interface doesn't provide an easy way to check for thumbnail-less products, I had to turn to some SQL magic to answer the question.

Enabling Numlock and tap to click on the login screen of Zorin OS (and Ubuntu)

I don't have too many pet peeves, but a disabled Numlock is annoying as hell, especially if you type numbers a lot. It is also infuriating if you physically have to click the trackpad instead of just tapping lightly once you got used to this feature in Windows. When I used a Macbook Pro for a few months this has baffled me but I didn't realize you can enable tap to click in system preferences.

Force Janitor to work with your upgraded Kodi installation

Janitor is an addon for Kodi that will automatically scan your library for watched movies, TV show episodes and music videos based on criteria such as age, rating or free disk space. I set it up to delete what we already saw after 2 days except if it is in a protected folder. It is a great tool to free up disk space on your device, but if you upgrade to a version of Kodi that is not supported, it will be disabled and you will have to delete stuff manually again.

adplus-dvertising