...
                Tcc1.class_id as class_id,
                Tcc1.name as classcategory_name,
                Tcc2.class_id as parent_class_id,
                Tcc2.name as parent_classcategory_name
                ↓ここから、
                ,dtb_products.sub_title7,
                dtb_products.sub_comment7,
                dtb_products.sub_image7,
                dtb_products.sub_large_image7,
                dtb_products.sub_title8,
                dtb_products.sub_comment8,
                dtb_products.sub_image8,
                dtb_products.sub_large_image8,
                dtb_products.sub_title9,
                dtb_products.sub_comment9,
                dtb_products.sub_image9,
                dtb_products.sub_large_image9,
                dtb_products.sub_title10,
                dtb_products.sub_comment10,
                dtb_products.sub_image10,
                dtb_products.sub_large_image10
                ↑ここまで、追加。
            FROM dtb_products
                LEFT JOIN dtb_products_class
                    ON dtb_products.product_id = dtb_products_class.product_id
...