SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROMjoomla_extensionsWHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1,5)
ORDERBY ordering

SELECT F.id, F.`name_ru-RU` as name, F.`description_ru-RU` as description, F.allcats, F.type, F.cats, F.ordering, F.` group`, G.`name_ru-RU` as groupname, multilist FROM `joomla_jshopping_products_extra_fields` as F left join `joomla_jshopping_products_extra_field_groups` as G on G.id=F. group order by G.ordering, F.ordering

SELECT count(*) FROM `joomla_jshopping_products_to_categories` AS pr_cat
INNERJOIN `joomla_jshopping_products` AS prod ON pr_cat.product_id = prod.product_id
WHERE pr_cat.category_id=10 AND prod.product_publish=1 AND prod.access IN (1,1,5)