SELECT container.i_autocode as id FROM container
INNER JOIN image_infofr ON (container.i_autocode=image_infofr.i_foreigncode)
INNER JOIN container_topic16 ON (container.i_autocode=container_topic16.i_containercode)
INNER JOIN topic16 ON (container_topic16.i_foreigncode=topic16.i_autocode)
INNER JOIN image_file ON (image_file.i_foreigncode=container.i_autocode)
LEFT JOIN containerrating ON (containerrating.i_foreigncode=container.i_autocode)
LEFT JOIN _statmedia ON (_statmedia.i_containercode=container.i_autocode) WHERE topic16.i_leftidx>=3 AND topic16.i_rightidx<=4 AND container.i_mode&1
AND container.b_isonline=1 AND container.i_typemsk&3 GROUP BY container.i_autocode ORDER BY topic16.i_leftidx, container_topic16.i_sortidx, container.s_reference
LIMIT 76, 1
