Internal Server Error
ErrorException
Undefined array key "x"
resources/views/themes/adam/components/socials.blade.php :30
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php :123
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php :124
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php :57
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php :76
vendor/laravel/framework/src/Illuminate/View/View.php :208
vendor/laravel/framework/src/Illuminate/View/View.php :191
vendor/laravel/framework/src/Illuminate/View/View.php :160
resources/views/themes/adam/pages/post.blade.php :355
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php :123
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php :124
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php :57
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php :76
vendor/laravel/framework/src/Illuminate/View/View.php :208
vendor/laravel/framework/src/Illuminate/View/View.php :191
vendor/laravel/framework/src/Illuminate/View/View.php :160
vendor/laravel/framework/src/Illuminate/Http/Response.php :78
vendor/laravel/framework/src/Illuminate/Http/Response.php :34
vendor/laravel/framework/src/Illuminate/Routing/Router.php :939
vendor/laravel/framework/src/Illuminate/Routing/Router.php :906
vendor/laravel/framework/src/Illuminate/Routing/Router.php :821
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :180
vendor/laravel/jetstream/src/Http/Middleware/ShareInertiaData.php :69
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :219
vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php :59
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :219
vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php :50
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :219
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php :87
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :219
vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php :48
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :219
vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php :120
vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php :63
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :219
vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php :36
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :219
vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php :74
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :219
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :137
vendor/laravel/framework/src/Illuminate/Routing/Router.php :821
vendor/laravel/framework/src/Illuminate/Routing/Router.php :800
vendor/laravel/framework/src/Illuminate/Routing/Router.php :764
vendor/laravel/framework/src/Illuminate/Routing/Router.php :753
vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php :200
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :180
vendor/barryvdh/laravel-debugbar/src/Middleware/InjectDebugbar.php :59
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :219
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php :21
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php :31
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :219
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php :21
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php :51
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :219
vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePostSize.php :27
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :219
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php :109
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :219
vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php :48
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :219
vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php :58
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :219
vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/InvokeDeferredCallbacks.php :22
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :219
vendor/laravel/framework/src/Illuminate/Http/Middleware/ValidatePathEncoding.php :26
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :219
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php :137
vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php :175
vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php :144
/home/bshra/public_html/index.php :50
Request
GET /arabic/tHajhqGg
Headers
x-https
1
host
mcsr.net
cookie
XSRF-TOKEN=eyJpdiI6Ikd0bE50TW9rZXdQelRsSGwzZEtOT2c9PSIsInZhbHVlIjoieUFDR09RN0hZaVd2b2dpN21HODJoZGhxM214RTBGQU5kWlFuTXVoNHdxOGx6ZVd0cDF3bjJLeXBFL21va3pBM3hiZ2V5Q1lKaE81VnFXYm5kamx3U1llaTJxRHo1ZVljeFc1NmorMHZTSm5IblBjdjhTQkhGL05icjFzakcrK0YiLCJtYWMiOiI2ZGU2NDYwODhjODk5NmI4MmRlNDEyY2MxNTc4Mzg4OGVhMTNmMjQzNjhhZGQwZjIxNDE2ZTBhMWY1NzU4ZDdhIiwidGFnIjoiIn0%3D; annabaa-app-session=eyJpdiI6IlJsZ1NjNjIvNWV2WGNlcTl2SDRyRnc9PSIsInZhbHVlIjoiblJoejVuOUt4ZGM5TW1PTUJKK3VWS1krS1dTTlN0Nkl5amtMNlFDcGE4ZUU3enRyR0FvQWVDNHBnNWUyZHNGNnFBT2J4SUhpYUpCeGdKdWFUUUdWdit0R0kybUZDODBTckwwbG9zYWM5UjdTTHlPSlViY2w1alorcjVLODAyVnMiLCJtYWMiOiI2YjQ0MGQ1MmRjZDI3Mjg2YWI0MDZhMzFiOWYxYzFhYTNkNzY1NGFkMjkyMTdlZWQxMTJiNTZjNzdhYzQ4OTk1IiwidGFnIjoiIn0%3D
referer
https://mcsr.net/locals/943
accept-encoding
gzip, br, zstd, deflate
user-agent
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
accept
*/*
Body
No body data
Application
Routing
controller
Closure
middleware
web
Routing Parameters
{
    "identifier": "tHajhqGg"
}
Database Queries
mysql
select `name` from `languages`
mysql
select * from `languages` where `name` = 'arabic' limit 1
mysql
select * from `apps` where `url` = 'mcsr.net' limit 1
mysql
select `languages`.*, `app_language`.`app_id` as `pivot_app_id`, `app_language`.`lang_id` as `pivot_lang_id`, `app_language`.`id` as `pivot_id`, `app_language`.`langName` as `pivot_langName`, `app_language`.`url` as `pivot_url`, `app_language`.`default` as `pivot_default`, `app_language`.`social` as `pivot_social`, `app_language`.`statistics` as `pivot_statistics`, `app_language`.`active` as `pivot_active`, `app_language`.`about` as `pivot_about`, `app_language`.`contact` as `pivot_contact`, `app_language`.`logo` as `pivot_logo`, `app_language`.`fotterLogo` as `pivot_fotterLogo`, `app_language`.`description` as `pivot_description`, `app_language`.`counter` as `pivot_counter` from `languages` inner join `app_language` on `languages`.`id` = `app_language`.`lang_id` where `app_language`.`app_id` in (5) and `name` = 'arabic'
mysql
select * from `themes` where `themes`.`id` in (4)
mysql
select `languages`.*, `app_language`.`app_id` as `pivot_app_id`, `app_language`.`lang_id` as `pivot_lang_id`, `app_language`.`id` as `pivot_id`, `app_language`.`langName` as `pivot_langName`, `app_language`.`url` as `pivot_url`, `app_language`.`default` as `pivot_default`, `app_language`.`social` as `pivot_social`, `app_language`.`statistics` as `pivot_statistics`, `app_language`.`active` as `pivot_active`, `app_language`.`about` as `pivot_about`, `app_language`.`contact` as `pivot_contact`, `app_language`.`logo` as `pivot_logo`, `app_language`.`fotterLogo` as `pivot_fotterLogo`, `app_language`.`description` as `pivot_description`, `app_language`.`counter` as `pivot_counter` from `languages` inner join `app_language` on `languages`.`id` = `app_language`.`lang_id` where `app_language`.`app_id` = 5
mysql
select `name` from `languages`
mysql
select * from `languages` where `name` = 'arabic' limit 1
mysql
select * from `apps` where `url` = 'mcsr.net' limit 1
mysql
select `languages`.*, `app_language`.`app_id` as `pivot_app_id`, `app_language`.`lang_id` as `pivot_lang_id`, `app_language`.`id` as `pivot_id`, `app_language`.`langName` as `pivot_langName`, `app_language`.`url` as `pivot_url`, `app_language`.`default` as `pivot_default`, `app_language`.`social` as `pivot_social`, `app_language`.`statistics` as `pivot_statistics`, `app_language`.`active` as `pivot_active`, `app_language`.`about` as `pivot_about`, `app_language`.`contact` as `pivot_contact`, `app_language`.`logo` as `pivot_logo`, `app_language`.`fotterLogo` as `pivot_fotterLogo`, `app_language`.`description` as `pivot_description`, `app_language`.`counter` as `pivot_counter` from `languages` inner join `app_language` on `languages`.`id` = `app_language`.`lang_id` where `app_language`.`app_id` in (5) and `name` = 'arabic'
mysql
select * from `themes` where `themes`.`id` in (4)
mysql
select `languages`.*, `app_language`.`app_id` as `pivot_app_id`, `app_language`.`lang_id` as `pivot_lang_id`, `app_language`.`id` as `pivot_id`, `app_language`.`langName` as `pivot_langName`, `app_language`.`url` as `pivot_url`, `app_language`.`default` as `pivot_default`, `app_language`.`social` as `pivot_social`, `app_language`.`statistics` as `pivot_statistics`, `app_language`.`active` as `pivot_active`, `app_language`.`about` as `pivot_about`, `app_language`.`contact` as `pivot_contact`, `app_language`.`logo` as `pivot_logo`, `app_language`.`fotterLogo` as `pivot_fotterLogo`, `app_language`.`description` as `pivot_description`, `app_language`.`counter` as `pivot_counter` from `languages` inner join `app_language` on `languages`.`id` = `app_language`.`lang_id` where `app_language`.`app_id` = 5
mysql
select `name` from `languages`
mysql
select * from `languages` where `name` = 'arabic' limit 1
mysql
select * from `apps` where `url` = 'mcsr.net' limit 1
mysql
select `languages`.*, `app_language`.`app_id` as `pivot_app_id`, `app_language`.`lang_id` as `pivot_lang_id`, `app_language`.`id` as `pivot_id`, `app_language`.`langName` as `pivot_langName`, `app_language`.`url` as `pivot_url`, `app_language`.`default` as `pivot_default`, `app_language`.`social` as `pivot_social`, `app_language`.`statistics` as `pivot_statistics`, `app_language`.`active` as `pivot_active`, `app_language`.`about` as `pivot_about`, `app_language`.`contact` as `pivot_contact`, `app_language`.`logo` as `pivot_logo`, `app_language`.`fotterLogo` as `pivot_fotterLogo`, `app_language`.`description` as `pivot_description`, `app_language`.`counter` as `pivot_counter` from `languages` inner join `app_language` on `languages`.`id` = `app_language`.`lang_id` where `app_language`.`app_id` in (5) and `name` = 'arabic'
mysql
select * from `themes` where `themes`.`id` in (4)
mysql
select `languages`.*, `app_language`.`app_id` as `pivot_app_id`, `app_language`.`lang_id` as `pivot_lang_id`, `app_language`.`id` as `pivot_id`, `app_language`.`langName` as `pivot_langName`, `app_language`.`url` as `pivot_url`, `app_language`.`default` as `pivot_default`, `app_language`.`social` as `pivot_social`, `app_language`.`statistics` as `pivot_statistics`, `app_language`.`active` as `pivot_active`, `app_language`.`about` as `pivot_about`, `app_language`.`contact` as `pivot_contact`, `app_language`.`logo` as `pivot_logo`, `app_language`.`fotterLogo` as `pivot_fotterLogo`, `app_language`.`description` as `pivot_description`, `app_language`.`counter` as `pivot_counter` from `languages` inner join `app_language` on `languages`.`id` = `app_language`.`lang_id` where `app_language`.`app_id` = 5
mysql
select * from `sessions` where `id` = 'r6TvK7GI3Txa2MOmtWBoKe2hHn3pkJbv4qph2R7f' limit 1
mysql
select * from `posts` where `slug` = 'tHajhqGg' and `deleted` is null and `active` = 1 and `app_id` = 5 limit 1
mysql
select `tags`.*, `post_tag`.`post_id` as `pivot_post_id`, `post_tag`.`tag_id` as `pivot_tag_id` from `tags` inner join `post_tag` on `tags`.`id` = `post_tag`.`tag_id` where `post_tag`.`post_id` in (276371)
mysql
select * from `categories` where `categories`.`id` in (103)
mysql
select `users`.*, `post_author`.`post_id` as `pivot_post_id`, `post_author`.`author_id` as `pivot_author_id`, `post_author`.`text` as `pivot_text`, `post_author`.`type` as `pivot_type` from `users` inner join `post_author` on `users`.`id` = `post_author`.`author_id` where `post_author`.`post_id` in (276371)
mysql
select `roles`.*, `model_has_roles`.`model_id` as `pivot_model_id`, `model_has_roles`.`role_id` as `pivot_role_id`, `model_has_roles`.`model_type` as `pivot_model_type` from `roles` inner join `model_has_roles` on `roles`.`id` = `model_has_roles`.`role_id` where `model_has_roles`.`model_id` in (1484) and `model_has_roles`.`model_type` = 'App\Models\User'
mysql
select `attachments`.*, `post_attachment`.`post_id` as `pivot_post_id`, `post_attachment`.`attachment_id` as `pivot_attachment_id`, `post_attachment`.`mainpic` as `pivot_mainpic`, `post_attachment`.`text` as `pivot_text`, `post_attachment`.`sequence` as `pivot_sequence` from `attachments` inner join `post_attachment` on `attachments`.`id` = `post_attachment`.`attachment_id` where `post_attachment`.`post_id` in (276371)
mysql
select * from `extra_posts` where `extra_posts`.`post_id` in (276371)
mysql
update `posts` set `counter` = 1089, `posts`.`updated_at` = '2025-11-22 17:53:04' where `id` = 276371
mysql
select `id`, `title`, `category_id`, `schedule`, `description`, `image`, `slug` from `posts` where (`schedule` < 1763833984 and `deleted` is null and `active` = 1 and `mainpost` > 0 and `app_id` = 5 and `lang_id` = 1) order by `mainpost` desc, `id` desc limit 7
mysql
select `id`, `src`, `name` from `categories` where `categories`.`id` in (102, 103, 104, 105)
mysql
select * from `cache` where `key` in ('annabaa-app-cache-expedite_mcsr.net')
mysql
select `post_id`, `title`, `category_id` from `posts` where `app_id` = 5 and `deleted` is null and `expedite` = 1 and `active` = 1 and `schedule` between 1763812384 and 1763833984 order by `schedule` desc
mysql
delete from `cache` where `key` in ('annabaa-app-cache-expedite_mcsr.net', 'annabaa-app-cache-illuminate:cache:flexible:created:expedite_mcsr.net')
mysql
select `id`, `slug`, `title`, `category_id`, `schedule`, `description`, `image` from `posts` where (`schedule` < 1763833984 and `deleted` is null and `active` = 1 and `app_id` = 5 and `schedule` > 1763229184) order by RAND() limit 6
mysql
select `id`, `src`, `name` from `categories` where `categories`.`id` in (102, 103)
mysql
select * from `cache` where `key` in ('annabaa-app-cache-authorpostsmcsr.net_276371')
mysql
delete from `cache` where `key` in ('annabaa-app-cache-authorpostsmcsr.net_276371', 'annabaa-app-cache-illuminate:cache:flexible:created:authorpostsmcsr.net_276371') and `expiration` <= 1763833984
mysql
select `id`, `slug`, `image`, `title`, `category_id`, `schedule` from `posts` where `app_id` = 5 and exists (select * from `users` inner join `post_author` on `users`.`id` = `post_author`.`author_id` where `posts`.`id` = `post_author`.`post_id` and `name` in ('د. تمارا كاظم الأسدي')) and `active` = 1 and `deleted` is null and `schedule` < 1763833984 and `id` != 276371 order by `id` desc limit 6
mysql
select `id`, `src`, `name` from `categories` where `categories`.`id` in (104)
mysql
insert into `cache` (`expiration`, `key`, `value`) values (1763835784, 'annabaa-app-cache-authorpostsmcsr.net_276371', 'O:39:"Illuminate\Database\Eloquent\Collection":2:{s:8:"*items";a:1:{i:0;O:15:"App\Models\Post":33:{s:13:"*connection";s:5:"mysql";s:8:"*table";s:5:"posts";s:13:"*primaryKey";s:2:"id";s:10:"*keyType";s:3:"int";s:12:"incrementing";b:1;s:7:"*with";a:0:{}s:12:"*withCount";a:0:{}s:19:"preventsLazyLoading";b:0;s:10:"*perPage";i:15;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;s:28:"*escapeWhenCastingToString";b:0;s:13:"*attributes";a:6:{s:2:"id";i:276302;s:4:"slug";s:8:"uh5LdtAJ";s:5:"image";s:33:"/filestorage/86/663d077f3d82a.jpg";s:5:"title";s:115:"طوفان الأقصى ما بين محاولة تغيير الوضع القائم والافاق المتوقعة";s:11:"category_id";i:104;s:8:"schedule";i:1715275656;}s:11:"*original";a:6:{s:2:"id";i:276302;s:4:"slug";s:8:"uh5LdtAJ";s:5:"image";s:33:"/filestorage/86/663d077f3d82a.jpg";s:5:"title";s:115:"طوفان الأقصى ما بين محاولة تغيير الوضع القائم والافاق المتوقعة";s:11:"category_id";i:104;s:8:"schedule";i:1715275656;}s:10:"*changes";a:0:{}s:11:"*previous";a:0:{}s:8:"*casts";a:0:{}s:17:"*classCastCache";a:0:{}s:21:"*attributeCastCache";a:0:{}s:13:"*dateFormat";N;s:10:"*appends";a:0:{}s:19:"*dispatchesEvents";a:0:{}s:14:"*observables";a:0:{}s:12:"*relations";a:1:{s:8:"category";O:19:"App\Models\Category":33:{s:13:"*connection";s:5:"mysql";s:8:"*table";s:10:"categories";s:13:"*primaryKey";s:2:"id";s:10:"*keyType";s:3:"int";s:12:"incrementing";b:1;s:7:"*with";a:0:{}s:12:"*withCount";a:0:{}s:19:"preventsLazyLoading";b:0;s:10:"*perPage";i:15;s:6:"exists";b:1;s:18:"wasRecentlyCreated";b:0;s:28:"*escapeWhenCastingToString";b:0;s:13:"*attributes";a:3:{s:2:"id";i:104;s:3:"src";s:8:"regional";s:4:"name";s:25:"قضايا اقليمية";}s:11:"*original";a:3:{s:2:"id";i:104;s:3:"src";s:8:"regional";s:4:"name";s:25:"قضايا اقليمية";}s:10:"*changes";a:0:{}s:11:"*previous";a:0:{}s:8:"*casts";a:0:{}s:17:"*classCastCache";a:0:{}s:21:"*attributeCastCache";a:0:{}s:13:"*dateFormat";N;s:10:"*appends";a:0:{}s:19:"*dispatchesEvents";a:0:{}s:14:"*observables";a:0:{}s:12:"*relations";a:0:{}s:10:"*touches";a:0:{}s:27:"*relationAutoloadCallback";N;s:26:"*relationAutoloadContext";N;s:10:"timestamps";b:0;s:13:"usesUniqueIds";b:0;s:9:"*hidden";a:0:{}s:10:"*visible";a:0:{}s:11:"*fillable";a:0:{}s:10:"*guarded";a:0:{}}}s:10:"*touches";a:0:{}s:27:"*relationAutoloadCallback";N;s:26:"*relationAutoloadContext";N;s:10:"timestamps";b:1;s:13:"usesUniqueIds";b:0;s:9:"*hidden";a:0:{}s:10:"*visible";a:0:{}s:11:"*fillable";a:0:{}s:10:"*guarded";a:0:{}}}s:28:"*escapeWhenCastingToString";b:0;}') on duplicate key update `expiration` = values(`expiration`), `key` = values(`key`), `value` = values(`value`)
mysql
select `id`, `slug`, `title`, `category_id`, `schedule`, `description`, `image` from `posts` where (`schedule` < 1763833984 and `deleted` is null and `active` = 1 and `app_id` = 5) order by `id` desc limit 6
mysql
select `id`, `src`, `name` from `categories` where `categories`.`id` in (102, 103, 105)
mysql
select * from `cache` where `key` in ('annabaa-app-cache-Promo_1')
mysql
select `categories`.*, (select count(*) from `posts` where `categories`.`id` = `posts`.`category_id`) as `posts_count` from `categories` where (`active` = 1 and `deleted` is null) and `nav_ord` > 0 and `app_id` = 5 order by `sequence` asc
mysql
select * from `categories` where `deleted` = 0 and `categories`.`parent_id` in (101, 102, 103, 104, 105, 106, 108)
mysql
select * from `cache` where `key` in ('annabaa-app-cache-mostread_mcsr.net_1_')
mysql
select * from `cache` where `key` in ('annabaa-app-cache-post_comments_tHajhqGg_mcsr.net')
mysql
delete from `cache` where `key` in ('annabaa-app-cache-post_comments_tHajhqGg_mcsr.net', 'annabaa-app-cache-illuminate:cache:flexible:created:post_comments_tHajhqGg_mcsr.net') and `expiration` <= 1763833984
mysql
select * from `comments` where `comments`.`post_id` = 276371 and `comments`.`post_id` is not null and `status` = 1
mysql
insert into `cache` (`expiration`, `key`, `value`) values (1763835784, 'annabaa-app-cache-post_comments_tHajhqGg_mcsr.net', 'O:39:"Illuminate\Database\Eloquent\Collection":2:{s:8:"*items";a:0:{}s:28:"*escapeWhenCastingToString";b:0;}') on duplicate key update `expiration` = values(`expiration`), `key` = values(`key`), `value` = values(`value`)
mysql
select `attachments`.*, `user_attachment`.`user_id` as `pivot_user_id`, `user_attachment`.`attachment_id` as `pivot_attachment_id`, `user_attachment`.`text` as `pivot_text`, `user_attachment`.`sequence` as `pivot_sequence`, `user_attachment`.`mainpic` as `pivot_mainpic`, `user_attachment`.`app_id` as `pivot_app_id`, `user_attachment`.`lang_id` as `pivot_lang_id` from `attachments` inner join `user_attachment` on `attachments`.`id` = `user_attachment`.`attachment_id` where `user_attachment`.`user_id` = 1484
mysql
select * from `tags` where exists (select * from `posts` inner join `post_tag` on `posts`.`id` = `post_tag`.`post_id` where `tags`.`id` = `post_tag`.`tag_id` and `posts`.`app_id` = 5) order by RAND() limit 10