This thread is about a hack the person wants to achieve. MJM and Carole are famous for there need to change the default working of the code and I assist where I can.
There is no anomaly in the code there are suppose to be multiple photos shown if you use the additional cats thing. This is the design of the entire function. It is suppose to act like 3 different photos.
We do not support code modification which this whole issue is about I am just being nice here and trying to give pointers.
Honestly I don't think I can be any more explicit. I stated the exact line beginning and end that you need to modify every query between that and add
AND storecat='0'
Your posted an example query and I replied that it needed to go before the sortcode with the rest of the AND statements. You want an example try this
Code:
Content visible to verified customers only.
Give that a try. As far as your other question that is how it is designed. 3 queries since it is suppose to be 3 photos and only one photo on disk. Just how it is designed to allow 3 photos and only 1 photo on disk to be used so it saves space. You need a photo insert for each additional cat