SELECT
    SQL_NO_CACHE
    products.virtuemart_product_id AS product_id,
    products.main_picture AS product_thumb,
    products.product_sku AS product_sku,
    products.product_in_stock AS product_in_stock,
    products.is_new AS product_is_new,
    productsRU.product_s_desc AS product_s_desc,
    productsRU.product_name AS product_name,
    categoriesRU.virtuemart_category_id AS category_id,
    prices.product_price AS product_price,
    prices.product_override_price AS product_priceOverride,
    manufacturersRU.virtuemart_manufacturer_id AS mf_id,
    categoriesRU.category_name AS category_name,
    manufacturersRU.mf_name AS mf_name,
    manufacturersRU.slug AS mf_slug,

    (SELECT
        CONCAT(
            '[',
            GROUP_CONCAT(
                DISTINCT CONCAT(
                    '{',
                    '"id":"',
                    `a`.`virtuemart_category_id`,
                    '",',
                    '"name":"',
                    `b`.`category_name`,
                    '"}'
                )
            ),
            ']'
        )
    	FROM u1weg_virtuemart_product_categories AS `a`
	    	INNER JOIN u1weg_virtuemart_categories_ru_ru AS `b`
			ON (
			     `a`.`virtuemart_category_id` = `b`.`virtuemart_category_id`
			   )
    	WHERE `a`.virtuemart_product_id = products.virtuemart_product_id
    ) AS product_categories,

    (SELECT
        CONCAT(
            '[',
            GROUP_CONCAT(
                DISTINCT CONCAT(
                    '{',
                    '"id":"', `a`.`virtuemart_custom_id`, '",',
                    '"rest":"', `a`.`rest`, '",',
                    '"value":"', `a`.`custom_value`, '"}'
                )
            ),
            ']'
        )
    	FROM u1weg_virtuemart_product_customfields AS `a`
    	WHERE `a`.virtuemart_product_id = products.virtuemart_product_id
    ) AS custom_attributes,

    (SELECT
    	CONCAT(
            '[',
            GROUP_CONCAT(
                DISTINCT CONCAT(
                    '{',
                    '"product_id":"', `a`.`ProductId`, '",',
                    '"discount_type":"', `a`.`TypeDiscount`, '",',
                    '"discount_value":"', `a`.`ValueDiscount`, '"}'
                )
            ),
            ']'
        )
    	FROM `shop_productOFday` AS `a`
    	WHERE `a`.`ProductId` = `products`.`virtuemart_product_id`
    		  AND (`a`.Time_start < '1571383267' AND `a`.Time_finish > '1571383267')
    ) AS product_of_day
FROM
    u1weg_virtuemart_products AS products
INNER JOIN u1weg_virtuemart_products_ru_ru AS productsRU
ON
    (
        `products`.`virtuemart_product_id` = `productsRU`.`virtuemart_product_id`
    )
INNER JOIN u1weg_virtuemart_product_categories AS productCAT
ON
    (
        `products`.`virtuemart_product_id` = `productCAT`.`virtuemart_product_id`
    )
INNER JOIN u1weg_virtuemart_categories_ru_ru AS categoriesRU
ON
    (
        `productCAT`.`virtuemart_category_id` = `categoriesRU`.`virtuemart_category_id`
    )
INNER JOIN u1weg_virtuemart_product_prices AS prices
ON
    (
        `products`.`virtuemart_product_id` = `prices`.`virtuemart_product_id`
    )
INNER JOIN u1weg_virtuemart_product_manufacturers AS productMF
ON
    (
        `products`.`virtuemart_product_id` = `productMF`.`virtuemart_product_id`
    )
INNER JOIN u1weg_virtuemart_manufacturers_ru_ru AS manufacturersRU
ON
    (
        `productMF`.`virtuemart_manufacturer_id` = `manufacturersRU`.`virtuemart_manufacturer_id`
    )
WHERE
    (products.published = '1') AND(products.product_in_stock > 0) AND(
        `productCAT`.`virtuemart_category_id` = '60'
    )
ORDER BY
    `products`.`is_new` DESC, `products`.`virtuemart_product_id` DESC
LIMIT 0, 36