^ "SELECT b0_.id AS id_0, b0_.content_type AS content_type_1, b0_.status AS status_2, b0_.created_at AS created_at_3, b0_.modified_at AS modified_at_4, b0_.published_at AS published_at_5, b0_.depublished_at AS depublished_at_6, LENGTH(b1_.value) AS sclr_7, b0_.author_id AS author_id_8 FROM bolt_content b0_ INNER JOIN bolt_field b2_ ON b0_.id = b2_.content_id AND b2_.type IN ('generic', 'select', 'text', 'embed', 'image', 'hidden', 'number', 'html', 'data', 'collection', 'markdown', 'file', 'set', 'templateselect', 'date', 'filelist', 'checkbox', 'block', 'slug', 'imagelist', 'email', 'textarea', 'article', 'seo', 'redactor') INNER JOIN bolt_field_translation b1_ ON b2_.id = b1_.translatable_id WHERE b0_.status = ? AND b0_.content_type = ? AND b2_.name IN ('slug', 'article') AND JSON_EXTRACT(b1_.value, '$[0]') IN ('kafka', 'fundamentals', 'for', 'java', 'developers', 'kafka', 'kafka fundamentals', 'kafka fundamentals for', 'kafka fundamentals for java', 'kafka fundamentals for java developers', 'fundamentals', 'fundamentals for', 'fundamentals for java', 'fundamentals for java developers', 'for', 'for java', 'for java developers', 'java', 'java developers', 'developers', 'kafka-fundamentals-for-java-developers') ORDER BY sclr_7 DESC, b0_.id DESC LIMIT 1"