[
Help
] [
Aiuto
]
tratte SQL Search Interface
Search for records where:
field
SER
RNUM
PAGE
DDRAW
MDRAW
YDRAW
YEAR
OFFT
QUAR
TPURS
DPURS
OFFICE
TELEC
RDRAW
COM1
NAME1
COM2
NAME2
COM3
NAME3
COM4
NAME4
SURNAM1
SURNAM2
OCSTAT
OCNAME
ORIGIN
RECKEY
=
doesn't equal (<>)
<
<=
>
>=
contains regexp
is LIKE (%, _)
and
or
field
SER
RNUM
PAGE
DDRAW
MDRAW
YDRAW
YEAR
OFFT
QUAR
TPURS
DPURS
OFFICE
TELEC
RDRAW
COM1
NAME1
COM2
NAME2
COM3
NAME3
COM4
NAME4
SURNAM1
SURNAM2
OCSTAT
OCNAME
ORIGIN
RECKEY
=
doesn't equal (<>)
<
<=
>
>=
contains regexp
is LIKE (%, _)
and
or
field
SER
RNUM
PAGE
DDRAW
MDRAW
YDRAW
YEAR
OFFT
QUAR
TPURS
DPURS
OFFICE
TELEC
RDRAW
COM1
NAME1
COM2
NAME2
COM3
NAME3
COM4
NAME4
SURNAM1
SURNAM2
OCSTAT
OCNAME
ORIGIN
RECKEY
=
doesn't equal (<>)
<
<=
>
>=
contains regexp
is LIKE (%, _)
and
or
field
SER
RNUM
PAGE
DDRAW
MDRAW
YDRAW
YEAR
OFFT
QUAR
TPURS
DPURS
OFFICE
TELEC
RDRAW
COM1
NAME1
COM2
NAME2
COM3
NAME3
COM4
NAME4
SURNAM1
SURNAM2
OCSTAT
OCNAME
ORIGIN
RECKEY
=
doesn't equal (<>)
<
<=
>
>=
contains regexp
is LIKE (%, _)
and
or
field
SER
RNUM
PAGE
DDRAW
MDRAW
YDRAW
YEAR
OFFT
QUAR
TPURS
DPURS
OFFICE
TELEC
RDRAW
COM1
NAME1
COM2
NAME2
COM3
NAME3
COM4
NAME4
SURNAM1
SURNAM2
OCSTAT
OCNAME
ORIGIN
RECKEY
=
doesn't equal (<>)
<
<=
>
>=
contains regexp
is LIKE (%, _)
and
or
field
SER
RNUM
PAGE
DDRAW
MDRAW
YDRAW
YEAR
OFFT
QUAR
TPURS
DPURS
OFFICE
TELEC
RDRAW
COM1
NAME1
COM2
NAME2
COM3
NAME3
COM4
NAME4
SURNAM1
SURNAM2
OCSTAT
OCNAME
ORIGIN
RECKEY
=
doesn't equal (<>)
<
<=
>
>=
contains regexp
is LIKE (%, _)
and
or
field
SER
RNUM
PAGE
DDRAW
MDRAW
YDRAW
YEAR
OFFT
QUAR
TPURS
DPURS
OFFICE
TELEC
RDRAW
COM1
NAME1
COM2
NAME2
COM3
NAME3
COM4
NAME4
SURNAM1
SURNAM2
OCSTAT
OCNAME
ORIGIN
RECKEY
=
doesn't equal (<>)
<
<=
>
>=
contains regexp
is LIKE (%, _)
and
or
Return the following fields:
SER
RNUM
PAGE
DDRAW
MDRAW
YDRAW
YEAR
OFFT
QUAR
TPURS
DPURS
OFFICE
TELEC
RDRAW
COM1
NAME1
COM2
NAME2
COM3
NAME3
COM4
NAME4
SURNAM1
SURNAM2
OCSTAT
OCNAME
ORIGIN
RECKEY
Sorted by
Default
SER
RNUM
PAGE
DDRAW
MDRAW
YDRAW
YEAR
OFFT
QUAR
TPURS
DPURS
OFFICE
TELEC
RDRAW
COM1
NAME1
COM2
NAME2
COM3
NAME3
COM4
NAME4
SURNAM1
SURNAM2
OCSTAT
OCNAME
ORIGIN
RECKEY
; subsort by
Default
SER
RNUM
PAGE
DDRAW
MDRAW
YDRAW
YEAR
OFFT
QUAR
TPURS
DPURS
OFFICE
TELEC
RDRAW
COM1
NAME1
COM2
NAME2
COM3
NAME3
COM4
NAME4
SURNAM1
SURNAM2
OCSTAT
OCNAME
ORIGIN
RECKEY
; subsort by
Default
SER
RNUM
PAGE
DDRAW
MDRAW
YDRAW
YEAR
OFFT
QUAR
TPURS
DPURS
OFFICE
TELEC
RDRAW
COM1
NAME1
COM2
NAME2
COM3
NAME3
COM4
NAME4
SURNAM1
SURNAM2
OCSTAT
OCNAME
ORIGIN
RECKEY
; subsort by
Default
SER
RNUM
PAGE
DDRAW
MDRAW
YDRAW
YEAR
OFFT
QUAR
TPURS
DPURS
OFFICE
TELEC
RDRAW
COM1
NAME1
COM2
NAME2
COM3
NAME3
COM4
NAME4
SURNAM1
SURNAM2
OCSTAT
OCNAME
ORIGIN
RECKEY
Limit the result set to
records
Pick one or more Series to search:
Tre Maggiori
Guilds
Births
Raw SQL query:
Return to Searching the Tratte page