Povpraševanje


8 + 3 =

Čokoladne novice

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

Mediji o nas

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 = '2013093008365923')
				ORDER BY msg.date_time_message DESC
				LIMIT 2