( SELECT MAT.ContentID,
MAT.ContentType,
MAT.CategoryID,
CAT.CategoryName,
CAT.CategorySEO,
MAT.Title,
MAT.SubTitle,
MAT.AnonsContent,
MAT.Image1,
MAT.Image2,
MAT.image_big,
MAT.image_medium,
MAT.image_small,
MAT.AuthorID,
MAT.AuthorGuid,
MAT.AuthorName,
AUT.AuthorPhoto,
AUT.AuthorUrl,
MAT.dtPublish,
MAT.isHot,
MAT.isHotCategory,
MAT.isTop,
MAT.isPublished,
MAT.isComment,
MAT.isDelete,
'top_article' as sql_type
FROM ContentMaterials MAT
USE INDEX(indSMat)
INNER JOIN ContentCategoriesDonetsk CAT ON CAT.CategoryID = MAT.CategoryID
INNER JOIN ContentAuthors AUT ON AUT.AuthorID = MAT.AuthorGuid
WHERE MAT.ContentType = 1 AND MAT.isTop = 1 AND MAT.dtPublish < 1226098655 AND MAT.isPublished = 1 AND MAT.isDelete = 0
ORDER BY MAT.dtPublish DESC
LIMIT 1
) UNION (
SELECT MAT.ContentID,
MAT.ContentType,
MAT.CategoryID,
CAT.CategoryName,
CAT.CategorySEO,
MAT.Title,
MAT.SubTitle,
MAT.AnonsContent,
MAT.Image1,
MAT.Image2,
MAT.image_big,
MAT.image_medium,
MAT.image_small,
MAT.AuthorID,
MAT.AuthorGuid,
NULL as AuthorName,
NULL as AuthorPhoto,
NULL as AuthorUrl,
MAT.dtPublish,
MAT.isHot,
MAT.isHotCategory,
MAT.isTop,
MAT.isPublished,
MAT.isComment,
MAT.isDelete,
'web_conf' as sql_type
FROM ContentMaterials MAT
USE INDEX(indSMatC)
INNER JOIN ContentCategoriesDonetsk CAT ON CAT.CategoryID = MAT.CategoryID
WHERE MAT.ContentType = 1 AND MAT.CategoryID = 68 AND MAT.dtPublish < 1226098655 AND MAT.isPublished = 1 AND MAT.isDelete = 0
ORDER BY MAT.dtPublish DESC
LIMIT 1
) UNION (
SELECT MAT.ContentID,
MAT.ContentType,
MAT.CategoryID,
CAT.CategoryName,
CAT.CategorySEO,
MAT.Title,
MAT.SubTitle,
MAT.AnonsContent,
MAT.Image1,
MAT.Image2,
MAT.image_big,
MAT.image_medium,
MAT.image_small,
MAT.AuthorID,
MAT.AuthorGuid,
NULL as AuthorName,
NULL as AuthorPhoto,
NULL as AuthorUrl,
MAT.dtPublish,
MAT.isHot,
MAT.isHotCategory,
MAT.isTop,
MAT.isPublished,
MAT.isComment,
MAT.isDelete,
'guest' as sql_type
FROM ContentMaterials MAT
USE INDEX(indSMatC)
INNER JOIN ContentCategoriesDonetsk CAT ON CAT.CategoryID = MAT.CategoryID
WHERE MAT.ContentType = 1 AND MAT.CategoryID = 16 AND MAT.dtPublish < 1226098655 AND MAT.isPublished = 1 AND MAT.isDelete = 0
ORDER BY MAT.dtPublish DESC
LIMIT 1
) UNION (
SELECT MAT.ContentID,
MAT.ContentType,
MAT.CategoryID,
CAT.CategoryName,
CAT.CategorySEO,
MAT.Title,
MAT.SubTitle,
MAT.AnonsContent,
MAT.Image1,
MAT.Image2,
MAT.image_big,
MAT.image_medium,
MAT.image_small,
MAT.AuthorID,
MAT.AuthorGuid,
MAT.AuthorName,
NULL as AuthorPhoto,
NULL as AuthorUrl,
MAT.dtPublish,
MAT.isHot,
MAT.isHotCategory,
MAT.isTop,
MAT.isPublished,
MAT.isComment,
MAT.isDelete,
'hot_articles' as sql_type
FROM ContentMaterials MAT
USE INDEX(indSMatH)
INNER JOIN ContentCategoriesDonetsk CAT ON CAT.CategoryID = MAT.CategoryID
INNER JOIN ContentAuthors AUT ON AUT.AuthorID = MAT.AuthorGuid
WHERE MAT.ContentType = 1 AND MAT.isHot = 1 AND MAT.dtPublish < 1226098655 AND MAT.isPublished = 1 AND MAT.isDelete = 0
ORDER BY MAT.dtPublish DESC
LIMIT 4
) UNION (
SELECT MAT.ContentID,
MAT.ContentType,
MAT.CategoryID,
CAT.CategoryName,
CAT.CategorySEO,
MAT.Title,
MAT.SubTitle,
MAT.AnonsContent,
MAT.Image1,
MAT.Image2,
MAT.image_big,
MAT.image_medium,
MAT.image_small,
MAT.AuthorID,
MAT.AuthorGuid,
NULL as AuthorName,
NULL as AuthorPhoto,
NULL as AuthorUrl,
MAT.dtPublish,
MAT.isHot,
MAT.isHotCategory,
MAT.isTop,
MAT.isPublished,
MAT.isComment,
MAT.isDelete,
'city_articles' as sql_type
FROM ContentMaterials MAT
USE INDEX(indSMatCHC)
INNER JOIN ContentCategoriesDonetsk CAT ON MAT.CategoryID = CAT.CategoryID
INNER JOIN ContentAuthors AUT ON AUT.AuthorID = MAT.AuthorGuid
WHERE MAT.ContentType = 1 AND MAT.CategoryID = 10 AND MAT.isHotCategory = 1 AND MAT.dtPublish < 1226098655 AND MAT.isPublished = 1 AND MAT.isDelete = 0
ORDER BY MAT.dtPublish DESC
LIMIT 5
) UNION (
SELECT MAT.ContentID,
MAT.ContentType,
MAT.CategoryID,
CAT.CategoryName,
CAT.CategorySEO,
MAT.Title,
MAT.SubTitle,
MAT.AnonsContent,
MAT.Image1,
MAT.Image2,
MAT.image_big,
MAT.image_medium,
MAT.image_small,
MAT.AuthorID,
MAT.AuthorGuid,
NULL as AuthorName,
NULL as AuthorPhoto,
NULL as AuthorUrl,
MAT.dtPublish,
MAT.isHot,
MAT.isHotCategory,
MAT.isTop,
MAT.isPublished,
MAT.isComment,
MAT.isDelete,
'country_articles' as sql_type
FROM ContentMaterials MAT
USE INDEX(indSMatCHC)
INNER JOIN ContentCategoriesDonetsk CAT ON MAT.CategoryID = CAT.CategoryID
INNER JOIN ContentAuthors AUT ON AUT.AuthorID = MAT.AuthorGuid
WHERE MAT.ContentType = 1 AND MAT.CategoryID = 11 AND MAT.isHotCategory = 1 AND MAT.dtPublish < 1226098655 AND MAT.isPublished = 1 AND MAT.isDelete = 0
ORDER BY MAT.dtPublish DESC
LIMIT 5
) UNION (
SELECT MAT.ContentID,
MAT.ContentType,
MAT.CategoryID,
CAT.CategoryName,
CAT.CategorySEO,
MAT.Title,
MAT.SubTitle,
MAT.AnonsContent,
MAT.Image1,
MAT.Image2,
MAT.image_big,
MAT.image_medium,
MAT.image_small,
MAT.AuthorID,
MAT.AuthorGuid,
NULL as AuthorName,
NULL as AuthorPhoto,
NULL as AuthorUrl,
MAT.dtPublish,
MAT.isHot,
MAT.isHotCategory,
MAT.isTop,
MAT.isPublished,
MAT.isComment,
MAT.isDelete,
'world_articles' as sql_type
FROM ContentMaterials MAT
USE INDEX(indSMatCHC)
INNER JOIN ContentCategoriesDonetsk CAT ON MAT.CategoryID = CAT.CategoryID
INNER JOIN ContentAuthors AUT ON AUT.AuthorID = MAT.AuthorGuid
WHERE MAT.ContentType = 1 AND MAT.CategoryID = 12 AND MAT.isHotCategory = 1 AND MAT.dtPublish < 1226098655 AND MAT.isPublished = 1 AND MAT.isDelete = 0
ORDER BY MAT.dtPublish DESC
LIMIT 5
) UNION (
SELECT MAT.ContentID,
MAT.ContentType,
MAT.CategoryID,
CAT.CategoryName,
CAT.CategorySEO,
MAT.Title,
MAT.SubTitle,
MAT.AnonsContent,
MAT.Image1,
MAT.Image2,
MAT.image_big,
MAT.image_medium,
MAT.image_small,
MAT.AuthorID,
MAT.AuthorGuid,
NULL as AuthorName,
NULL as AuthorPhoto,
NULL as AuthorUrl,
MAT.dtPublish,
MAT.isHot,
MAT.isHotCategory,
MAT.isTop,
MAT.isPublished,
MAT.isComment,
MAT.isDelete,
'sport_articles' as sql_type
FROM ContentMaterials MAT
USE INDEX(indSMatCHC)
INNER JOIN ContentCategoriesDonetsk CAT ON MAT.CategoryID = CAT.CategoryID
INNER JOIN ContentAuthors AUT ON AUT.AuthorID = MAT.AuthorGuid
WHERE MAT.ContentType = 1 AND MAT.CategoryID = 13 AND MAT.isHotCategory = 1 AND MAT.dtPublish < 1226098655 AND MAT.isPublished = 1 AND MAT.isDelete = 0
ORDER BY MAT.dtPublish DESC
LIMIT 5
) UNION (
SELECT MAT.ContentID,
MAT.ContentType,
MAT.CategoryID,
CAT.CategoryName,
CAT.CategorySEO,
MAT.Title,
MAT.SubTitle,
MAT.AnonsContent,
MAT.Image1,
MAT.Image2,
MAT.image_big,
MAT.image_medium,
MAT.image_small,
MAT.AuthorID,
MAT.AuthorGuid,
NULL as AuthorName,
NULL as AuthorPhoto,
NULL as AuthorUrl,
MAT.dtPublish,
MAT.isHot,
MAT.isHotCategory,
MAT.isTop,
MAT.isPublished,
MAT.isComment,
MAT.isDelete,
'people_articles' as sql_type
FROM ContentMaterials MAT
USE INDEX(indSMatCHC)
INNER JOIN ContentCategoriesDonetsk CAT ON MAT.CategoryID = CAT.CategoryID
INNER JOIN ContentAuthors AUT ON AUT.AuthorID = MAT.AuthorGuid
WHERE MAT.ContentType = 1 AND MAT.CategoryID = 31 AND MAT.isHotCategory = 1 AND MAT.dtPublish < 1226098655 AND MAT.isPublished = 1 AND MAT.isDelete = 0
ORDER BY MAT.dtPublish DESC
LIMIT 5
) UNION (
SELECT MAT.ContentID,
MAT.ContentType,
MAT.CategoryID,
CAT.CategoryName,
CAT.CategorySEO,
MAT.Title,
MAT.SubTitle,
MAT.AnonsContent,
MAT.Image1,
MAT.Image2,
MAT.image_big,
MAT.image_medium,
MAT.image_small,
MAT.AuthorID,
MAT.AuthorGuid,
NULL as AuthorName,
NULL as AuthorPhoto,
NULL as AuthorUrl,
MAT.dtPublish,
MAT.isHot,
MAT.isHotCategory,
MAT.isTop,
MAT.isPublished,
MAT.isComment,
MAT.isDelete,
'bomond_articles' as sql_type
FROM ContentMaterials MAT
USE INDEX(indSMatCHC)
INNER JOIN ContentCategoriesDonetsk CAT ON MAT.CategoryID = CAT.CategoryID
INNER JOIN ContentAuthors AUT ON AUT.AuthorID = MAT.AuthorGuid
WHERE MAT.ContentType = 1 AND MAT.CategoryID = 19 AND MAT.isHotCategory = 1 AND MAT.dtPublish < 1226098655 AND MAT.isPublished = 1 AND MAT.isDelete = 0
ORDER BY MAT.dtPublish DESC
LIMIT 5
) UNION (
SELECT MAT.ContentID,
MAT.ContentType,
MAT.CategoryID,
CAT.CategoryName,
CAT.CategorySEO,
MAT.Title,
MAT.SubTitle,
MAT.AnonsContent,
MAT.Image1,
MAT.Image2,
MAT.image_big,
MAT.image_medium,
MAT.image_small,
MAT.AuthorID,
MAT.AuthorGuid,
MAT.AuthorName,
AUT.AuthorPhoto,
AUT.AuthorUrl,
MAT.dtPublish,
MAT.isHot,
MAT.isHotCategory,
MAT.isTop,
MAT.isPublished,
MAT.isComment,
MAT.isDelete,
'view_from_articles' as sql_type
FROM ContentMaterials MAT
USE INDEX(indSMatC)
INNER JOIN ContentCategoriesDonetsk CAT ON MAT.CategoryID = CAT.CategoryID
INNER JOIN ContentAuthors AUT ON AUT.AuthorID = MAT.AuthorGuid
WHERE MAT.ContentType = 1 AND MAT.CategoryID = 39 AND MAT.dtPublish < 1226098655 AND MAT.isPublished = 1 AND MAT.isDelete = 0
ORDER BY MAT.dtPublish DESC
LIMIT 1
) UNION (
SELECT MAT.ContentID,
MAT.ContentType,
MAT.CategoryID,
CAT.CategoryName,
CAT.CategorySEO,
MAT.Title,
MAT.SubTitle,
MAT.AnonsContent,
MAT.Image1,
MAT.Image2,
MAT.image_big,
MAT.image_medium,
MAT.image_small,
MAT.AuthorID,
MAT.AuthorGuid,
MAT.AuthorName,
AUT.AuthorPhoto,
AUT.AuthorUrl,
MAT.dtPublish,
MAT.isHot,
MAT.isHotCategory,
MAT.isTop,
MAT.isPublished,
MAT.isComment,
MAT.isDelete,
'retro_articles' as sql_type
FROM ContentMaterialsDonetsk MAT
USE INDEX(indSMatC)
INNER JOIN ContentCategoriesDonetsk CAT ON MAT.CategoryID = CAT.CategoryID
INNER JOIN ContentAuthors AUT ON AUT.AuthorID = MAT.AuthorGuid
WHERE MAT.ContentType = 1 AND MAT.CategoryID = 36 AND MAT.dtPublish < 1226098655 AND MAT.isPublished = 1 AND MAT.isDelete = 0
ORDER BY MAT.dtPublish DESC
LIMIT 1
) UNION (
SELECT MAT.ContentID,
MAT.ContentType,
MAT.CategoryID,
CAT.CategoryName,
CAT.CategorySEO,
MAT.Title,
MAT.SubTitle,
MAT.AnonsContent,
MAT.Image1,
MAT.Image2,
MAT.image_big,
MAT.image_medium,
MAT.image_small,
MAT.AuthorID,
MAT.AuthorGuid,
NULL as AuthorName,
NULL as AuthorPhoto,
NULL as AuthorUrl,
MAT.dtPublish,
MAT.isHot,
MAT.isHotCategory,
MAT.isTop,
MAT.isPublished,
MAT.isComment,
MAT.isDelete,
'hot_news' as sql_type
FROM ContentMaterials MAT
USE INDEX(indSMatH)
INNER JOIN ContentCategoriesDonetsk CAT ON CAT.CategoryID = MAT.CategoryID
WHERE MAT.ContentType = 2 AND MAT.isHot = 1 AND MAT.dtPublish < 1226098655 AND MAT.isDelete = 0 AND MAT.isPublished = 1
ORDER BY MAT.dtPublish DESC
LIMIT 5
) UNION (
SELECT MAT.ContentID,
MAT.ContentType,
MAT.CategoryID,
CAT.CategoryName,
CAT.CategorySEO,
MAT.Title,
MAT.SubTitle,
MAT.AnonsContent,
MAT.Image1,
MAT.Image2,
MAT.image_big,
MAT.image_medium,
MAT.image_small,
MAT.AuthorID,
MAT.AuthorGuid,
NULL as AuthorName,
NULL as AuthorPhoto,
NULL as AuthorUrl,
MAT.dtPublish,
MAT.isHot,
MAT.isHotCategory,
MAT.isTop,
MAT.isPublished,
MAT.isComment,
MAT.isDelete,
'other_news' as sql_type
FROM ContentMaterials MAT
USE INDEX(indSMatH)
INNER JOIN ContentCategoriesDonetsk CAT ON CAT.CategoryID = MAT.CategoryID
WHERE MAT.ContentType = 2 AND MAT.isHot = 0 AND MAT.dtPublish < 1226098655 AND MAT.isDelete = 0 AND MAT.isPublished = 1
ORDER BY MAT.dtPublish DESC
LIMIT 10
) UNION (
SELECT MAT.ContentID,
MAT.ContentType,
MAT.CategoryID,
CAT.CategoryName,
CAT.CategorySEO,
MAT.Title,
MAT.SubTitle,
MAT.AnonsContent,
MAT.Image1,
MAT.Image2,
MAT.image_big,
MAT.image_medium,
MAT.image_small,
MAT.AuthorID,
MAT.AuthorGuid,
NULL as AuthorName,
NULL as AuthorPhoto,
NULL as AuthorUrl,
MAT.dtPublish,
MAT.isHot,
MAT.isHotCategory,
MAT.isTop,
MAT.isPublished,
MAT.isComment,
MAT.isDelete,
'narod_news' as sql_type
FROM ContentMaterials MAT
USE INDEX(indSMatH)
INNER JOIN ContentCategoriesDonetsk CAT ON CAT.CategoryID = MAT.CategoryID
WHERE MAT.ContentType = 3 AND MAT.dtPublish < 1226098655 AND MAT.isDelete = 0 AND MAT.isPublished = 1
ORDER BY MAT.dtPublish DESC
LIMIT 3
) UNION (
SELECT MAT.ContentID,
MAT.ContentType,
MAT.CategoryID,
CAT.CategoryName,
CAT.CategorySEO,
MAT.Title,
MAT.SubTitle,
MAT.AnonsContent,
MAT.Image1,
MAT.Image2,
MAT.image_big,
MAT.image_medium,
MAT.image_small,
MAT.AuthorID,
MAT.AuthorGuid,
NULL as AuthorName,
NULL as AuthorPhoto,
NULL as AuthorUrl,
MAT.dtPublish,
MAT.isHot,
MAT.isHotCategory,
MAT.isTop,
MAT.isPublished,
MAT.isComment,
MAT.isDelete,
'goodies_articles' as sql_type
FROM ContentMaterials MAT
USE INDEX(indSMatCHC)
INNER JOIN ContentCategoriesDonetsk CAT ON CAT.CategoryID = MAT.CategoryID
WHERE MAT.ContentType = 1 AND MAT.CategoryID = 14 AND MAT.isHotCategory = 1 AND MAT.dtPublish < 1226098655 AND MAT.isDelete = 0 AND MAT.isPublished = 1
ORDER BY MAT.dtPublish DESC
LIMIT 5
) UNION (
SELECT MAT.ContentID,
MAT.ContentType,
MAT.CategoryID,
CAT.CategoryName,
CAT.CategorySEO,
MAT.Title,
MAT.SubTitle,
MAT.AnonsContent,
MAT.Image1,
MAT.Image2,
MAT.image_big,
MAT.image_medium,
MAT.image_small,
MAT.AuthorID,
MAT.AuthorGuid,
NULL as AuthorName,
NULL as AuthorPhoto,
NULL as AuthorUrl,
MAT.dtPublish,
MAT.isHot,
MAT.isHotCategory,
MAT.isTop,
MAT.isPublished,
MAT.isComment,
MAT.isDelete,
'health_articles' as sql_type
FROM ContentMaterials MAT
USE INDEX(indSMatCHC)
INNER JOIN ContentCategoriesDonetsk CAT ON CAT.CategoryID = MAT.CategoryID
WHERE MAT.ContentType = 1 AND MAT.CategoryID = 15 AND MAT.isHotCategory = 1 AND MAT.dtPublish < 1226098655 AND MAT.isDelete = 0 AND MAT.isPublished = 1
ORDER BY MAT.dtPublish DESC
LIMIT 5
) UNION (
SELECT MAT.ContentID,
MAT.ContentType,
MAT.CategoryID,
CAT.CategoryName,
CAT.CategorySEO,
MAT.Title,
MAT.SubTitle,
MAT.AnonsContent,
MAT.Image1,
MAT.Image2,
MAT.image_big,
MAT.image_medium,
MAT.image_small,
MAT.AuthorID,
MAT.AuthorGuid,
NULL as AuthorName,
NULL as AuthorPhoto,
NULL as AuthorUrl,
MAT.dtPublish,
MAT.isHot,
MAT.isHotCategory,
MAT.isTop,
MAT.isPublished,
MAT.isComment,
MAT.isDelete,
'kopilka_articles' as sql_type
FROM ContentMaterials MAT
USE INDEX(indSMatCHC)
INNER JOIN ContentCategoriesDonetsk CAT ON CAT.CategoryID = MAT.CategoryID
WHERE MAT.ContentType = 1 AND MAT.CategoryID = 55 AND MAT.isHotCategory = 1 AND MAT.dtPublish < 1226098655 AND MAT.isDelete = 0 AND MAT.isPublished = 1
ORDER BY MAT.dtPublish DESC
LIMIT 5
) UNION (
SELECT MAT.ContentID,
MAT.ContentType,
MAT.CategoryID,
CAT.CategoryName,
CAT.CategorySEO,
MAT.Title,
MAT.SubTitle,
MAT.AnonsContent,
MAT.Image1,
MAT.Image2,
MAT.image_big,
MAT.image_medium,
MAT.image_small,
MAT.AuthorID,
MAT.AuthorGuid,
NULL as AuthorName,
NULL as AuthorPhoto,
NULL as AuthorUrl,
MAT.dtPublish,
MAT.isHot,
MAT.isHotCategory,
MAT.isTop,
MAT.isPublished,
MAT.isComment,
MAT.isDelete,
'travels_articles' as sql_type
FROM ContentMaterials MAT
USE INDEX(indSMatCHC)
INNER JOIN ContentCategoriesDonetsk CAT ON CAT.CategoryID = MAT.CategoryID
WHERE MAT.ContentType = 1 AND MAT.CategoryID = 38 AND MAT.isHotCategory = 1 AND MAT.dtPublish < 1226098655 AND MAT.isDelete = 0 AND MAT.isPublished = 1
ORDER BY MAT.dtPublish DESC
LIMIT 5
)
ORDER BY dtPublish DESC
Key 'indSMatCHC' doesn't exist in table 'MAT'