MySQL count statements error - operand should contain 1 column(s)

Question

I am trying to do multiple counts everyone was working accept the first sub select (list1) I get an error that reads "Operand should contain 1 column(s)" i'm guessing it has something to do with the AND, but i'm not sure how I would fix this one.

  Select Count(list0.ustatus) AS finished_count
       ,   (Select list1.ustatus, Count(*) 
              From listofupdates list1 
             Where list1.ustarted != '0000-00-00 00:00:00' 
               AND list1.ustatus != 1
           ) AS start_count
       ,   (Select Count(list2.udifficulty) 
              From listofupdates list2 
             Where  list2.udifficulty = 2
           )  AS recheck_count
       ,   (Select Count(list3.udifficulty) 
              From listofupdates list3 
              Where  list3.udifficulty = 4
           )  AS question_count 
     From listofupdates as list0 
    Where  list0.ustatus = 1 

Answer 1

The problem's most likely on the lines with

FROM listofupdates listX

(where X is 0, 1, 2, 3)

It would seem that just list0, list1, list2, list3 in these cases would suffice.

Answer 2

In the first sub-select, you're trying to select 2 columns. You need to only select one, you can't sub-select multiple columns unless you're doing a comparison with the result.

See MySQL Docs - Subquery Errors.

Answer 3

i completely aggree with @Chad Birch

Following query should work.

 Select Count(list0.ustatus) AS finished_count
       ,   (Select  Count(*) 
              From listofupdates list1 
             Where list1.ustarted != '0000-00-00 00:00:00' 
               AND list1.ustatus != 1
           ) AS start_count
       ,   (Select Count(list2.udifficulty) 
              From listofupdates list2 
             Where  list2.udifficulty = 2
           )  AS recheck_count
       ,   (Select Count(list3.udifficulty) 
              From listofupdates list3 
              Where  list3.udifficulty = 4
           )  AS question_count 
     From listofupdates as list0 
    Where  list0.ustatus = 1