AS video_article_id, video_article.video_category_id AS video_article_video_category_id, video_article_translate.name AS video_article_translate_name, video_article_translate.preview AS video_article_translate_preview, video_article_translate.image_url AS video_article_translate_image_url, video_article_translate.video_url AS video_article_translate_video_url
FROM video_article JOIN video_article_translate ON video_article.id = video_article_translate.video_article_id
WHERE video_article_translate.lang = :lang_1 AND lower(video_article_translate.name) LIKE lower(:name_1) ORDER BY video_article.sort_index
LIMIT :param_1 OFFSET :param_2
А в чем проблема ? Выложите таблицы и запрос онлайн на SQLize.online
Обсуждают сегодня