Ok
Is there a way to "GROUP BY" using a "like" clause?
How can I avoid showing rows returning 0 (zeros) while using IN clause ?
What's the easiest way to build a where clause based on a unix timestamp on app side when I have separate date and time fields? seems a bit slow to do: where date>=from_unixtime... and date=from_un