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 = '{70ECC41F-744C-435A-AE50-373BDF8FED0A}') 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 'inmarsat') AND [CATEGORY] IN (SELECT CATEGORY_ID FROM [RESI].[dbo].[USERS_SHOPPINGCART_PRODUCT_CATEGORIES] WHERE CATEGORY_NAME LIKE 'portable') AND [MODEL_NAME] LIKE 'beam%isatdock%pro%bundle'