SELECT `ytcode`,`params` FROM `page` 
            LEFT JOIN `pagevideolink` ON `page`.`index`=`pagevideolink`.`pageindex` 
            LEFT JOIN `video` ON `pagevideolink`.`videoindex`=`video`.`index` 
            WHERE `shortname`='consignordashboard' OR `longname`='consignordashboard'