=== Testing Top Casinos Collection === Language: en Language Key: en --- Query Test --- SQL Query: select * from `posts` where `active` = ? and json_contains(`languages`, ?) and (JSON_EXTRACT(multi_language_order, '$.top_casinos_en') IS NOT NULL or JSON_EXTRACT(multi_language_order, '$.top_casinos_global') IS NOT NULL) Bindings: [true,"\"en\""] Count: 4 --- Results --- [0] Post ID: 768 Title: Slotty Slots Casino Active: Yes Languages: ["en","de"] Casino Type: ["crypto_sportsbook"] Multi Language Order: {"en":2,"top_casinos_en":3,"mobile_top_en":5,"top3_en":2,"de":2,"mobile_top_de":3,"top_casinos_de":11,"global":5} top_casinos_en: 3 top_casinos_global: NULL [1] Post ID: 769 Title: WatchMySpin Casino Active: Yes Languages: ["en"] Casino Type: ["crypto_casino","crypto_sportsbook"] Multi Language Order: {"en":3,"top_casinos_en":4,"mobile_top_en":3,"top3_en":1,"global":6} top_casinos_en: 4 top_casinos_global: NULL [2] Post ID: 770 Title: Hot Streak Casino Active: Yes Languages: ["en","de"] Casino Type: ["crypto_sportsbook"] Multi Language Order: {"en":4,"top_casinos_en":5,"mobile_top_en":2,"top3_en":3,"de":4,"mobile_top_de":5,"top_casinos_de":12,"global":7} top_casinos_en: 5 top_casinos_global: NULL [3] Post ID: 771 Title: Slotnite Casino Active: Yes Languages: ["en"] Casino Type: ["crypto_sportsbook"] Multi Language Order: {"en":5,"top_casinos_en":6,"mobile_top_en":6,"top3_en":4,"global":8} top_casinos_en: 6 top_casinos_global: NULL --- Posts with top_casinos ordering (any language) --- Posts with top_casinos ordering: 73 Post ID: 383 - AzurSlot Casino Languages: ["de","at"] top_casinos_at: 2 Post ID: 384 - CorgiBet Casino Languages: ["de","at"] top_casinos_at: 3 Post ID: 385 - Blaze Spins Casino Languages: ["de","at"] top_casinos_at: 4 Post ID: 386 - Rich Royal Casino Languages: ["de","at"] top_casinos_at: 5 Post ID: 387 - MaxCasino Languages: ["de","at"] top_casinos_at: 6 Post ID: 388 - FamBet Casino Languages: ["de","at"] top_casinos_at: 7 Post ID: 389 - Win Rolla Casino Languages: ["de","at"] top_casinos_at: 8 Post ID: 390 - LyraBet Casino Languages: ["de","at"] top_casinos_at: 9 Post ID: 391 - WishWin Casino Languages: ["de","at"] top_casinos_at: 10 Post ID: 519 - Spinit Casino Languages: ["de"] top_casinos_de: 2 Post ID: 593 - Betinia Casino Languages: ["no"] top_casinos_no: 5 Post ID: 594 - Lord Ping Casino Languages: ["no"] top_casinos_no: 6 Post ID: 595 - NeonVegas Casino Languages: ["no"] top_casinos_no: 2 Post ID: 596 - MegaRush Casino Languages: ["no"] top_casinos_no: 7 Post ID: 597 - Play Jango Casino Languages: ["no"] top_casinos_no: 8 Post ID: 598 - Betiton Casino Languages: ["no"] top_casinos_no: 9 Post ID: 599 - Swift Casino Languages: ["no"] top_casinos_no: 1 Post ID: 600 - Spin Shake Casino Languages: ["no"] top_casinos_no: 10 Post ID: 604 - Slotzo Casino Languages: ["no"] top_casinos_no: 4 Post ID: 768 - Slotty Slots Casino Languages: ["en","de"] top_casinos_en: 3 top_casinos_de: 11 Post ID: 769 - WatchMySpin Casino Languages: ["en"] top_casinos_en: 4 Post ID: 770 - Hot Streak Casino Languages: ["en","de"] top_casinos_en: 5 top_casinos_de: 12 Post ID: 771 - Slotnite Casino Languages: ["en"] top_casinos_en: 6 Post ID: 780 - Cozino Casino Languages: ["en","de"] top_casinos_de: 13 Post ID: 781 - Mega Reel Casino Languages: ["en","de"] top_casinos_de: 14 Post ID: 783 - Clover Casino Languages: ["en","de"] top_casinos_de: 15 Post ID: 785 - Casimpo Casino Languages: ["en","de"] top_casinos_de: 16 Post ID: 788 - Big Thunder Slots Casino Languages: ["en","de"] top_casinos_de: 7 Post ID: 789 - Amazon Slots Casino Languages: ["en","de"] top_casinos_de: 8 Post ID: 790 - Aladdin Slots Casino Languages: ["en","de"] top_casinos_de: 18 Post ID: 792 - LuckyLouis Casino Languages: ["en","de"] top_casinos_de: 19 Post ID: 793 - Fairground Slots Casino Languages: ["en","de"] top_casinos_de: 17 Post ID: 796 - Cop Slots Casino Languages: ["en","de"] top_casinos_de: 9 Post ID: 801 - VoodooDreams Casino Languages: ["en","de"] top_casinos_de: 10 Post ID: 805 - Swanky Bingo Languages: ["en","de"] top_casinos_de: 20 Post ID: 806 - BoyleSports Casino Languages: ["en","de"] top_casinos_de: 21 Post ID: 812 - Diamond7 Casino Languages: ["en","de"] top_casinos_de: 22 Post ID: 813 - PlayFrank Casino Languages: ["en","de"] top_casinos_de: 23 Post ID: 814 - Hello Casino Languages: ["en","de"] top_casinos_de: 24 Post ID: 816 - PrimeScratchCards Languages: ["en","de"] top_casinos_de: 25 Post ID: 817 - Mr Mega Casino Languages: ["en","de"] top_casinos_de: 26 Post ID: 818 - 21 Prive Casino Languages: ["en","de"] top_casinos_de: 27 Post ID: 824 - Conquer Casino Languages: ["en","de"] top_casinos_de: 28 Post ID: 826 - Videoslots Casino Languages: ["en","de"] top_casinos_de: 29 Post ID: 829 - 10Bet Casino Languages: ["en","de"] top_casinos_de: 30 Post ID: 830 - Genting Casino Languages: ["en","de"] top_casinos_de: 31 Post ID: 832 - Gamebookers Languages: ["en","de"] top_casinos_de: 32 Post ID: 834 - Balmy Bingo Languages: ["en","de"] top_casinos_de: 33 Post ID: 835 - Hyper Slots Languages: ["en","de"] top_casinos_de: 34 Post ID: 840 - Mainstage Bingo Languages: ["en","de"] top_casinos_de: 35 Post ID: 842 - Bingo Storm Languages: ["en","de"] top_casinos_de: 36 Post ID: 844 - Butterfly Bingo Languages: ["en","de"] top_casinos_de: 37 Post ID: 848 - Double Bubble Bingo Languages: ["en","de"] top_casinos_de: 38 Post ID: 849 - Rainbow Riches Casino Languages: ["en","de"] top_casinos_de: 39 Post ID: 850 - Slots Racer Languages: ["en","de"] top_casinos_de: 40 Post ID: 851 - Umbingo Languages: ["en","de"] top_casinos_de: 41 Post ID: 853 - NoDeposit Slots Languages: ["en","de"] top_casinos_de: 42 Post ID: 854 - Freebet Casino Languages: ["en","de"] top_casinos_de: 43 Post ID: 857 - Ok Bingo Languages: ["en","de"] top_casinos_de: 44 Post ID: 858 - Wild West Wins Languages: ["en","de"] top_casinos_de: 45 Post ID: 860 - Daily Record Bingo Languages: ["en","de"] top_casinos_de: 46 Post ID: 862 - Target Slots Languages: ["en","de"] top_casinos_de: 47 Post ID: 864 - Monopoly Casino Languages: ["en","de"] top_casinos_de: 48 Post ID: 865 - Safari Bingo Casino Languages: ["en","de"] top_casinos_de: 49 Post ID: 870 - Sailor Bingo Languages: ["en","de"] top_casinos_de: 50 Post ID: 871 - Betmorph Languages: ["en","de"] top_casinos_de: 50 Post ID: 874 - Matchup Casino Languages: ["en","de"] top_casinos_de: 50 Post ID: 877 - Mango Casino Languages: ["en","de"] top_casinos_de: 50 Post ID: 879 - Chilli Spins Casino Languages: ["en","de"] top_casinos_de: 50 Post ID: 908 - Spinational Casino Languages: ["de"] top_casinos_de: 3 Post ID: 909 - Spinrollz Casino Languages: ["de"] top_casinos_de: 4 Post ID: 910 - GreenLuck Casino Languages: ["de"] top_casinos_de: 5 Post ID: 911 - Cazimbo Casino Languages: ["de"] top_casinos_de: 6 --- Recommendation --- You have posts with top_casinos ordering, but they're set for different languages. For English (en), you need to set 'top_casinos_en' or 'top_casinos_global' in admin. Or change the language cookie to match the language of your posts. === Test Complete ===