SELECT gds.*, SYSDATE() - DATE_ADD(`gds_dbeg`, INTERVAL 0 DAY) as oldSecond, gds_is.mf_value as is_name, gds_is.mf_className as is_className, gds_unit.mf_value as unit_name FROM goods gds LEFT JOIN morefld gds_unit ON gds_unit.mf_id = gds.gds_unit, morefld gds_is WHERE ctl_id = 41809 AND gds_is.mf_id = gds.gds_is AND gds_view = 1 ORDER BY gds_dbeg DESC, gds_name ASC/41334262/
В данной категории товаров имеются следующие подразделы: