LEFT JOIN ?:products as products ON products.product_id = ?:product_prices.product_id
			LEFT JOIN ?:product_prices as prices_2 ON ?:product_prices.product_id = prices_2.product_id AND ?:product_prices.price > prices_2.price AND prices_2.lower_limit = 1 AND prices_2.usergroup_id IN (0, 0, 1) LEFT JOIN ?:csc_product_currency_items as csc_product_currency_items ON csc_product_currency_items.product_id=products.product_id AND csc_product_currency_items.company_id=products.company_id LEFT JOIN ?:currencies as currencies ON currencies.currency_code = csc_product_currency_items.currency OR (currencies.is_primary = 'Y' AND (csc_product_currency_items.currency='D' OR csc_product_currency_items.currency IS NULL)) LEFT JOIN ?:ult_product_prices AS shared_prices ON shared_prices.product_id = products.product_id AND shared_prices.lower_limit = 1 AND shared_prices.usergroup_id IN (0, 0, 1) AND shared_prices.company_id = 1 INNER JOIN _product_filters_products_1 ON products.product_id = _product_filters_products_1.product_id

Array
(
    [db_field] => price * currencies.coefficient
    [table] => product_prices
    [description] => price
    [condition_type] => D
    [slider] => 1
    [convert] => Closure Object
        (
            [parameter] => Array
                (
                    [$min] => <required>
                    [$max] => <required>
                    [$extra] => <optional>
                )

        )

    [conditions] => Closure Object
        (
            [parameter] => Array
                (
                    [$db_field] => <required>
                    [$join] => <required>
                    [$condition] => <required>
                )

        )

    [extra] => GBP
    [prefix] => £
    [suffix] => 
)

 LEFT JOIN ?:products as products ON products.product_id = ?:product_prices.product_id
			LEFT JOIN ?:product_prices as prices_2 ON ?:product_prices.product_id = prices_2.product_id AND ?:product_prices.price > prices_2.price AND prices_2.lower_limit = 1 AND prices_2.usergroup_id IN (0, 0, 1) LEFT JOIN ?:csc_product_currency_items as csc_product_currency_items ON csc_product_currency_items.product_id=products.product_id AND csc_product_currency_items.company_id=products.company_id LEFT JOIN ?:currencies as currencies ON currencies.currency_code = csc_product_currency_items.currency OR (currencies.is_primary = 'Y' AND (csc_product_currency_items.currency='D' OR csc_product_currency_items.currency IS NULL)) LEFT JOIN ?:ult_product_prices AS shared_prices ON shared_prices.product_id = products.product_id AND shared_prices.lower_limit = 1 AND shared_prices.usergroup_id IN (0, 0, 1) AND shared_prices.company_id = 1 INNER JOIN _product_filters_products_2 ON products.product_id = _product_filters_products_2.product_id

Array
(
    [db_field] => price * currencies.coefficient
    [table] => product_prices
    [description] => price
    [condition_type] => D
    [slider] => 1
    [convert] => Closure Object
        (
            [parameter] => Array
                (
                    [$min] => <required>
                    [$max] => <required>
                    [$extra] => <optional>
                )

        )

    [conditions] => Closure Object
        (
            [parameter] => Array
                (
                    [$db_field] => <required>
                    [$join] => <required>
                    [$condition] => <required>
                )

        )

    [extra] => GBP
    [prefix] => £
    [suffix] => 
)