Výber základných produktov (bez rodiča), pričom ku každému produktu je zistený počet detských produktov (variants).

SELECT products.uid AS products_uid, products.title AS products_title, products.price AS products_price, 
	(	SELECT COUNT( * )
		FROM tx_rtgshop_products
		WHERE tx_rtgshop_products.tx_rtgextshop2_uid_product = products.uid
			AND tx_rtgshop_products.deleted =0
			AND tx_rtgshop_products.hidden =0
	) AS variants
FROM tx_rtgshop_products AS products
WHERE products.pid IN ( 42 )
	AND products.deleted =0
	AND products.hidden =0
	AND products.tx_rtgextshop2_uid_product =0
LIMIT 0, 30

Výsledok