Illuminate\Database\QueryException: 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 '-10 ) select p.id, p.title,p.meta_title, p.meta_desc,...' at line 29 (SQL: with vt_t as ( select tr.term_order,tr.object_id from term_taxonomy tt join terms t on t.term_id=tt.term_id and tt.taxonomy in ('category') and t.slug=news join term_relationships tr on tr.term_taxonomy_id=tt.term_taxonomy_id order by tr.term_order desc,tr.object_id ) , vt_p as( SELECT p.id, p.title,p.meta_title, p.meta_desc, p.slug, p.status, p.created_at, p.updated_at, p.kontributor_id, p.editor_id, p.reporter_id, p.feature_id, p.sumber, p.caption as feature_image_caption, p.comment_status, p.created_by, p.updated_by, p.guid, p.type, p.headline, p.embed, p.page_view, g.url as feature_image, g.path as path_image, g.filename as filename_image, g.save_original as original_image FROM posts p left JOIN gallery g ON g.id = p.feature_id WHERE 1 = 1 and p.status='publish' and p.id in (select vt_t.object_id from vt_t) and p.created_at <= NOW() order by created_at desc limit 5 offset -10 ) select p.id, p.title,p.meta_title, p.meta_desc, p.slug, p.status, p.created_at, p.updated_at, p.kontributor_id, p.editor_id, p.reporter_id, p.feature_id, p.sumber, p.feature_image_caption, p.comment_status, p.created_by, p.updated_by, p.guid, p.type, p.headline, p.embed, p.page_view ,p.feature_image ,p.path_image ,p.filename_image ,p.original_image ,tr.object_id , CONCAT('[', GROUP_CONCAT(IF( tt.taxonomy = 'tag', JSON_OBJECT('name', t.name, 'slug', t.slug), null) ORDER BY t.name asc SEPARATOR ','), ']') as list_tag, CONCAT('[', GROUP_CONCAT(IF( tt.taxonomy = 'tagLong', JSON_OBJECT('id', t.term_id, 'name', t.name, 'slug', t.slug), null) ORDER BY t.name, tr.term_order asc SEPARATOR ','), ']') as list_meta_tagLong ,GROUP_CONCAT( IF( tt.taxonomy = 'tag', t.name, NULL) ORDER BY t.name desc SEPARATOR ', ' limit 100) as meta_tag ,GROUP_CONCAT( IF( tt.taxonomy = 'tag', t.slug, NULL) ORDER BY t.name desc SEPARATOR ', ' limit 100) as meta_tag_slug ,GROUP_CONCAT( IF( tt.taxonomy = 'tag', t.term_id, NULL) ORDER BY t.name ASC SEPARATOR ',' limit 100) as meta_tag_id ,GROUP_CONCAT( IF( tt.taxonomy = 'topik', t.name, NULL) ORDER BY t.name desc SEPARATOR ', ' limit 1) as meta_topik ,GROUP_CONCAT( IF( tt.taxonomy = 'topik', t.slug, NULL) ORDER BY t.name desc SEPARATOR ', ' limit 1) as meta_topik_slug ,GROUP_CONCAT( IF( tt.taxonomy = 'topik', t.term_id, NULL) SEPARATOR ',') as meta_topik_id ,GROUP_CONCAT( IF( tt.taxonomy = 'category', t.name, NULL) ORDER BY tr.term_order asc SEPARATOR ',' limit 5) as kanal ,GROUP_CONCAT( IF( tt.taxonomy = 'category', t.name, NULL) ORDER BY tr.term_order desc SEPARATOR ', ' limit 1) as rubik ,GROUP_CONCAT( IF( tt.taxonomy = 'category', t.slug, NULL) ORDER BY tr.term_order desc SEPARATOR ', ' limit 1) as rubik_slug ,GROUP_CONCAT( IF( tt.taxonomy = 'category', t.term_id, NULL) ORDER BY tr.term_order desc SEPARATOR ', ' limit 1) as rubik_id ,GROUP_CONCAT( IF( tt.taxonomy = 'category', t.term_id, NULL) ORDER BY tr.term_order asc SEPARATOR ',') as category_id from term_taxonomy tt join terms t on t.term_id=tt.term_id and tt.taxonomy in ('category','topik','tag') join term_relationships tr on tr.term_taxonomy_id=tt.term_taxonomy_id and tr.object_id in(select vt_p.id from vt_p) join vt_p p on p.id = tr.object_id group by object_id order by p.created_at desc ) in file /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 712 #0 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback() #1 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Database/Connection.php(376): Illuminate\Database\Connection->run() #2 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php(442): Illuminate\Database\Connection->select() #3 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\Database\DatabaseManager->__call() #4 /var/www/html/terasjakarta.id/app/Helpers/helpers.php(1047): Illuminate\Support\Facades\Facade::__callStatic() #5 /var/www/html/terasjakarta.id/app/Http/Controllers/Web/WebIndexController.php(158): index_kanal() #6 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): App\Http\Controllers\Web\WebIndexController->kanal() #7 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction() #8 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Routing/Route.php(262): Illuminate\Routing\ControllerDispatcher->dispatch() #9 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Routing/Route.php(205): Illuminate\Routing\Route->runController() #10 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Routing/Router.php(721): Illuminate\Routing\Route->run() #11 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\Routing\Router->Illuminate\Routing\{closure}() #12 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #13 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Routing\Middleware\SubstituteBindings->handle() #14 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #15 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle() #16 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #17 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\View\Middleware\ShareErrorsFromSession->handle() #18 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #19 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest() #20 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Session\Middleware\StartSession->handle() #21 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #22 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle() #23 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #24 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Cookie\Middleware\EncryptCookies->handle() #25 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #26 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Routing/Router.php(723): Illuminate\Pipeline\Pipeline->then() #27 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Routing/Router.php(698): Illuminate\Routing\Router->runRouteWithinStack() #28 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Routing/Router.php(662): Illuminate\Routing\Router->runRoute() #29 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Routing/Router.php(651): Illuminate\Routing\Router->dispatchToRoute() #30 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(167): Illuminate\Routing\Router->dispatch() #31 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}() #32 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #33 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #34 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle() #35 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #36 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #37 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\TrimStrings->handle() #38 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #39 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle() #40 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #41 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle() #42 /var/www/html/terasjakarta.id/vendor/fruitcake/laravel-cors/src/HandleCors.php(38): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #43 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Fruitcake\Cors\HandleCors->handle() #44 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #45 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\Http\Middleware\TrustProxies->handle() #46 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #47 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(142): Illuminate\Pipeline\Pipeline->then() #48 /var/www/html/terasjakarta.id/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(111): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter() #49 /var/www/html/terasjakarta.id/public/index.php(51): Illuminate\Foundation\Http\Kernel->handle() #50 {main}