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 = 0
or
(product.id = 0 and product.stock >= 1)
)
AND product.online = 1
AND ( product_metadata.tree_id = 6235 )
GROUP by product_metadata.id
ORDER BY product_metadata.prio, product.parent_id, tree.depth, tree.prio, product.prioSELECT
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 = 0
or
(product.id = 0 and product.stock >= 1)
)
AND product.online = 1
AND ( product_metadata.tree_id = 972 AND product.id in (
select
product_id
from _rel_product_metadata
where
product_metadata_id = 92) )
GROUP by product_metadata.id
ORDER BY product_metadata.prio, product.parent_id, tree.depth, tree.prio, product.prio
WIPEOUT® SUNGLASSES BLACK
