1146 - Table 'ckd_cnslt_par.asset_data' doesn't exist
SELECT DISTINCT
a.`aaia_brand_name`,
a.`part_num`,
a.`codeid`,
a.`filename`,
b.`source_map_id`,
b.`asset_source_line`
FROM
`ckd_cnslt_par`.`asset_data` a,
`ckd_cnslt_par`.`asset_data_source_map` b
WHERE
a.`blacklisted` = 0 AND
a.`aaia_brand_name` = b.`aaia_brand_name` AND
a.`product_id` = '788646' AND
a.`codeid` LIKE 'P%' AND
a.`codeid` != 'PDB' AND
-- a.`codeid` NOT LIKE 'P04' AND
a.`filename` != '' AND
a.`filename` != '#N/A'
-- DISABLE:
-- AND 1=0
-- AND a.`part_num` = '82-1197'
ORDER BY
(CASE WHEN a.`codeid` = 'P04' THEN 0 ELSE 1 END) ASC,
a.`codeid` ASC,
a.`filename` ASC
[TEP STOP]
