SELECT count(*) as countt
FROM `jos_virtuemart_product_customfields` AS c1
LEFT JOIN jos_virtuemart_product_categories as c3 ON c3.virtuemart_product_id = c1.virtuemart_product_id LEFT JOIN jos_virtuemart_products AS pd
ON pd.virtuemart_product_id = c1.virtuemart_product_id WHERE c1.`virtuemart_custom_id` =33
AND c1.custom_value <> "" AND pd.`product_in_stock` < "10000"AND c3.virtuemart_product_id=c1.virtuemart_product_id
AND c3.virtuemart_category_id =416
Array
(
[] =>
[timeless] => timeless
[newarrival] => newarrival
[frontrow] => frontrow
[0] => lookbook
)