Проверенные решения автоматизации
Основана в 1992 г.
Публикации
___
SELECT `modx_site_content`.id, longtitle, introtext, createdon, `tb_tmplvars_publicationsimg`.name AS `tv_publicationsimg`, `tb_tmplvar_contentvalues_publicationsimg`.value AS `tv_values_publicationsimg`, `tb_tmplvars_publicationsshort`.name AS `tv_publicationshort`, `tb_tmplvar_contentvalues_publicationsshort`.value AS `tv_values_publicationsshort`, `tb_tmplvars_publicationspub_data_date`.name AS `tv_publicationpub_data_date`, `tb_tmplvar_contentvalues_publicationspub_data_date`.value AS `tv_values_publicationspub_data_date`
FROM `modx_site_content`
LEFT JOIN `modx_site_tmplvars` AS `tb_tmplvars_publicationsimg` ON
`tb_tmplvars_publicationsimg`.name = "pubimg_grey"
LEFT JOIN `modx_site_tmplvar_contentvalues` AS `tb_tmplvar_contentvalues_publicationsimg` ON
`tb_tmplvar_contentvalues_publicationsimg`.tmplvarid = `tb_tmplvars_publicationsimg`.id AND
`tb_tmplvar_contentvalues_publicationsimg`.contentid = `modx_site_content`.id
LEFT JOIN `modx_site_tmplvars` AS `tb_tmplvars_publicationsshort` ON
`tb_tmplvars_publicationsshort`.name = "newsshort"
LEFT JOIN `modx_site_tmplvar_contentvalues` AS `tb_tmplvar_contentvalues_publicationsshort` ON
`tb_tmplvar_contentvalues_publicationsshort`.tmplvarid = `tb_tmplvars_publicationsshort`.id AND
`tb_tmplvar_contentvalues_publicationsshort`.contentid = `modx_site_content`.id
LEFT JOIN `modx_site_tmplvars` AS `tb_tmplvars_publicationspub_data_date` ON
`tb_tmplvars_publicationspub_data_date`.name = "pub_data_date"
LEFT JOIN `modx_site_tmplvar_contentvalues` AS `tb_tmplvar_contentvalues_publicationspub_data_date` ON
`tb_tmplvar_contentvalues_publicationspub_data_date`.tmplvarid = `tb_tmplvars_publicationspub_data_date`.id AND
`tb_tmplvar_contentvalues_publicationspub_data_date`.contentid = `modx_site_content`.id
WHERE `modx_site_content`.published = 1 AND `modx_site_content`.parent = 52 AND isfolder=0 AND (UNIX_TIMESTAMP(STR_TO_DATE(`tb_tmplvar_contentvalues_publicationspub_data_date`.value, "%d.%m.%Y")) >= 1577826000 AND UNIX_TIMESTAMP(STR_TO_DATE(`tb_tmplvar_contentvalues_publicationspub_data_date`.value, "%d.%m.%Y")) < 1702328400)
ORDER BY `createdon` DESC LIMIT 0, 10;