GO
SELECT TOP 1 * FROM SEC_ITEM WHERE BRAND_ID = 20002 AND (PICKUPTYPE IS NULL OR PickupType<6) AND ((ITEM_STATE = 0 AND (ADMIN_ID<>1 OR (ADMIN_ID=1 AND ITEM_UDATE <'2012-07-04 11:26')) OR (ITEM_STATE = 2 AND ITEM_UDATE <'2012-07-04 11:26'))) ORDER BY Item_CDate
DESC, PICKUPTYPE ASC, ITEM_UDATE DESC
GO
--最优
SELECT TOP 1 * FROM SEC_ITEM WHERE BRAND_ID = 20002 AND (PICKUPTYPE IS NULL OR PickupType<6) AND ((ITEM_STATE = 0 AND (ADMIN_ID<>1 OR (ADMIN_ID=1 AND ITEM_UDATE <'2012-07-04 13:40')) OR (ITEM_STATE = 2 AND ITEM_UDATE <'2012-07-04 13:40'))) ORDER BY Item_CDate
DESC
GO