Array
(
    [0] => Array
        (
            [file] => /home/httpd/avero/pomppumestari.fi/includes/functions/database.php
            [line] => 39
            [function] => tep_db_error
            [args] => Array
                (
                    [0] => 
    select discounts_product as products_id, d.*, FALSE as free_shipping, 1 as type
    from discounts d
    join discounts_connected dc on (d.discounts_id = dc.discounts_id)
    where conn_kind = 'conn_products'
    and dc.connected_id in ()
    and discounts_product in ()
    and discounts_status = 1
    and NOW() between d.discount_start_date and d.discount_expires_date
    and discounts_code in ('')

    union

    select dc.connected_id as products_id, d.*, FALSE as free_shipping,  2 as type
    from discounts d
    join discounts_connected dc on (d.discounts_id = dc.discounts_id)
    where conn_kind = 'conn_products'
    and dc.connected_id in ()
    and discounts_product = 0
    and discounts_status = 1
    and NOW() between d.discount_start_date and d.discount_expires_date
    and discounts_code in ('')

    union

    select dc.connected_id as products_id, d.*, FALSE as free_shipping,  3 as type
    from discounts d
    join discounts_connected dc on (d.discounts_id = dc.discounts_id)
    where conn_kind = 'conn_products'
    and dc.connected_id in ()
    and discounts_product in ()
    and discounts_status = 1
    and NOW() between d.discount_start_date and d.discount_expires_date
    and discounts_code in ('')

    union

    select discounts_product as products_id, d.*, FALSE as free_shipping, 4 as type
    from discounts d
    join discounts_connected dc on (d.discounts_id = dc.discounts_id)
    join categories c on (dc.connected_id = c.maincat_name)
    join products_to_categories ptc using (categories_id)
    where conn_kind = 'conn_maincats'
    and ptc.products_id in ()
    and discounts_product in ()
    and discounts_status = 1
    and NOW() between d.discount_start_date and d.discount_expires_date
    and discounts_code in ('')

    union

    select products_id, d.*, FALSE as free_shipping, 5 as type
    from discounts d
    join discounts_connected dc on (d.discounts_id = dc.discounts_id)
    join categories c on (dc.connected_id = c.maincat_name)
    join products_to_categories ptc using (categories_id)
    where conn_kind = 'conn_maincats'
    and ptc.products_id in ()
    and discounts_product = 0
    and discounts_status = 1
    and NOW() between d.discount_start_date and d.discount_expires_date
    and discounts_code in ('')

    union

    select products_id, d.*, FALSE as free_shipping, 6 as type
    from discounts d
    join discounts_connected dc on (d.discounts_id = dc.discounts_id)
    join categories c on (dc.connected_id = c.maincat_name)
    join products_to_categories ptc using (categories_id)
    where conn_kind = 'conn_maincats'
    and ptc.products_id in ()
    and discounts_product in ()
    and discounts_status = 1
    and NOW() between d.discount_start_date and d.discount_expires_date
    and discounts_code in ('')

    union

    select discounts_product as products_id, d.*, FALSE as free_shipping, 7 as type
    from discounts d
    where conn_kind not in ('conn_products', 'conn_maincats')
    and discounts_status = 1
    and discounts_product in (, 0)
    and NOW() between d.discount_start_date and d.discount_expires_date
    and discounts_code in ('')

    union

    SELECT
    b.main_product as products_id, b.bundles_id as discounts_id, '' as discount_start_date, '' as discount_expires_date, b.bundles_name as discounts_name, b.bundles_heading_title as discounts_heading_title, b.bundles_image as discounts_image, b.bundles_description as discounts_description, b.bundles_short as discounts_short, b.sort_order, 'bundle' as discounts_kind, b.date_added, b.last_modified, b.bundles_status as discounts_status, '' as discounts_buyX, '' as discounts_payY, b.bundles_discount as discounts_discount, b.main_product as discounts_product, b.bundles_type as discounts_type, b.bundle_free_delivery as discount_free_delivery, 'conn_bundle' as conn_kind, b.main_quantity as discounts_condition_value, '' as discounts_code, '' as checkbox_mainproduct, '' as checkbox_startpage, '' as checkbox_site_wide, '' as checkbox_cart,
    FALSE as free_shipping, 8 as type

    FROM bundles b
    where b.main_product in ()
     and not exists (select 1 from bundles_products bp where b.bundles_id = bp.bundle_id and bp.article_id not in ())
     and b.bundles_status = 1
     and '' in ('')

    UNION

    SELECT
    bp.article_id as products_id, b.bundles_id as discounts_id, '' as discount_start_date, '' as discount_expires_date, b.bundles_name as discounts_name, b.bundles_heading_title as discounts_heading_title, b.bundles_image as discounts_image, b.bundles_description as discounts_description, b.bundles_short as discounts_short, b.sort_order, 'bundle' as discounts_kind, b.date_added, b.last_modified, b.bundles_status as discounts_status, '' as discounts_buyX, '' as discounts_payY, b.bundles_discount as discounts_discount, b.main_product as discounts_product, b.bundles_type as discounts_type, b.bundle_free_delivery as discount_free_delivery, 'conn_bundle' as conn_kind, bp.article_quantity as discounts_condition_value, '' as discounts_code, '' as checkbox_mainproduct, '' as checkbox_startpage, '' as checkbox_site_wide, '' as checkbox_cart,
    FALSE as free_shipping, 9 as type

    FROM bundles b
    JOIN bundles_products bp on (b.bundles_id = bp.bundle_id)
    where b.main_product in ()
     and bp.article_id in ()
     and not exists (select 1 from bundles_products bp where b.bundles_id = bp.bundle_id and bp.article_id not in ())
     and b.bundles_status = 1
     and '' in ('')

    order by discounts_type desc, discounts_discount desc
    
                    [1] => 
                    [2] => 
                )

        )

    [1] => Array
        (
            [file] => /home/httpd/avero/pomppumestari.fi/includes/functions/general_shop.php
            [line] => 742
            [function] => tep_db_query
            [args] => Array
                (
                    [0] => 
    select discounts_product as products_id, d.*, FALSE as free_shipping, 1 as type
    from discounts d
    join discounts_connected dc on (d.discounts_id = dc.discounts_id)
    where conn_kind = 'conn_products'
    and dc.connected_id in ()
    and discounts_product in ()
    and discounts_status = 1
    and NOW() between d.discount_start_date and d.discount_expires_date
    and discounts_code in ('')

    union

    select dc.connected_id as products_id, d.*, FALSE as free_shipping,  2 as type
    from discounts d
    join discounts_connected dc on (d.discounts_id = dc.discounts_id)
    where conn_kind = 'conn_products'
    and dc.connected_id in ()
    and discounts_product = 0
    and discounts_status = 1
    and NOW() between d.discount_start_date and d.discount_expires_date
    and discounts_code in ('')

    union

    select dc.connected_id as products_id, d.*, FALSE as free_shipping,  3 as type
    from discounts d
    join discounts_connected dc on (d.discounts_id = dc.discounts_id)
    where conn_kind = 'conn_products'
    and dc.connected_id in ()
    and discounts_product in ()
    and discounts_status = 1
    and NOW() between d.discount_start_date and d.discount_expires_date
    and discounts_code in ('')

    union

    select discounts_product as products_id, d.*, FALSE as free_shipping, 4 as type
    from discounts d
    join discounts_connected dc on (d.discounts_id = dc.discounts_id)
    join categories c on (dc.connected_id = c.maincat_name)
    join products_to_categories ptc using (categories_id)
    where conn_kind = 'conn_maincats'
    and ptc.products_id in ()
    and discounts_product in ()
    and discounts_status = 1
    and NOW() between d.discount_start_date and d.discount_expires_date
    and discounts_code in ('')

    union

    select products_id, d.*, FALSE as free_shipping, 5 as type
    from discounts d
    join discounts_connected dc on (d.discounts_id = dc.discounts_id)
    join categories c on (dc.connected_id = c.maincat_name)
    join products_to_categories ptc using (categories_id)
    where conn_kind = 'conn_maincats'
    and ptc.products_id in ()
    and discounts_product = 0
    and discounts_status = 1
    and NOW() between d.discount_start_date and d.discount_expires_date
    and discounts_code in ('')

    union

    select products_id, d.*, FALSE as free_shipping, 6 as type
    from discounts d
    join discounts_connected dc on (d.discounts_id = dc.discounts_id)
    join categories c on (dc.connected_id = c.maincat_name)
    join products_to_categories ptc using (categories_id)
    where conn_kind = 'conn_maincats'
    and ptc.products_id in ()
    and discounts_product in ()
    and discounts_status = 1
    and NOW() between d.discount_start_date and d.discount_expires_date
    and discounts_code in ('')

    union

    select discounts_product as products_id, d.*, FALSE as free_shipping, 7 as type
    from discounts d
    where conn_kind not in ('conn_products', 'conn_maincats')
    and discounts_status = 1
    and discounts_product in (, 0)
    and NOW() between d.discount_start_date and d.discount_expires_date
    and discounts_code in ('')

    union

    SELECT
    b.main_product as products_id, b.bundles_id as discounts_id, '' as discount_start_date, '' as discount_expires_date, b.bundles_name as discounts_name, b.bundles_heading_title as discounts_heading_title, b.bundles_image as discounts_image, b.bundles_description as discounts_description, b.bundles_short as discounts_short, b.sort_order, 'bundle' as discounts_kind, b.date_added, b.last_modified, b.bundles_status as discounts_status, '' as discounts_buyX, '' as discounts_payY, b.bundles_discount as discounts_discount, b.main_product as discounts_product, b.bundles_type as discounts_type, b.bundle_free_delivery as discount_free_delivery, 'conn_bundle' as conn_kind, b.main_quantity as discounts_condition_value, '' as discounts_code, '' as checkbox_mainproduct, '' as checkbox_startpage, '' as checkbox_site_wide, '' as checkbox_cart,
    FALSE as free_shipping, 8 as type

    FROM bundles b
    where b.main_product in ()
     and not exists (select 1 from bundles_products bp where b.bundles_id = bp.bundle_id and bp.article_id not in ())
     and b.bundles_status = 1
     and '' in ('')

    UNION

    SELECT
    bp.article_id as products_id, b.bundles_id as discounts_id, '' as discount_start_date, '' as discount_expires_date, b.bundles_name as discounts_name, b.bundles_heading_title as discounts_heading_title, b.bundles_image as discounts_image, b.bundles_description as discounts_description, b.bundles_short as discounts_short, b.sort_order, 'bundle' as discounts_kind, b.date_added, b.last_modified, b.bundles_status as discounts_status, '' as discounts_buyX, '' as discounts_payY, b.bundles_discount as discounts_discount, b.main_product as discounts_product, b.bundles_type as discounts_type, b.bundle_free_delivery as discount_free_delivery, 'conn_bundle' as conn_kind, bp.article_quantity as discounts_condition_value, '' as discounts_code, '' as checkbox_mainproduct, '' as checkbox_startpage, '' as checkbox_site_wide, '' as checkbox_cart,
    FALSE as free_shipping, 9 as type

    FROM bundles b
    JOIN bundles_products bp on (b.bundles_id = bp.bundle_id)
    where b.main_product in ()
     and bp.article_id in ()
     and not exists (select 1 from bundles_products bp where b.bundles_id = bp.bundle_id and bp.article_id not in ())
     and b.bundles_status = 1
     and '' in ('')

    order by discounts_type desc, discounts_discount desc
    
                )

        )

    [2] => Array
        (
            [file] => /home/httpd/avero/pomppumestari.fi/index_shop.php
            [line] => 272
            [function] => tep_fetch_discounts
            [args] => Array
                (
                    [0] => shoppingCart Object
                        (
                            [contents] => Array
                                (
                                    [] => Array
                                        (
                                            [qty] => 1
                                        )

                                )

                            [total] => 0
                            [weight] => 0
                            [cartID] => 87143
                            [content_type] => 
                        )

                )

        )

)