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 =353
Array
(
    [] => 
    [frontrow] => frontrow
    [newarrival] => newarrival
)
  • Voltar aos Produtos
    ;1-1900; - ;1; 0
    Lamp Mesh & Petals Big
    Ref:655184003
    205,00 €
    Cor
    Por favor, primeiro escolha uma cor.
    Tamanho
    Quantidade

    Banner-Acess-PORT

    Banners-INTERIORES

    Banner-Woman-PORT

    @copyright 2015 TMcollection

    ENTRAR or Become a member

    ou
    JOIN US

    Carrinho

     x 
    ref.
    carrinho vazio