SELECT * FROM (

SELECT
tag_id,jfik4_content.id,title,alias,introtext,`fulltext`,state,catid,
created,created_by,modified,modified_by,publish_up,publish_down,images,
urls,attribs,ordering,metakey,metadesc,access,hits,metadata,`language`,
extrainfo_1,saist_not_nr,saist_not_pien_datums,saistitie_raksti,nr_p_k,
vieta,proj_sakuma_datums,proj_statuss,proj_istenotajs,iepirkumi_kat,
date_event_start,date_event_end,
IF(date_event_end='0000-00-00 00:00:00', date_event_start, date_event_end) as date_event_today
FROM
`jfik4_contentitem_tag_map`, `jfik4_content`, `extrainfo_1`
WHERE
jfik4_contentitem_tag_map.content_item_id = jfik4_content.id
AND
extrainfo_1.id = jfik4_content.id




GROUP BY jfik4_content.id

ORDER BY date_event_start


) as content

WHERE
(
date_event_start > '2015-10-02 12:48:00'
OR
date_event_today > '2015-10-02 12:48:00'
)






















//jaasaliek visi columns lai nebuutu dublicate columns

SET @date_event_today:=9;


SELECT
tag_id,jfik4_content.id,alias,
extrainfo_1,saist_not_nr,saist_not_pien_datums,saistitie_raksti,date_event_start,date_event_end,nr_p_k
vieta,proj_sakuma_datums,proj_statuss,proj_istenotajs,iepirkumi_kat,
IF(date_event_end='0000-00-00 00:00:00', date_event_start, date_event_end) as date_event_today
FROM
`jfik4_contentitem_tag_map`, `jfik4_content`, `extrainfo_1`
WHERE
jfik4_contentitem_tag_map.content_item_id = jfik4_content.id
AND
extrainfo_1.id = jfik4_content.id

GROUP BY jfik4_content.id





/////////////////////
//un tad varees


SELECT * FROM (

....


) as content

WHERE
date_event_today > '2015-09-26'
AND
date_event_today < '2015-09-30 23:59:59'