+-------+---------+-----------------------+-------------------+-----------+---------+-----------+------------+-------------------+--------------+---------------+
| id    | ship_id | SUM(p.titanium_bonus) | SUM(p.food_bonus) | e_prod    | t_prod  | f_prod    | planet_pop | SUM(p.pop_growth) | b_crew_bonus | bt_crew_bonus |
+-------+---------+-----------------------+-------------------+-----------+---------+-----------+------------+-------------------+--------------+---------------+
| 46882 |      28 |                  1342 |              1103 | 300328620 | 5116760 | 309550440 |   46831144 |          -2990311 |      2027442 |           183 |
+-------+---------+-----------------------+-------------------+-----------+---------+-----------+------------+-------------------+--------------+---------------+