Code: Select all
SELECT
COUNT(DISTINCT `a`) AS `aa`,
COUNT(*) AS `bb`
FROM
`mytable`
WHERE
(`c` LIKE '%domain1.com%/')
OR
(`c` LIKE '%domain2.com/%')
OR
(`c` LIKE '%domain3.com/%')
OR
(`c` LIKE '%domain4.com/%')
AND
`d` >= '1222997561'I'd like my results to look like this:
Code: Select all
aa | bb | c
---------------------------
123 456 domain1.com
153 3829 domain2.com
72 283 domain3.com
112 8559 domain4.comIs what I'm trying to do possible, or a similar functionality available?