Публикации

-
___ 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")) >= 1483218000 AND UNIX_TIMESTAMP(STR_TO_DATE(`tb_tmplvar_contentvalues_publicationspub_data_date`.value, "%d.%m.%Y")) < 1603400400) ORDER BY `createdon` DESC LIMIT 0, 10;
Показывать по:
Показывать по: