SELECT categories.name AS c_name, categories.url AS c_url, products.url AS p_url, products.name AS p_name, products.price, products.image, products.price_discounted,
                                    (SELECT GROUP_CONCAT(name)
                                        FROM product_colors
                                        WHERE product_id = products.id) AS colors,
                                    (SELECT SUM(stock_count)
                                        FROM product_colors
                                        WHERE product_id = products.id) AS p_stock_count
                                    FROM products
                                    LEFT JOIN categories
                                    ON products.category_id = categories.id
                                    WHERE categories.url = ? AND products.deleted = 0
                                    ORDER BY order_nr
                                    HAVING p_stock_count > 0