Автоинкремент должен быть "честным",
т.е. удалив товар 3 у пользователя 1, у следующего товара будет id - 4.
select * from artists LEFT JOIN subscriptions d ON name=artist_name where artist_name like '%skrill%' and user_name='objque@me';
+----------------------------------+-------+-----------+----------------------------------+
| name | id | user_name | artist_name |
+----------------------------------+-------+-----------+----------------------------------+
| Dillon Francis & Skrillex | 55268 | objque@me | Dillon Francis & Skrillex |
| RL Grime, What So Not & Skrillex | 55781 | objque@me | RL Grime, What So Not & Skrillex |
| Skrillex & GTA | 55857 | objque@me | Skrillex & GTA |
| Skrillex & Kendrick Lamar | 55858 | objque@me | Skrillex & Kendrick Lamar |
| Skrillex & MUST DIE! | 55859 | objque@me | Skrillex & MUST DIE! |
| Skrillex & Rick Ross | 55860 | objque@me | Skrillex & Rick Ross |
| Skrillex | 55861 | objque@me | Skrillex |
| Wiwek & Skrillex | 56023 | objque@me | Wiwek & Skrillex |
| Yogi & Skrillex | 56030 | objque@me | Yogi & Skrillex |
+----------------------------------+-------+-----------+----------------------------------+
9 rows in set (0.000 sec)