SELECT DISTINCT
idCatalogNum AS catalogNum,
fullName,
volume,
weight,
price,
recPrice,
salePricePercent,
mainImageURL,
secondImageURL,
stockVal,
postTime
FROM Product
INNER JOIN Manufacturer ON manufacturer_id = Manufacturer.idManufacturer
LEFT JOIN Product_SubCategory ON idCatalogNum = Product_SubCategory.catalogNum_id
LEFT JOIN ProductImageList ON idCatalogNum = ProductImageList.catalogNum_id
LEFT JOIN SubCategory ON Product_SubCategory.subCategory_id = SubCategory.idSubCategory
LEFT JOIN Category ON SubCategory.category_id = Category.idCategory
WHERE visibilitySmallM = 1 AND Category.retail = 1 AND Category.menuCategory = :mCatName ORDER BY stockVal DESC, postTime DESC
