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 = '{EB1E91D2-B2BB-41FD-8D03-0B07D82C50E7}') 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 '12%meter%iridium%antenna%cable'