Help with Mysql Query - Subindex_string + group_concat

@tektion,

Try it this way instead (remove the extra comma in the second where statement):

Code:

$Array = $MyModel
   ->where('Column3 !=', 0)
   ->where('SUBSTRING_INDEX(GROUP_CONCAT(GROUP))',1)
   ->orderBy('date', 'DESC')
   ->groupBy('GROUP')
   ->limit(2)
   ->find();