I was using this (http://rextester.com/VXZONO82847) in MySQL but I am not able to use it in Phoenix. Basically what the query does is "select only one row where a column combination (type and item_id) is common and count how many more of the combination exists". It allows me to add the following feature to my notifications system "John Brown and 5 others like your post"
Can anyone answer any of these? 1. Why doesn't it work in Phoenix? 2. How can I get that query to work? Regards, Cheyenne
