Query #2

SELECT status,
COUNT(increment_id) AS orders_count
FROM sales_flat_order
WHERE increment_id IN (
    "OR012507023680",
    "OR012507021652",
    "OR012507024215",
    "OR012507023291",
    "OR012507022938",
    "OR012507021327",
    "OR012507020886",
    "OR012507021485",
    "OR012507020594",
    "OR012507022772",
    "OR012507022895",
    "OR012507023367",
    "OR012507024275",
    "OR012507021476",
    "OR012507022740",
    "OR012507021109",
    "OR012507020607",
    "OR012507023442",
    "OR012507022918",
    "OR012507024171",
    "OR012507020591",
    "OR012507020592",
    "OR012507024117",
    "OR012507023741",
    "OR012507022208",
    "OR012507000041",
    "OR012507022408",
    "OR012507021458",
    "OR012506020429",
    "OR012507023231",
    "OR012507022669",
    "OR012507020660",
    "OR012507022939",
    "OR012507020549",
    "OR012506020451",
    "OR012507020464",
    "OR012507021216",
    "OR012507021981",
    "OR012507023283",
    "OR012507023350",
    "OR012507023985",
    "OR012507021392",
    "OR012507022049",
    "OR012507023609",
    "OR012507000039",
    "OR012507000040",
    "OR012507023472",
    "OR012507023478",
    "OR012507023189",
    "OR012507022751",
    "OR012507022754",
    "OR012507022809",
    "OR012507024074",
    "OR012507024076",
    "OR012507022270",
    "OR012507022442",
    "OR012507023108",
    "OR012507020535",
    "OR012507021435",
    "OR012507021285",
    "OR012507021287",
    "OR012507021289",
    "OR012507021424",
    "OR012507022393",
    "OR012507022189",
    "OR012507021606",
    "OR012507021651",
    "OR012507022444",
    "OR012507021270",
    "OR012507020532",
    "OR012507022241",
    "OR012507022268",
    "OR012507022272",
    "OR012507022273",
    "OR012507023156",
    "OR012507023626"
)
GROUP BY 1;