=== Debugging EN Language Posts ===

1. All active posts with 'en' in languages:
   Total: 188

   First 10 posts:
   - ID: 667, Title: 21 Casino
     Languages: en
     month_recommendation_en: NULL
     month_recommendation_global: NULL

   - ID: 668, Title: MrRun Casino
     Languages: en
     month_recommendation_en: NULL
     month_recommendation_global: NULL

   - ID: 669, Title: MrBen Casino
     Languages: en, de
     month_recommendation_en: NULL
     month_recommendation_global: NULL

   - ID: 670, Title: Casiku Casino
     Languages: en
     month_recommendation_en: NULL
     month_recommendation_global: NULL

   - ID: 671, Title: Hotwins Casino
     Languages: en, de
     month_recommendation_en: NULL
     month_recommendation_global: NULL

   - ID: 672, Title: Mr Slot
     Languages: en, de
     month_recommendation_en: NULL
     month_recommendation_global: NULL

   - ID: 673, Title: Bzeebet Casino
     Languages: en, de
     month_recommendation_en: NULL
     month_recommendation_global: NULL

   - ID: 674, Title: Lottoland Casino
     Languages: en, de
     month_recommendation_en: NULL
     month_recommendation_global: NULL

   - ID: 676, Title: Casimba Casino
     Languages: en
     month_recommendation_en: NULL
     month_recommendation_global: NULL

   - ID: 677, Title: Jackpot.com Casino
     Languages: en, de
     month_recommendation_en: NULL
     month_recommendation_global: NULL

2. Posts with month_recommendation_en set:
   Total: 0

3. Posts with month_recommendation_global set:
   Total: 0

4. Posts with 'en' in languages AND month_recommendation order:
   Total: 0

5. Posts with 'en' in languages but ONLY month_recommendation_global (not _en):
   Total: 0

6. Testing exact controller query:
   SQL: select * from `posts` where `active` = ? and json_contains(`languages`, ?) and (JSON_EXTRACT(multi_language_order, '$.month_recommendation_en') IS NOT NULL or JSON_EXTRACT(multi_language_order, '$.month_recommendation_global') IS NOT NULL) order by COALESCE(
        CAST(JSON_UNQUOTE(JSON_EXTRACT(multi_language_order, '$.month_recommendation_en')) AS UNSIGNED),
        CAST(JSON_UNQUOTE(JSON_EXTRACT(multi_language_order, '$.month_recommendation_global')) AS UNSIGNED),
        999999
    ) ASC limit 5
   Bindings: [true,"\"en\""]
   Count: 0

=== Debug Complete ===