How to check product routes

Product routes can be checked in Midgard DB "productparts" table. This table references two other tables, "product" and "segmentdc".

The following statement can be used with Season and Product number:

SELECT p.strproductcode,  sdc.dtmflight, sdc.strflnrdc, sdc.strdepdc, sdc.strdesdc, pp.strparttype FROM productparts pp
JOIN product p ON pp.lngproductid = p.lngid
JOIN segmentdc sdc ON pp.lngrefid = sdc.lngid
WHERE p.strSeason = 'X00'
AND p.strproductcode = 123456
ORDER BY p.strproductcode, sdc.dtmflight