Web
            Analytics
Farense
35% Farense 1 3
  • Mié 17 Feb 22:45finalizado2
  • 2
Array
(
    [comments_lang] => 
    [date_server] => 2021-04-23 16:16:44
    [numc] => 133
    [comments] => Array
        (
            [0] => Array
                (
                    [id] => 31083278
                    [user_id] => 2942443
                    [user_name] => alejandro_97_256
                    [comment] => No se me escapara no? ,  seria ya la ecatombe si gana el farense , teniendo 1x y con uno menos el rival , pero del fútbol  no me fio
                    [creation_date] => 2021-02-18 00:06:52
                    [last_update] => 2021-02-18 01:01:43
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_92/2942443/2942443_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                            [0] => Array
                                (
                                    [id] => 31083896
                                    [user_id] => 2942443
                                    [user_name] => alejandro_97_256
                                    [lang] => es
                                    [comment] => 50 euros de bono bienvenida  d e kirolbet  y 964 pavos
                                    [creation_date] => 2021-02-18 01:01:43
                                    [last_update] => 2021-02-18 01:01:43
                                    [comment_id] => 31083278
                                    [votes_up] => 0
                                    [votes_down] => 0
                                    [is_response] => 1
                                    [user_avatar] => //resfu.thumbr.io/avatar_92/2942443/2942443_gallery.jpg?size=80x&rand=
                                )

                            [1] => Array
                                (
                                    [id] => 31083639
                                    [user_id] => 3547338
                                    [user_name] => jesus_104448
                                    [lang] => es
                                    [comment] => Hacías bien no fiandote
                                    [creation_date] => 2021-02-18 00:38:58
                                    [last_update] => 2021-02-18 00:38:58
                                    [comment_id] => 31083278
                                    [votes_up] => 0
                                    [votes_down] => 0
                                    [is_response] => 1
                                    [user_avatar] => //resfu.thumbr.io/avatar_111/3547338/3547338_gallery.jpg?size=80x&rand=
                                )

                            [2] => Array
                                (
                                    [id] => 31083434
                                    [user_id] => 2942443
                                    [user_name] => alejandro_97_256
                                    [lang] => es
                                    [comment] => No me digas local , que me vas hacer sufrir , con uno más,  enserio?
                                    [creation_date] => 2021-02-18 00:24:10
                                    [last_update] => 2021-02-18 00:24:10
                                    [comment_id] => 31083278
                                    [votes_up] => 0
                                    [votes_down] => 0
                                    [is_response] => 1
                                    [user_avatar] => //resfu.thumbr.io/avatar_92/2942443/2942443_gallery.jpg?size=80x&rand=
                                )

                        )

                    [more_responses] => 
                    [total_responses] => 5
                )

            [1] => Array
                (
                    [id] => 31082853
                    [user_id] => 2795214
                    [user_name] => sergio_62500
                    [comment] => Tengo informes ahora remonta visita quien pille pasta que me de algo que esto que digo es un lujo
                    [creation_date] => 2021-02-17 23:34:16
                    [last_update] => 2021-02-18 00:44:36
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_88/2795214/2795214_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                            [0] => Array
                                (
                                    [id] => 31083671
                                    [user_id] => 2795214
                                    [user_name] => sergio_62500
                                    [lang] => es
                                    [comment] => Todo son matemáticas
                                    [creation_date] => 2021-02-18 00:41:11
                                    [last_update] => 2021-02-18 00:41:11
                                    [comment_id] => 31082853
                                    [votes_up] => 0
                                    [votes_down] => 0
                                    [is_response] => 1
                                    [user_avatar] => //resfu.thumbr.io/avatar_88/2795214/2795214_gallery.jpg?size=80x&rand=
                                )

                            [1] => Array
                                (
                                    [id] => 31083661
                                    [user_id] => 2795214
                                    [user_name] => sergio_62500
                                    [lang] => es
                                    [comment] => Quiero ver ese premium
                                    [creation_date] => 2021-02-18 00:40:46
                                    [last_update] => 2021-02-18 00:40:46
                                    [comment_id] => 31082853
                                    [votes_up] => 0
                                    [votes_down] => 0
                                    [is_response] => 1
                                    [user_avatar] => //resfu.thumbr.io/avatar_88/2795214/2795214_gallery.jpg?size=80x&rand=
                                )

                            [2] => Array
                                (
                                    [id] => 31083657
                                    [user_id] => 2795214
                                    [user_name] => sergio_62500
                                    [lang] => es
                                    [comment] => Las cosas serias
                                    [creation_date] => 2021-02-18 00:40:25
                                    [last_update] => 2021-02-18 00:40:25
                                    [comment_id] => 31082853
                                    [votes_up] => 0
                                    [votes_down] => 0
                                    [is_response] => 1
                                    [user_avatar] => //resfu.thumbr.io/avatar_88/2795214/2795214_gallery.jpg?size=80x&rand=
                                )

                        )

                    [more_responses] => 
                    [total_responses] => 19
                )

            [2] => Array
                (
                    [id] => 31083658
                    [user_id] => 3407159
                    [user_name] => luis_jose_56_837
                    [comment] => Joa que equipo malo ese
                    [creation_date] => 2021-02-18 00:40:32
                    [last_update] => 2021-02-18 00:40:32
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_107/3407159/3407159_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [3] => Array
                (
                    [id] => 31083655
                    [user_id] => 3407159
                    [user_name] => luis_jose_56_837
                    [comment] => 
                    [creation_date] => 2021-02-18 00:40:21
                    [last_update] => 2021-02-18 00:40:21
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_107/3407159/3407159_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [4] => Array
                (
                    [id] => 31083649
                    [user_id] => 2942443
                    [user_name] => alejandro_97_256
                    [comment] => Diosssssss me ha dado un infarto , os lo juro , con  el 2-3
                    [creation_date] => 2021-02-18 00:40:03
                    [last_update] => 2021-02-18 00:40:03
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_92/2942443/2942443_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [5] => Array
                (
                    [id] => 31083626
                    [user_id] => 3547435
                    [user_name] => gallo_1984_g
                    [comment] => Victoria guaimaraes un equipo sin valores de esos que causan es lastima
                    [creation_date] => 2021-02-18 00:37:55
                    [last_update] => 2021-02-18 00:37:55
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_111/3547435/3547435_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [6] => Array
                (
                    [id] => 31083623
                    [user_id] => 3343783
                    [user_name] => sheva7andriy
                    [comment] => Jajajjajaaj 2-3, y con uno menos
                    [creation_date] => 2021-02-18 00:37:54
                    [last_update] => 2021-02-18 00:37:54
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_105/3343783/3343783_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [7] => Array
                (
                    [id] => 31083620
                    [user_id] => 3508805
                    [user_name] => s_c_a_r_l_i_
                    [comment] => Gol de farense
                    [creation_date] => 2021-02-18 00:37:44
                    [last_update] => 2021-02-18 00:37:44
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_110/3508805/3508805_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [8] => Array
                (
                    [id] => 31083613
                    [user_id] => 3485738
                    [user_name] => lluc_3591004
                    [comment] => Gol de visita hahaha
                    [creation_date] => 2021-02-18 00:37:34
                    [last_update] => 2021-02-18 00:37:34
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_109/3485738/3485738_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [9] => Array
                (
                    [id] => 31083601
                    [user_id] => 2231269
                    [user_name] => jou_26655093
                    [comment] => Podrido estoy de esto, todo amañanado
                    [creation_date] => 2021-02-18 00:36:23
                    [last_update] => 2021-02-18 00:36:23
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_70/2231269/2231269_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [10] => Array
                (
                    [id] => 31083570
                    [user_id] => 3485738
                    [user_name] => lluc_3591004
                    [comment] => Gollll de localll vamos
                    [creation_date] => 2021-02-18 00:33:19
                    [last_update] => 2021-02-18 00:33:52
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_109/3485738/3485738_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                            [0] => Array
                                (
                                    [id] => 31083576
                                    [user_id] => 2795214
                                    [user_name] => sergio_62500
                                    [lang] => es
                                    [comment] => Jiji
                                    [creation_date] => 2021-02-18 00:33:52
                                    [last_update] => 2021-02-18 00:33:52
                                    [comment_id] => 31083570
                                    [votes_up] => 0
                                    [votes_down] => 0
                                    [is_response] => 1
                                    [user_avatar] => //resfu.thumbr.io/avatar_88/2795214/2795214_gallery.jpg?size=80x&rand=
                                )

                        )

                    [more_responses] => 
                    [total_responses] => 1
                )

            [11] => Array
                (
                    [id] => 31083518
                    [user_id] => 3337616
                    [user_name] => isaias_38874
                    [comment] => Tmr
                    [creation_date] => 2021-02-18 00:30:20
                    [last_update] => 2021-02-18 00:30:20
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_105/3337616/3337616_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [12] => Array
                (
                    [id] => 31083497
                    [user_id] => 2566954
                    [user_name] => lazaro_17899
                    [comment] => Quien está viendo este partido
                    [creation_date] => 2021-02-18 00:28:09
                    [last_update] => 2021-02-18 00:28:09
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_81/2566954/2566954_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [13] => Array
                (
                    [id] => 31083476
                    [user_id] => 2566954
                    [user_name] => lazaro_17899
                    [comment] => Creen q local marque
                    [creation_date] => 2021-02-18 00:27:17
                    [last_update] => 2021-02-18 00:27:17
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_81/2566954/2566954_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [14] => Array
                (
                    [id] => 31068469
                    [user_id] => 3220556
                    [user_name] => _lokooo_
                    [comment] => 2-0 gana local
                    [creation_date] => 2021-02-17 10:32:03
                    [last_update] => 2021-02-18 00:09:38
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_101/3220556/3220556_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                            [0] => Array
                                (
                                    [id] => 31083305
                                    [user_id] => 3220556
                                    [user_name] => _lokooo_
                                    [lang] => es
                                    [comment] => Gana local vamoss
                                    [creation_date] => 2021-02-18 00:09:38
                                    [last_update] => 2021-02-18 00:09:38
                                    [comment_id] => 31068469
                                    [votes_up] => 0
                                    [votes_down] => 0
                                    [is_response] => 1
                                    [user_avatar] => //resfu.thumbr.io/avatar_101/3220556/3220556_gallery.jpg?size=80x&rand=
                                )

                        )

                    [more_responses] => 
                    [total_responses] => 1
                )

            [15] => Array
                (
                    [id] => 31082188
                    [user_id] => 3543689
                    [user_name] => estados_3820
                    [comment] => Sera q ambos marcan
                    [creation_date] => 2021-02-17 23:02:28
                    [last_update] => 2021-02-17 23:26:26
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_111/3543689/3543689_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                            [0] => Array
                                (
                                    [id] => 31082747
                                    [user_id] => 2942443
                                    [user_name] => alejandro_97_256
                                    [lang] => es
                                    [comment] => Menos mal pero aún así hasta que no pite el final si marca otro andaré más tranquilo  jeje
                                    [creation_date] => 2021-02-17 23:26:26
                                    [last_update] => 2021-02-17 23:26:26
                                    [comment_id] => 31082188
                                    [votes_up] => 0
                                    [votes_down] => 0
                                    [is_response] => 1
                                    [user_avatar] => //resfu.thumbr.io/avatar_92/2942443/2942443_gallery.jpg?size=80x&rand=
                                )

                            [1] => Array
                                (
                                    [id] => 31082708
                                    [user_id] => 3543689
                                    [user_name] => estados_3820
                                    [lang] => es
                                    [comment] => Goool amigo
                                    [creation_date] => 2021-02-17 23:23:49
                                    [last_update] => 2021-02-17 23:23:49
                                    [comment_id] => 31082188
                                    [votes_up] => 0
                                    [votes_down] => 0
                                    [is_response] => 1
                                    [user_avatar] => //resfu.thumbr.io/avatar_111/3543689/3543689_gallery.jpg?size=80x&rand=
                                )

                            [2] => Array
                                (
                                    [id] => 31082449
                                    [user_id] => 2942443
                                    [user_name] => alejandro_97_256
                                    [lang] => es
                                    [comment] => Y encima no la puedo cerrar al ser un bono...
                                    [creation_date] => 2021-02-17 23:12:18
                                    [last_update] => 2021-02-17 23:12:18
                                    [comment_id] => 31082188
                                    [votes_up] => 0
                                    [votes_down] => 0
                                    [is_response] => 1
                                    [user_avatar] => //resfu.thumbr.io/avatar_92/2942443/2942443_gallery.jpg?size=80x&rand=
                                )

                        )

                    [more_responses] => 
                    [total_responses] => 9
                )

            [16] => Array
                (
                    [id] => 31082699
                    [user_id] => 2499310
                    [user_name] => alvaro_30768
                    [comment] => Goool local
                    [creation_date] => 2021-02-17 23:23:31
                    [last_update] => 2021-02-17 23:23:31
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_79/2499310/2499310_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [17] => Array
                (
                    [id] => 31082695
                    [user_id] => 3543689
                    [user_name] => estados_3820
                    [comment] => Goool
                    [creation_date] => 2021-02-17 23:23:25
                    [last_update] => 2021-02-17 23:23:25
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_111/3543689/3543689_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [18] => Array
                (
                    [id] => 31082663
                    [user_id] => 3508805
                    [user_name] => s_c_a_r_l_i_
                    [comment] => Ven la victoria del local?
                    [creation_date] => 2021-02-17 23:21:57
                    [last_update] => 2021-02-17 23:21:57
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_110/3508805/3508805_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

            [19] => Array
                (
                    [id] => 31082624
                    [user_id] => 3491146
                    [user_name] => david_969421
                    [comment] => Gana local 3-1
                    [creation_date] => 2021-02-17 23:19:56
                    [last_update] => 2021-02-17 23:19:56
                    [lang] => es
                    [template] => 
                    [votes_up] => 0
                    [votes_down] => 0
                    [porra] => Array
                        (
                        )

                    [is_response] => 
                    [user_avatar] => //resfu.thumbr.io/avatar_110/3491146/3491146_gallery.jpg?size=80x&rand=
                    [responses] => Array
                        (
                        )

                    [more_responses] => 
                    [total_responses] => 0
                )

        )

)
20
image description

alejandro_97_256 dice

No se me escapara no? , seria ya la ecatombe si gana el farense , teniendo 1x y con uno menos el rival , pero del fútbol no me fio

Hace 2 meses

Ver 5 respuestas

image description

alejandro_97_256 dice

50 euros de bono bienvenida d e kirolbet y 964 pavos

Hace 2 meses
image description

jesus_104448 dice

Hacías bien no fiandote

Hace 2 meses
image description

alejandro_97_256 dice

No me digas local , que me vas hacer sufrir , con uno más, enserio?

Hace 2 meses
image description

sergio_62500 dice

Tengo informes ahora remonta visita quien pille pasta que me de algo que esto que digo es un lujo

Hace 2 meses

Ver 19 respuestas

image description

sergio_62500 dice

Todo son matemáticas

Hace 2 meses
image description

sergio_62500 dice

Quiero ver ese premium

Hace 2 meses
image description

sergio_62500 dice

Las cosas serias

Hace 2 meses
image description

luis_jose_56_837 dice

Joa que equipo malo ese

Hace 2 meses
image description

luis_jose_56_837 dice

Hace 2 meses
image description

alejandro_97_256 dice

Diosssssss me ha dado un infarto , os lo juro , con el 2-3

Hace 2 meses
image description

gallo_1984_g dice

Victoria guaimaraes un equipo sin valores de esos que causan es lastima

Hace 2 meses
image description

sheva7andriy dice

Jajajjajaaj 2-3, y con uno menos

Hace 2 meses
image description

s_c_a_r_l_i_ dice

Gol de farense

Hace 2 meses
image description

lluc_3591004 dice

Gol de visita hahaha

Hace 2 meses
image description

jou_26655093 dice

Podrido estoy de esto, todo amañanado

Hace 2 meses
image description

lluc_3591004 dice

Gollll de localll vamos

Hace 2 meses

Ver 1 respuestas

image description

sergio_62500 dice

Jiji

Hace 2 meses
image description

isaias_38874 dice

Tmr

Hace 2 meses
image description

lazaro_17899 dice

Quien está viendo este partido

Hace 2 meses
image description

lazaro_17899 dice

Creen q local marque

Hace 2 meses
image description

_lokooo_ dice

2-0 gana local

Hace 2 meses

Ver 1 respuestas

image description

_lokooo_ dice

Gana local vamoss

Hace 2 meses
image description

estados_3820 dice

Sera q ambos marcan

Hace 2 meses

Ver 9 respuestas

image description

alejandro_97_256 dice

Menos mal pero aún así hasta que no pite el final si marca otro andaré más tranquilo jeje

Hace 2 meses
image description

estados_3820 dice

Goool amigo

Hace 2 meses
image description

alejandro_97_256 dice

Y encima no la puedo cerrar al ser un bono...

Hace 2 meses
image description

alvaro_30768 dice

Goool local

Hace 2 meses
image description

estados_3820 dice

Goool

Hace 2 meses
image description

s_c_a_r_l_i_ dice

Ven la victoria del local?

Hace 2 meses
image description

david_969421 dice

Gana local 3-1

Hace 2 meses

  USO DE MEMORIA  
4,556,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Match / Index )  0.4117
Total Execution Time  0.4149
  CADENA URL  
/partido/Vitoria-Guimaraes/Farense/comments
  GET DATOS  
$_GET['/partido/Vitoria-Guimaraes/Farense/comments']  
$_GET['langf']  
$_GET['lang_comment']  
$_GET['completed']  
$_GET['clang']  
$_GET['isocode']  
$_GET['group']  
$_GET['v']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (2)  
0.0034   SELECT c.*, 2021 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.stadium, dt1.seats, dt1.size, dt1.yearBuilt,dt1.short_name AS local_abbr, dt2.short_name AS visitor_abbr, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, s.team_id as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt FROM calendars2021 AS c INNER JOIN teams as t1 ON c.team1=t1.id INNER JOIN datateams AS dt1 ON t1.teamId=dt1.id INNER JOIN teams as t2 ON c.team2=t2.id INNER JOIN datateams AS dt2 ON t2.teamId=dt2.id LEFT JOIN stadiums AS s ON c.stadium=s.id WHERE c.extra != 1 AND dt1.basealias = 'Vitoria-Guimaraes' AND dt2.basealias = 'Farense'
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=84298 AND extraId = 57339 AND type_rel = 4