SELECT
    SQL_NO_CACHE
    products.virtuemart_product_id AS product_id,
    products.main_picture AS product_thumb,
    products.main_category AS product_main_category,
    products.product_sku AS product_sku,
    products.product_in_stock AS product_in_stock,
    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,
    prOfDay.ProductId AS pod_product_id,
    prOfDay.TypeDiscount AS pod_TypeDiscount,
    prOfDay.ValueDiscount AS pod_ValueDiscount,
    prOfDay.DateShow_start AS pod_DateShow_start,
    prOfDay.DateShow_finish AS pod_DateShow_finish,
    prOfDay.Time_start AS pod_Time_start,
    prOfDay.Time_finish AS pod_Time_finish,
    IF(
        `productCAT`.`virtuemart_category_id` IS NOT NULL,
        CONCAT(
            '[',
            GROUP_CONCAT(
                DISTINCT CONCAT(
                    '{',
                    '"id":"',
                    `productCAT`.`virtuemart_category_id`,
                    '",',
                    '"name":"',
                    `categoriesRU`.`category_name`,
                    '"}'
                )
            ),
            ']'
        ),
        '[]'
    ) AS product_categories,
    IF(
        `productCustom`.`virtuemart_product_id` IS NOT NULL,
        CONCAT(
            '[',
            GROUP_CONCAT(
                DISTINCT CONCAT(
                    '{',
                    '"id":"',
                    productCustom.virtuemart_custom_id,
                    '",',
                    /*'"rest":"', productCustom.rest, '",',*/ '"value":"',
                    productCustom.custom_value,
                    '"}'
                )
            ),
            ']'
        ),
        '[]'
    ) AS custom_attributes
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_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`
    )
LEFT JOIN u1weg_virtuemart_product_customfields AS productCustom
ON
    (
        `products`.`virtuemart_product_id` = `productCustom`.`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_manufacturers_ru_ru AS manufacturersRU
ON
    (
        `productMF`.`virtuemart_manufacturer_id` = `manufacturersRU`.`virtuemart_manufacturer_id`
    )
LEFT JOIN shop_productOFday AS prOfDay
ON
    (
        `products`.virtuemart_product_id = `prOfDay`.ProductId AND(
            `prOfDay`.Time_start < '1573669709' AND `prOfDay`.Time_finish > '1573669709'
        )
    )
WHERE
    (products.published = '1') AND(products.product_in_stock > 0) AND(
        `categoriesRU`.`virtuemart_category_id` = '60'
    )
GROUP BY
    `products`.`virtuemart_product_id`
ORDER BY
    `products`.`virtuemart_product_id`
DESC
LIMIT 0, 36