If I have

LookupID LookupValue

====== =========

1 Red

2 Blue

3 Orange

and I run a count of values, grouped by the value, I'd get this.

count(lookupvalue) count(*)

============ ======

1 (for Red) 3 (total)

1 (for Blue) 3 (total)

1 (for Orange) 3 (total)

The count(*) is the row count. I'd have to do grouping to get the count by specific values, and include those values. I didn't write all the code here.

If I've been hacked, my table could be:

LookupID LookupValue

====== =========

1 Red

2 Red

3 Red

or

LookupID LookupValue

====== =========

1 Red <script=js>http.redirect 'malicioussite.com</script>

2 Red <script=js>http.redirect 'malicioussite.com</script>

3 Red <script=js>http.redirect 'malicioussite.com</script>

and my counts would be

count(lookupvalue) count(*)

============ ======

3 (for Red) 3 (total)