SELECT DISTINCT b.pack_qty as pack_size, b.child_product_id AS product_id,b.child_product_url AS url,e.request_path AS mother_url,b.child_product_action AS specs_info,b.child_product_image AS product_image,d.label AS image_label,b.child_product_mpn AS mpn,b.child_product_title AS title ,b.child_product_price AS price,ROUND(b.child_product_price*0.850000000000,2) AS global_price,b.child_product_sku AS sku,c.child_product_dyn_header AS attributes,b.child_product_dyn_1,b.child_product_dyn_2,b.child_product_dyn_3,b.child_product_dyn_4,b.child_product_dyn_5,b.child_product_dyn_6,b.child_product_dyn_7,b.child_product_dyn_8,g.min_qty,g.qty_increments FROM rpt_catalog_product_super_link AS a INNER JOIN raptor21_filters.rpt_section_m_4 AS b ON a.parent_id=b.mp_id AND a.product_id=b.child_product_id INNER JOIN raptor21_filters.rpt_section_m_4 AS f ON a.parent_id=f.mp_id AND a.product_id!=f.child_product_id INNER JOIN raptor21_filters.rpt_section_m_main AS c ON a.parent_id=c.mp_id INNER JOIN rpt_catalog_product_entity_media_gallery_value AS d ON b.child_product_id=d.entity_id INNER JOIN rpt_url_rewrite AS e ON a.parent_id=e.entity_id INNER JOIN `rpt_cataloginventory_stock_item` AS g ON b.child_product_id=g.product_id WHERE f.child_product_id=4653481 AND b.is_active=1 AND e.entity_type='product'