SELECT DISTINCT a.entity_id,c.in_pack as pack_size,t.value AS title,a.value AS h1_tags,b.value AS model_no,c.sku,d.value AS meta_title,e.value AS meta_desc,f.value AS image,alt.label AS alt_label,ROUND(g.value*1.420000000000,2) AS global_price,ROUND(g.value,2) AS usd_price,h.value AS brand_id,i.name AS brand,i.logo AS brand_img,i.url_key,j.url AS `request_path`,m.request_path AS request_path_2,k.value AS crs_ref,j.specs_info,j.is_index AS is_index,upc_txt.value AS upc_code,stk_itm.qty,stk_itm.min_qty,stk_itm.qty_increments,vd.value as video_link FROM rpt_catalog_product_entity_varchar AS a INNER JOIN rpt_catalog_product_entity_varchar AS b ON a.entity_id=b.entity_id INNER JOIN rpt_catalog_product_entity AS c ON a.entity_id=c.entity_id INNER JOIN rpt_catalog_product_entity_varchar AS d ON a.entity_id=d.entity_id INNER JOIN rpt_catalog_product_entity_varchar AS e ON a.entity_id=e.entity_id INNER JOIN rpt_catalog_product_entity_varchar AS f ON a.entity_id=f.entity_id INNER JOIN rpt_catalog_product_entity_decimal AS g ON a.entity_id=g.entity_id INNER JOIN rpt_catalog_product_entity_int AS h ON a.entity_id=h.entity_id INNER JOIN rpt_emizentech_shopbybrand_items AS i ON h.value=i.attribute_id INNER JOIN rpt_amp_pages_url AS j ON a.entity_id=j.entity_id INNER JOIN rpt_url_rewrite AS m ON a.entity_id=m.entity_id AND m.entity_type='product' INNER JOIN rpt_catalog_product_entity_text AS t ON a.entity_id=t.entity_id INNER JOIN `rpt_cataloginventory_stock_item` AS stk_itm ON a.entity_id=stk_itm.product_id LEFT JOIN rpt_catalog_product_entity_text AS k ON a.entity_id=k.entity_id AND k.attribute_id=31770 LEFT JOIN rpt_catalog_product_entity_varchar AS upc_txt ON a.entity_id=upc_txt.entity_id AND upc_txt.attribute_id=31955 LEFT JOIN rpt_catalog_product_entity_varchar AS vd ON a.entity_id=vd.entity_id AND vd.attribute_id=31551 LEFT JOIN rpt_catalog_product_entity_media_gallery_value AS alt ON a.entity_id=alt.entity_id WHERE a.entity_id=1048415 AND a.attribute_id=73 AND b.attribute_id=151 AND d.attribute_id=84 AND d.store_id=0 AND e.attribute_id=86 AND f.attribute_id=87 AND g.attribute_id=77 AND t.attribute_id=76 AND h.attribute_id=83 ORDER BY j.url DESC