SELECT *, (SELECT * FROM tb2 WHERE tb2.tb2_id=tb1.id LIMIT 1) as newname FROM ((tb1 Left Join tb3 ON tb3 = tb3)) WHERE tb1.ok=1 ORDER BY tb1.date DESC
Attention in classroom
SELECT *, (SELECT * FROM tb2 WHERE tb2.tb2_id=tb1.id LIMIT 1) as newname FROM ((tb1 Left Join tb3 ON tb3 = tb3)) WHERE tb1.ok=1 ORDER BY tb1.date DESC