SELECT
product_metadata.*,
product.id AS product_id,
sum(product.stock) AS stock
FROM
product_metadata
INNER JOIN
tree
ON tree.id = product_metadata.tree_id
INNER JOIN
_rel_product_metadata rpm
ON rpm.product_metadata_id = product_metadata.id
INNER JOIN
product
ON rpm.product_id = product.id
WHERE
(
product.parent_id = 2248
or
(product.id = 2248 and product.stock >= 1)
)
AND product.online = 1
AND ( product_metadata.tree_id = 972 )
GROUP by product_metadata.id
ORDER BY product_metadata.prio, product.parent_id, tree.depth, tree.prio, product.prio
WIPEOUT® BLUE WIPEOUT RUN UNISEX T-SHIRT
