Untitled

mysql> select * from powerpriority;

+------------------------------+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| priorityname                 | recpriority | selectclause                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |

+------------------------------+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| PVR-350 for premium channels |          10 | cardinput.cardinputid = 2 AND

(

channel.callsign like 'HBO%'

or

channel.callsign like 'SHO%'

or

channel.callsign = 'COMEDY'

or

channel.callsign = 'IFC'

or

channel.callsign = 'TVONE'

or

channel.callsign = 'LOGO'

or

channel.callsign = 'BET'

or

channel.callsign = 'HISTORY'

or

channel.callsign = 'TOON'

or

channel.callsign = 'G4'

or

channel.channum = '209'

or

channel.callsign = 'FX'

or

channel.channum = '110'

or

channel.channum = '372'

) |

+------------------------------+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (0.00 sec)