Mysql sub query optimization

[JH NG]

****Dependent Subquery****

SELECT c.category_id,
c.parent_id,
cd.name,
(SELECT Count(p.product_id)
FROM oc_product_to_category p2c
LEFT JOIN oc_product p
ON ( p.product_id = p2c.product_id )
LEFT JOIN oc_product_to_store p2s
ON ( p.product_id = p2s.product_id )
WHERE p.status = '1'
AND p.date_available <= Now()
AND p2s.store_id = '0'
AND p2c.category_id = c.category_id) AS total

FROM oc_category c
LEFT JOIN oc_category_description cd
ON ( c.category_id = cd.category_id )
LEFT JOIN oc_category_to_store c2s
ON ( c.category_id = c2s.category_id )

WHERE cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
ORDER BY c.sort_order,
Lcase(cd.name)




****Derived Sub query****
SELECT c.category_id,
c.parent_id,
cd.name,
if(t.total IS NULL, 0, total) as total

FROM oc_category c
LEFT JOIN oc_category_description cd
ON ( c.category_id = cd.category_id )
LEFT JOIN oc_category_to_store c2s
ON ( c.category_id = c2s.category_id )

LEFT JOIN (
SELECT Count(p.product_id) as total, p2c.category_id
FROM oc_product_to_category p2c
LEFT JOIN oc_product p
ON ( p.product_id = p2c.product_id )
LEFT JOIN oc_product_to_store p2s
ON ( p.product_id = p2s.product_id )
WHERE p.status = '1'
AND p.date_available <= Now()
AND p2s.store_id = '0'
GROUP BY p2c.category_id) t
ON ( t.category_id = c.category_id )

WHERE cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
ORDER BY c.sort_order,
Lcase(cd.name)

Dear all Pros,please give some opinion on the sub query above that which one of them is better for an open cart system.