SELECT [PRODUCT_ID],[ACTIVE],[USER_NAME],[BRAND],[SUB_CATEGORY],[MODEL_NAME],[MODEL_NUMBER],[DESCRIPTION], [SPECIFICATIONS],[FAQ],[VIDEOS],[REGULAR_PRICE],[SALE_PRICE],[COLOR],[VOICE],[DATA_EMAIL],[DATA_WEB],[SMS],[TRACKING],[SHOW_PRICE],[AVAILABLE],[UPLOAD_FOLDER_ID], (SELECT BRAND_LONG_NAME FROM [RESI].[dbo].[USERS_SHOPPINGCART_PRODUCT_BRANDS] WHERE BRAND_ID = USCP.BRAND) AS BRAND_LABEL, (SELECT CATEGORY_NAME FROM [RESI].[dbo].[USERS_SHOPPINGCART_PRODUCT_CATEGORIES] WHERE CATEGORY_ID = USCP.CATEGORY) AS CATEGORY_LABEL, (SELECT TOP 1 FILE_NAME FROM [RESI].[dbo].[USERS_SHOPPINGCART_UPLOADS] WHERE FOLDER_ID = USCP.[UPLOAD_FOLDER_ID] ORDER BY ISNULL(SORT_ID,9999) ASC) AS PIC, (SELECT ISNULL(QTY,0) FROM [RESI].[dbo].[USERS_SHOPPINGCART_CART_DETAILS] WHERE PRODUCT_ID = USCP.PRODUCT_ID AND CART_ID = '{2B86341E-5F98-48FA-B2C3-F4AF95CE07A4}') AS CARTQTY FROM [RESI].[dbo].[USERS_SHOPPINGCART_PRODUCTS] USCP WHERE USER_NAME = 'SPS' AND [BRAND] IN (SELECT BRAND_ID FROM [RESI].[dbo].[USERS_SHOPPINGCART_PRODUCT_BRANDS] WHERE BRAND_LONG_NAME LIKE 'beam') AND [CATEGORY] IN (SELECT CATEGORY_ID FROM [RESI].[dbo].[USERS_SHOPPINGCART_PRODUCT_CATEGORIES] WHERE CATEGORY_NAME LIKE 'accessory') AND [MODEL_NAME] LIKE '40%m%antenna%cable%for%oceana%terminals'