CREATE OR REPLACE ALGORITHM = MERGE VIEW dwh_classifier_products AS
SELECT cbtp.classifier_binds_to_products_id AS classifier_products_id
    , cbtp.object_id AS products_id
    , IFNULL(cc.classifier_categories_name, '-') AS categories_name
    , IFNULL(cs.classifier_subcategories_name, '-') AS subcategories_name
    , IFNULL(cl_age_groups.classifier_lists_name, '-') AS age_groups_name
    , IFNULL(cl_orientation.classifier_lists_name, '-') AS orientation_name
    , IFNULL(cl_accessories.classifier_lists_name, '-') AS accessories_name
FROM classifier_binds_to_products cbtp
      LEFT JOIN classifier_categories cc ON cc.classifier_categories_id = cbtp.classifier_categories_id
      LEFT JOIN classifier_subcategories cs ON cs.classifier_subcategories_id = cbtp.classifier_subcategories_id
      LEFT JOIN classifier_lists cl_age_groups ON cl_age_groups.classifier_lists_component = 'classifier_age_groups'
                  AND cl_age_groups.classifier_lists_id = cbtp.classifier_age_groups_id
      LEFT JOIN classifier_lists cl_orientation ON cl_orientation.classifier_lists_component = 'classifier_orientation'
                  AND cl_orientation.classifier_lists_id = cbtp.classifier_orientations_id
      LEFT JOIN classifier_lists cl_accessories ON cl_accessories.classifier_lists_component = 'classifier_accessories'
                  AND cl_accessories.classifier_lists_id = cbtp.classifier_accessories_id
    JOIN dwh_upload_config AS duc on duc.component = 'dwh_classifier_products'
WHERE 1 = 1
    AND (duc.date_from_use = 0 OR cbtp.date_added >= duc.date_from)
    AND (duc.date_to_use = 0 OR cbtp.date_added <= duc.date_to)
    AND (duc.id_from_use = 0 OR cbtp.classifier_binds_to_products_id >= duc.id_from)
    AND (duc.id_to_use = 0 OR cbtp.classifier_binds_to_products_id <= duc.id_to)

order by cbtp.classifier_binds_to_products_id
;