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
(
    [] => 
    [newarrival] => newarrival
)
  • COM_VIRTUEMART_VOLTAR
    ;1-1900; - ;1; 0
    Cushion Rectangular Spring Tunder
    Ref:824158019
    125,00 €
    62,50 €

    Rectangular cushion with digital printed all-over pattern front, plain back and tonal zip.

    50% Silk l 30% Linen l 20% Cotton l Lining: 100% Cotton l 100% Polyester filler

     

    Colour
    Please choose a color first.
    Size
    Quantity

    Banner-Acess

    Banner-loja-INTERIORS

    Banner-Woman

    @copyright 2015 TMcollection

    ENTRAR or Become a member

    ou
    JOIN US

    Your Basket

     x 
    ref.
    Basket empty