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 = '{2968A9A2-12ED-4C9A-9493-3226F8320232}') 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'