Такой запрос
select prihod.*,shtrafy.* from sotr,shtrafy left join shtrafy on
shtrafy.date=prihod.date_prihod where sotr.u_id="" and
prihod.date_prihod>DATE_SUB(CURRENT_DATE, INTERVAL 1
MONTH) order by prihod.prihod_date LIMIT 0, 30
Ответ MySQL:
Not unique table/alias: \'shtrafy\'