briandrawert

SELECT a.ID as 'old_ID', b.ID, b.data_s_star_value, b.`param_Ac`, b.run_tag, g.name, g.model, g.group_name,
CONCAT('groupA__S_star=',CAST(b.data_s_star_value as char),'__Ac=',b.`param_Ac`) as 'new group'
FROM `stochastic_parameter_search` a
JOIN `stochastic_parameter_search` b ON (
a.`param_Nfrogs` = b.`param_Nfrogs` AND
a.`param_gamma` = b.`param_gamma` AND
a.`param_eta` = b.`param_eta` AND
a.`param_nu` = b.`param_nu` AND
a.`param_f` = b.`param_f` AND
a.`param_sigma` = b.`param_sigma` AND