SELECT 1 AS valid_for_ip, l.*, IF(LENGTH(>0,,CONCAT(u.first_name,' ', u.last_name)) AS heading
    FROM iris.dma_licenses as l
    JOIN iris_ambrose.jos_vm_user_info AS u ON (u.user_info_id = l.dma_license)
    WHERE l.client_id=159 AND iris.FIND_IN_SET_X(',.*,.*.*', REPLACE(dma_authorized_urls,' ',''))
Report Link Problem

Licensed videos for (Lyrasis) Fayetteville State University

Find clips by typing keywords, then press Enter.

Enclose phrases in double quotation marks, e.g. "Grapes of Wrath"   "Henry IV".
Descriptions, keywords, and captions will be searched; punctuation is ignored.

Words and Phrases to match:
Match All Keywords     Match Any Keywords

Words and Phrases to omit:

Video Durations can be seen by moving your mouse over the Play button.

© 2016 Ambrose Video Publishing, Inc. • Powered by IRIS Education • v2.1301