|
SELECT DISTINCT courses2_courses2_courses.*, DATE_FORMAT(courses2_courses2_courses.CreatedDate, '%e %b %Y') AS CreatedDateFormat, courses2_core_category.Serial AS CategorySerial, courses2_core_category.Title AS CategoryTitle, courses2_core_category.Parent AS CategoryParent FROM courses2_courses2_courses, courses2_core_categoryjoin, courses2_core_category
WHERE 1 AND (courses2_core_categoryjoin.CategoryId = '32') AND (courses2_courses2_courses.Archive = '0')AND (courses2_core_categoryjoin.CategoryId = courses2_core_category.Serial)AND (courses2_core_categoryjoin.CategoryId = '32')AND (courses2_core_categoryjoin.JoinId = courses2_courses2_courses.Serial)AND (courses2_courses2_courses.Public = '1')
SELECT DISTINCT courses2_courses2_courses.*, DATE_FORMAT(courses2_courses2_courses.CreatedDate, '%e %b %Y') AS CreatedDateFormat, courses2_core_category.Serial AS CategorySerial, courses2_core_category.Title AS CategoryTitle, courses2_core_category.Parent AS CategoryParent FROM courses2_courses2_courses, courses2_core_categoryjoin, courses2_core_category
WHERE 1 AND (courses2_core_categoryjoin.CategoryId = '38') AND (courses2_courses2_courses.Archive = '0')AND (courses2_core_categoryjoin.CategoryId = courses2_core_category.Serial)AND (courses2_core_categoryjoin.CategoryId = '38')AND (courses2_core_categoryjoin.JoinId = courses2_courses2_courses.Serial)AND (courses2_courses2_courses.Public = '1')
SELECT DISTINCT courses2_courses2_courses.*, DATE_FORMAT(courses2_courses2_courses.CreatedDate, '%e %b %Y') AS CreatedDateFormat, courses2_core_category.Serial AS CategorySerial, courses2_core_category.Title AS CategoryTitle, courses2_core_category.Parent AS CategoryParent FROM courses2_courses2_courses, courses2_core_categoryjoin, courses2_core_category
WHERE 1 AND (courses2_core_categoryjoin.CategoryId = '52') AND (courses2_courses2_courses.Archive = '0')AND (courses2_core_categoryjoin.CategoryId = courses2_core_category.Serial)AND (courses2_core_categoryjoin.CategoryId = '52')AND (courses2_core_categoryjoin.JoinId = courses2_courses2_courses.Serial)AND (courses2_courses2_courses.Public = '1')
SELECT DISTINCT courses2_courses2_courses.*, DATE_FORMAT(courses2_courses2_courses.CreatedDate, '%e %b %Y') AS CreatedDateFormat, courses2_core_category.Serial AS CategorySerial, courses2_core_category.Title AS CategoryTitle, courses2_core_category.Parent AS CategoryParent FROM courses2_courses2_courses, courses2_core_categoryjoin, courses2_core_category
WHERE 1 AND (courses2_core_categoryjoin.CategoryId = '77') AND (courses2_courses2_courses.Archive = '0')AND (courses2_core_categoryjoin.CategoryId = courses2_core_category.Serial)AND (courses2_core_categoryjoin.CategoryId = '77')AND (courses2_core_categoryjoin.JoinId = courses2_courses2_courses.Serial)AND (courses2_courses2_courses.Public = '1')
|
