how to use sql subquery with mysql

join shbcf.ru