Čajna plantaža Ging se nazaja v zahodni dolini Darjeelinga. Obsega 253 hektarjev čajevcev in sega... več >>
KENYA ESTATE AA
Kenya Coffee Board že leta spodbuja manjše pridelovalce k boljši kakovosti. Rezultat je konstantna... več >>
SELECT
msg.id_message AS id,
msg.title AS msgTitle,
msg.abstract,
msg.date_time_message
, r.title AS rubricTitle
FROM msg
LEFT JOIN msg_rubric_data r ON r.id_msg_rubric = msg.id_msg_rubric AND r.global_languages_code = 'slo'
WHERE msg.date_time_publish <= NOW()
AND (msg.date_time_withdrawal >= NOW() OR msg.date_time_withdrawal IS NULL)
AND msg.global_languages_code = 'slo'
AND (0 OR msg.id_msg_rubric = '2009061213504999')
ORDER BY msg.date_time_message DESC
LIMIT 2
