unreleased2

SELECT SQL_CALC_FOUND_ROWS
    prod.products_id AS products_id,
    prod.description_full_type AS description_full_type,
    prod.uniq_desc_type AS uniq_desc_type,
    prod.manual_sort AS manual_sort,
    prod.product_name AS product_name,
    prod.rating_manual AS rating_manual,
    prod.product_name_dop AS product_name_dop,
    prod.title_full AS title_full,
    prod.meta_title AS meta_title,
    prod.meta_desc AS meta_desc,
    prod.products_price AS products_price,
    prod.sales_price AS sales_price,
    prod.model AS model,
    prod.model_seo AS model_seo,
    prod.popular AS popular,
    prod.zvanie AS zvanie,
    prod.products_sort_order AS products_sort_order,
    prod.product_status AS product_status,
    prod.date_prihod AS date_prihod,
    prod.date_added AS date_added,
    prod.last_modified AS last_modified,
    prod.edited AS edited,
    prod.url AS url,
    prod.categories_id AS categories_id,
    prod.amount AS amount,
    prod.product_new_version AS product_new_version,
    prod.vendor_code AS vendor_code,
    prod.type_prefix AS type_prefix,
    cprod.product_name AS zamena_to_value,
    modf.product_name AS product_modification_name,
    manf.manufacturers_name AS manf_name,
    manf.manufacturers_id AS manufacturers_id,
    prod.available AS available,
    IF(INSTR(prod.product_name, 'для'),
        1,
        0) AS for_product,
    prs.is_optimized_preliminary AS is_optimized_preliminary,
    prs.is_optimized_final AS is_optimized_final,
    prs.is_optimized_additional AS is_optimized_additional,
    prs.sape_status AS sape_status,
    prs.sape_date AS sape_date,
    prs.mark_description AS mark_description,
    prs.mark_description_last_upd AS mark_description_last_upd,
    prs.mark_photo AS mark_photo,
    prs.mark_photo_last_upd AS mark_photo_last_upd,
    prs.mark_specs AS mark_specs,
    prs.mark_specs_last_upd AS mark_specs_last_upd,
    prs.mark_video AS mark_video,
    prs.mark_video_last_upd AS mark_video_last_upd,
    prs.mark_instr AS mark_instr,
    prs.mark_instr_last_upd AS mark_instr_last_upd,
    prs.mark_analog AS mark_analog,
    prs.mark_analog_last_upd AS mark_analog_last_upd,
    prs.mark_tying AS mark_tying,
    prs.mark_tying_last_upd AS mark_tying_last_upd,
    prs.sum_frequency AS sum_frequency,
    prs.max_frequency AS max_frequency,
    series.title AS series_title,
    lc.man_id AS create_man_id,
    CONCAT_WS(' ', cm.firstname, cm.lastname) AS create_man_name,
    products.to_1c AS to_1c,
    prod.products_model AS products_model,
    prod.yandex_kart AS yandex_kart,
    products.id1c AS id1c,
    products.zak_price AS zak_price,
    products.reliz_firm_id AS reliz_firm_id,
    products.yandex_price AS yandex_price,
    products.products_date_inven AS products_date_inven,
    products.products_weight AS products_weight,
    p_sklad.date_last_prihod AS products_last_prihod,
    pd_buy.date AS products_date_last_buy,
    pd_reliz.date AS products_date_last_reliz
FROM
    default_crm.sotm_products AS prod
        INNER JOIN
    products as p ON prod.products_id = p.products_id
        LEFT JOIN
    default_crm.sotm_products AS cprod ON (cprod.products_id = prod.zamena_to)
        LEFT JOIN
    default_crm.sotm_products AS modf ON (modf.products_id = prod.product_new_version)
        LEFT JOIN
    default_crm.sotm_manufacturers AS manf ON (manf.manufacturers_id = prod.manufacturers_id)
        LEFT JOIN
    default_crm.sotm_product_service_info AS prs ON (prs.product_id = prod.products_id)
        LEFT JOIN
    default_crm.products AS products ON (products.products_id = prod.products_id)
        LEFT JOIN
    default_crm.products_sklad AS p_sklad ON (p_sklad.id1c = products.id1c AND p_sklad.option_id = 0 AND p_sklad.sklad = '000000001')
        LEFT JOIN
    default_crm.products_dates AS pd_reliz ON (pd_reliz.id1c = products.id1c AND pd_reliz.field = 'last_reliz')
        LEFT JOIN
    default_crm.products_dates AS pd_buy ON (pd_buy.id1c = products.id1c AND pd_buy.field = 'last_buy')
        LEFT JOIN
    default_crm.sotm_product AS sprod ON sprod.product_id = prod.products_id
        LEFT JOIN
    default_crm.sotm_product_series AS series ON series.series_id = sprod.series_id
        LEFT JOIN
    default_crm.log_content AS lc ON prod.products_id = lc.target_id AND lc.action = 'create_product'
        LEFT JOIN
    default_crm.managers AS cm ON lc.man_id = cm.man_id
WHERE
    prod.categories_id = 11 AND (prod.product_status NOT IN ('deleted')) AND 0 = 0 AND prod.product_status = 'unreleased'
ORDER BY prod.manual_sort DESC
LIMIT 0 , 30