SQE
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
getCatalogAndEdition
Parameters
Name
Type
Mode
param_plate
varchar(45)
IN
param_fragment
varchar(45)
IN
param_side
tinyint(1)
IN
Definition
select image_catalog.image_catalog_id, edition_catalog.edition_catalog_id from image_catalog left join image_to_edition_catalog USING(image_catalog_id) left join edition_catalog USING(edition_catalog_id) where image_catalog.catalog_number_1 = param_plate AND image_catalog.catalog_number_2 = param_fragment AND image_catalog.catalog_side = param_side