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
)
  • Produtos por página
    ;1-1900;-1
    250,00 €
    200,00 €
    ;1-1900;-1
    240,00 €
    192,00 €
    ;1-1900;-1
    240,00 €
    192,00 €
    Novo
    ;1-1900;-1
    399,00 €
    319,20 €
    ;1-1900;-1
    307,00 €
    245,60 €
    ;1-1900;-1
    364,00 €
    291,20 €
    ;1-1900;-1
    310,00 €
    248,00 €
    ;1-1900;-1
    347,00 €
    277,60 €
    ;1-1900;-1
    350,00 €
    280,00 €
    ;1-1900;-1
    250,00 €
    150,00 €
    ;1-1900;-1
    250,00 €
    150,00 €
    ;1-1900;-1
    250,00 €
    200,00 €

    banner-loja-bri

    Banner-Acess-PORT

    Banners2-FW14

    1facebook   2instagram   3pinte   4youtube   5twitter   The Reseller Network  
    @copyright 2015 TMcollection

    ENTRAR or Become a member

    ou
    JOIN US

    Carrinho

     x 
    ref.
    carrinho vazio