select prod_cat as "категория товара",
trademark as "производитель",
prod_name as "наименование товара",
descr as "описание товара",
concat("") as "цена розн.; грн.",
prod_price as "цена розн.; $",
concat("") as "цена опт.; $",
concat("от производителя") as "гарантия",
concat("ждет Вас") as "наличие",
url as "ссылка"


from

( select 
cat.category_name as trademark ,
cat.category_id as trademark_id, 
prod.product_id as prod_id, 
prod.product_name as prod_name,
prod.product_desc as descr,
price.product_price as prod_price,
concat('http://itishop.com.ua/index.php?page=shop.product_details&flypage=flypage.tpl&product_id=', prod.product_id,'&category_id=',cat.category_id,'&option=com_virtuemart&Itemid=1') as url,
(select jos_vm_category.category_name from jos_vm_category, jos_vm_category_xref where jos_vm_category.category_id=jos_vm_category_xref.category_parent_id and jos_vm_category_xref.category_child_id=trademark_id) as prod_cat

from 
jos_vm_category as cat,
jos_vm_product_category_xref as xref,
jos_vm_product as prod,
jos_vm_product_price as price

where 
cat.category_id=xref.category_id
and
prod.product_id=xref.product_id
and 
prod.product_publish="Y" 
and 
price.product_id=prod.product_id ) as GL