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