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 =355
Array
(
    [] => 
    [newarrival] => newarrival
    [frontrow] => frontrow
    [0] => lookbook
)
  • COM_VIRTUEMART_VOLTAR
    ;1-1900; - ;1; 0
    Shirt Cress Twinkle
    Ref:570181055
    199,00 €

    Soft, light and delicate cotton with details on the arms that will surprise you. You can mix and match it with skirts or trousers, but also wear it with your favourite jeans. Glitter pailettes add a little bit of glamour to this shirt.

    Colour
    Please choose a color first.
    Size
    Quantity

    Banner-Acess

    Banners-Home-FW14

    @copyright 2015 TMcollection

    ENTRAR or Become a member

    ou
    JOIN US

    Your Basket

     x 
    ref.
    Basket empty