defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );
global $database;
if( !isset($_GET['lang']) ){ $lang = 'es'; }else{ $lang = $_GET['lang']; }
$Qproduc = "
SELECT `prod`.`prod_id`, `prod`.`prod_name`, `prod`.`prod_Prod`, `prod`.`prod_Pres`, `prod`.`prod_desc`, `pdf`,`prod`.`prod_desc_en`, `prod`.`prod_img1`
FROM `#__kat_producto` AS `prod`, `#__kat_xref` AS `xref`
WHERE `xref`.`cat_id` = ".$_GET['cat']."
AND `prod`.`prod_publish` =1 ";
if( isset($_GET['prod']) ){
$Qproduc = $Qproduc." AND `prod`.`prod_id` = ".$_GET['prod'];
}
$Qproduc = $Qproduc." AND `prod`.`prod_id` = `xref`.`prod_id`";
$database->setQuery($Qproduc);
$productoa = $database->loadObjectList();
$Qcats = "SELECT `cat_id`, `cat_desc`, `cat_desc_en`, `cat_subcat` FROM `#__kat_categoria`
WHERE `cat_publish` = '1' ORDER BY `cat_id` ASC";
$database->setQuery($Qcats);
$categs = $database->loadObjectList();
?>