SELECT * FROM `showFlats` WHERE `state_group` = 1  LIMIT -6,6