Fa Xtreme tuhý men power+ 50ML

Array
(
    [block_id] => 1039
    [type] => products
    [properties] => Array
        (
            [template] => blocks/products/products_multicolumns.tpl
            [item_number] => N
            [number_of_columns] => 2
            [abt__ut2_demo_block_id] => 
            [hide_add_to_cart_button] => N
            [sb_hide_out_of_stock_products] => Y
        )

    [company_id] => 0
    [storefront_id] => 1
    [lang_code] => vi
    [name] => Related products
    [snapping_id] => 0
    [object_id] => 348672
    [object_type] => products
    [content] => Array
        (
            [items] => Array
                (
                    [filling] => similar
                    [limit] => 12
                    [percent_range] => 
                    [similar_category] => Y
                    [similar_subcats] => Y
                    [similar_in_stock] => N
                )

        )

    [availability] => Array
        (
            [phone] => 1
            [tablet] => 1
            [desktop] => 1
        )

)

SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, companies.company as company_name, products.amount AS p_amount, products.min_qty, products.max_qty, products.qty_step FROM ?:products as products  INNER JOIN ?:product_features_values as c_var ON c_var.product_id = products.product_id AND c_var.lang_code = 'cs' AND c_var.variant_id = 5392 LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'cs'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 AND prices.destination_id = 0 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1)  WHERE 1  AND ?:categories.category_id IN (376) AND products.product_id NOT IN (348672) AND companies.status IN ('A')  AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND prices.destination_id = 0 AND products.amount >= 1 AND (products.min_qty IS NULL OR products.amount >= products.min_qty) AND prices.price >= 1.00 AND companies.show_products_on_login = 'N' GROUP BY products.product_id   ORDER BY CASE WHEN (products.amount > 0 AND products.amount >= products.min_qty) THEN 0 ELSE 1 END ASC,  product asc, products.product_id ASC  LIMIT 0, 12