fenway

If you don't need the UID of newly created records, definitely a multi-valued insert -- just remember that there _is_ a max_packet_length, but it's usually a mb or two, so it's usually not an issue.

How are you making the backup?

I was confused because it wasn't an ENUM. You can use "SUM(IF(result='won',1,0) AS won", etc.

Read this.

You still haven't told us anything helpful -- what's in result?

Show table structure, sample data, etc.

DON'T mark topics "solved" unless you post the solution...

Did you try using ORDER BY inside the GROUP_CONCAT() ???

Why would you want to do such a thing?

Check the counts.... not sure how much control you have of input via phpmyadmin.

No idea... I don't understand any of that. All I'm saying is that you need to confirm that the input you provide to the DB class is what you expect, but that the output isn't -- which means it's flawed.

how about this? select g.name from group as g cross join member as m1 cross join member as m2 inner join groupmembermap as gm1 on ( gm1.group_id = g.id and gm1.member_id = m1.id ) inner join groupmembermap as gm2 on ( gm1.group_id = g.id and gm1.member_id = m1.id ) where m1.name = 'a' and m2.name = 'b'

group concat can take an order by!

Depends if you have a unique index or not... if so, index ignore should work.

From what query?

Then it's broken.

Depends on what character set they fall into.

How do you store that info?

TLDR... can you summarize?

There's really no different on the client side -- just point to a different host name -- but you need to make sure that the remote host allows remote connections.

Post the table structure as is required by the stickies.

count(distinct fanof) from yourtable group by username

Yup.

Where's the mysql part of the problem?

Let's not get into the habit of posting entire scripts here, please.