Error SQL:
QUERY:
SELECT SQL_CACHE productprice_subdomain.total_price,catalog.id, catalog.parent, catalog.text_name, catalog.text_shortname, catalog.text_value, catalog.pselect_catalog_main, catalog.text_code,
catalog.text_articul, catalog.img_img, catalog.text_price, catalog.text_delivery, catalog.check2_call_us,
catalog.check2_new, catalog.check2_recommend, catalog.check2_promo, catalog.check2_stock, catalog.check2_wait,
catalog.check2_na_sklade, catalog.pselect_series, catalog.pselect_types, catalog.text_custom_name,
catalog.pselect_productgroups, catalog.text_height, catalog.text_width, catalog.text_length,
catalog.text_diameter, catalog.text_countertop_height, catalog.text_weight, catalog.text_vote,catalog.loop_body,
series.text_name AS series_name,
country.text_name AS country_name, country.img_img AS country_img,
color.id AS color_id, color.text_name AS color_name, color.text_secondname AS color_secondname,
color.img_img AS color_img, colortype.text_name AS color_group
FROM `alfa_ru_catalog` AS catalog
LEFT JOIN `alfa_ru_catalog_cat` AS catalog_cat
ON catalog_cat.parent = catalog.id
LEFT JOIN `alfa_ru_series` AS series
ON series.id = catalog.pselect_series
LEFT JOIN `alfa_ru_country` AS country
ON country.id = catalog.pselect_country
LEFT JOIN `alfa_ru_colors` AS color
ON color.id = catalog.pselect_colors
LEFT JOIN `alfa_ru_colortype` AS colortype
ON color.pselect_colortype = colortype.id
WHERE catalog.check_active = 1
AND catalog_cat.text_name = 58
GROUP BY catalog.id
ORDER BY catalog_cat.ord
LIMIT 0,60
MYSQL Error:
Unknown column 'productprice_subdomain.total_price' in 'field list'