select lineups.shirtnumber,lineups.team_id,persons.name,persons.nationality_id,persons.firstname,persons.lastname,persons.person_id,persons.position,lineups.stats from lineups,persons where match_id=18162252 and lineups.person_id=persons.person_id
Paterna - Castellonense match result and lineups - 04 Oct 2020 | Club Friendlies