Error: select top (@p0) [frame].[id], [frame].[name], [frame].[description], [frame].[year], [frame].[updated], [frame].[link_name], [frame].[rx_frame_only_price], [frame].[is_beveled], [frame].[active], [frame].[is_discontinued], [frame].[date_created], [frame].[date_updated], [frame].[vto_override], [frame].[has_default_image], [frame].[is_safilo_feed], [frame].[rank], [frame].[toggle_add_to_cart_btn], ( SELECT TOP 1 ISNULL(b.name, '') + ' ' + ISNULL(c.name, '') FROM brand b JOIN frame f2 ON b.id = f2.brand_id JOIN category_frame_jn cfj ON cfj.frame_id = f2.id JOIN category c ON c.id = cfj.category_id WHERE f2.id = frame.id ) AS brand_category, ( SELECT TOP 1 SUM(fi.quantity) FROM frame_inventory_jn fi INNER JOIN frame_variation fv ON fv.id = fi.frame_variation_id AND fv.frame_id = frame.id WHERE fi.is_deleted = 0 ) AS total_stock, ( SELECT TOP 1 b.id, b.name FROM brand b JOIN frame f2 ON b.id = f2.brand_id WHERE f2.id = frame.id FOR JSON PATH, WITHOUT_ARRAY_WRAPPER ) AS brand_info, ( SELECT TOP 1 c.id, c.name FROM category c JOIN category_frame_jn cfj ON c.id = cfj.category_id WHERE cfj.frame_id = frame.id FOR JSON PATH, WITHOUT_ARRAY_WRAPPER ) AS category_info, ( SELECT TOP 1 ROUND(fv.price * 2, 2) FROM frame_variation AS fv WHERE fv.frame_id = frame.id ORDER BY fv.id ) AS strike_price, ( SELECT TOP 1 fv.price FROM frame_variation AS fv WHERE fv.frame_id = frame.id ORDER BY fv.id ) AS price, ( SELECT COALESCE((SELECT color.id AS id, color.name AS name, CONCAT(@p1, MIN(frame_image.file_name)) AS image_url FROM frame_variation LEFT JOIN color ON frame_variation.frame_color_id = color.id LEFT JOIN frame_image ON frame_variation.id = frame_image.frame_variation_id WHERE frame_variation.frame_id = frame.id AND frame_image.file_name IS NOT NULL AND frame_image.is_user_uploaded = 1 GROUP BY color.id, color.name FOR JSON PATH), '[]') ) AS colors, ( SELECT COALESCE(( SELECT id, eye, dbl, temple, b AS b_size, custom_size AS size_label, ( LTRIM(STR(eye, 10, 0)) + ' - ' + LTRIM(STR(dbl, 10, 0)) + ' - ' + LTRIM(STR(temple, 10, 0)) + ' B' + LTRIM(STR(FLOOR(b), 10, 0)) + ' - ' + CAST(CASE WHEN b IS NULL THEN '' WHEN CAST(b AS float) <= 44 THEN 'Small' WHEN CAST(b AS float) <= 46 THEN 'Medium' WHEN CAST(b AS float) <= 48 THEN 'Large' ELSE 'X-Large' END AS varchar) ) AS display_size FROM frame_size WHERE frame_size.frame_id = frame.id FOR JSON PATH ), '[]') ) AS sizes, ( SELECT COALESCE(( SELECT CONCAT(@p2, fi.file_name) AS image_url, fi.is_default FROM frame_variation as fv INNER JOIN color as c ON fv.frame_color_id = c.id INNER JOIN frame_image as fi ON fv.id = fi.frame_variation_id AND fi.image_type = 'quarterly' AND fi.file_name LIKE '%.jpg' AND fi.is_user_uploaded = 1 WHERE fv.frame_id = frame.id ORDER BY fi.is_default DESC, fv.is_default DESC, fv.is_active DESC, fi.sort_order ASC FOR JSON PATH ), '[]') ) AS images, ( SELECT ( SELECT g.id, g.name FROM frame_gender_jn fg JOIN gender g ON g.id = fg.gender_id WHERE fg.frame_id = frame.id FOR JSON PATH ) AS gender, ( SELECT ag.id, ag.name FROM frame_age_group_jn fag JOIN age_group ag ON ag.id = fag.age_group_id WHERE fag.frame_id = frame.id FOR JSON PATH ) AS age_group, ( SELECT sh.id, sh.name FROM frame_shape_jn fs JOIN shape sh ON sh.id = fs.shape_id WHERE fs.frame_id = frame.id FOR JSON PATH ) AS shape, ( SELECT et.id, et.name FROM frame_rim_jn etj JOIN rim et ON et.id = etj.rim_id WHERE etj.frame_id = frame.id FOR JSON PATH ) AS rim, ( SELECT h.id, h.name FROM frame_hinge_jn fhj JOIN hinge h ON h.id = fhj.hinge_id WHERE fhj.frame_id = frame.id FOR JSON PATH ) AS hinge, ( SELECT t.id, t.name FROM frame_temple_jn ftj JOIN temple t ON t.id = ftj.temple_id WHERE ftj.frame_id = frame.id FOR JSON PATH ) AS temple, ( SELECT b.id, b.name FROM frame_bridge_jn fbj JOIN bridge b ON b.id = fbj.bridge_id WHERE fbj.frame_id = frame.id FOR JSON PATH ) AS bridge, ( SELECT c.id, c.name FROM frame_country_jn fc JOIN frame_country c ON c.id = fc.country_id WHERE fc.frame_id = frame.id FOR JSON PATH ) AS country, ( SELECT w.id, w.name FROM frame_warranty_jn fw JOIN warranty w ON w.id = fw.warranty_id WHERE fw.frame_id = frame.id FOR JSON PATH ) AS manufacturer_warranty, ( SELECT cat.id, cat.name FROM category_frame_jn cf JOIN category cat ON cat.id = cf.category_id WHERE cf.frame_id = frame.id FOR JSON PATH ) AS category, ( SELECT ft.id, ft.name FROM frame_frame_type_jn ftj JOIN frame_type ft ON ft.id = ftj.frame_type_id WHERE ftj.frame_id = frame.id FOR JSON PATH ) AS product_group, ( SELECT specs FROM frame_specs WHERE frame_id = frame.id FOR JSON PATH ) AS specs FOR JSON PATH, WITHOUT_ARRAY_WRAPPER ) AS product_details from [frame] where [frame].[link_name] = @p3 and [frame].[active] = @p4 - Error converting data type varchar to float.
