D
А в одну строку что мешает написать?
сделал через:
User::select()
Size: a a a
D
User::select()
RR
СЧ
ДТ
RR
ДТ
СЧ
YP
A
A
YP
A
A
YP
ЮР
A
ЮР
[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '>>\"$.characters\", \"$.student.id\") = `crm_students`.`id` left join `course_rec...' at line 1 at /var/www/marketcouncilalt/data/www/marketcouncilalt.client02.prostoy.ru/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:64)
ЮР
->Join('crm_students', DB::raw('JSON_EXTRACT(crm_contacts.data->>"$.characters", "$.student.id")'),
СЧ
ДБ
->Join('crm_students', DB::raw('JSON_EXTRACT(crm_contacts.data->>"$.characters", "$.student.id")'),
$.characters- а точка тут нужна?