Модуль - Вывод объявления из Одной категории - MarketPlace

	$database->setQuery ( "SELECT a.id, a.category, a.ad_headline, a.ad_type, a.ad_image, date_format ( a.date_created, '%d.%m.%Y' ) AS af_date, b.name
							FROM #__marketplace_ads AS a, #__marketplace_categories AS b 
							WHERE b.published='1' AND a.category = b.id AND a.published='1'
							ORDER BY a.id DESC LIMIT 5 ");

$database->setQuery ( "SELECT a.id, a.category, a.ad_headline, a.ad_type, a.ad_image, date_format ( a.date_created, '%d.%m.%Y' ) AS af_date, b.name
							FROM #__marketplace_ads AS a, #__marketplace_categories AS b 
							WHERE b.published='1' AND b.id ='2' AND a.published='1' AND a.category='2'
							ORDER BY a.id DESC LIMIT 5 ");