Advertisement
Guest User

Untitled

a guest
May 25th, 2017
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.73 KB | None | 0 0
  1. "genresQuery" : "SELECT * FROM tb_cat_genre;",    "channelsQuery" : "SELECT * FROM tb_channel WHERE in_active = 1;",    "subgenresQuery" : "SELECT * FROM tb_cat_subgenre",    "vodsQuery" : "SELECT tb_content.*, tb_content_language.title, tb_content_language.short_description, tb_content_language.long_description FROM tb_content LEFT JOIN tb_content_language ON tb_content.id_content = tb_content_language.id_content WHERE tb_content.start_date < NOW() and tb_content.expiry_date > NOW();",    "eventsQuery" : "SELECT tb_event.*, tb_event_language.title, tb_event_language.subtitle, tb_event_language.description FROM tb_event LEFT JOIN  tb_event_language ON tb_event.id_event = tb_event_language.id_event WHERE tb_event.fc_end > NOW();",    "eventsLogoTransQuery" : "SELECT lt.* FROM tb_event_logo_transition lt, tb_event ev WHERE ev.id_event = lt.id_event AND ev.fc_end > NOW();",    "vodsLogoTransQuery" : "SELECT lt.* FROM tb_content_logo_transition lt, tb_content vod WHERE vod.id_content = lt.id_content AND vod.start_date < NOW() and vod.expiry_date > NOW();",    "channelsLogoTransQuery" : "SELECT lt.* FROM tb_channel_logo_transition lt, tb_channel ch WHERE ch.id_channel = lt.id_channel AND ch.in_active = 1;",    "categoriesQuery" : "SELECT * from tb_cat_category ORDER BY tb_cat_category.order;",    "eventCategoriesQuery" : "SELECT ec.* from tb_event_category ec, tb_event ev WHERE ev.id_event = ec.id_event AND ev.fc_end > NOW();",    "channelCategoriesQuery" : "SELECT cc.* from tb_channel_category cc, tb_channel ch WHERE ch.id_channel = cc.id_channel AND ch.in_active = 1;",    "contentCategoriesQuery" : "SELECT cc.* from tb_content_category cc, tb_content vod WHERE vod.id_content = cc.id_content AND vod.start_date < NOW() and vod.expiry_date > NOW();"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement