[решено] Критерий сортировки views со своей таблицы
Добрый день.
Помогите программно исправить запрос views
SELECT node.nid AS nid,
node.type AS node_type,
node.title AS node_title,
node_data_field_old_price.field_old_price_value AS node_data_field_old_price_field_old_price_value,
node.vid AS node_vid,
uc_products.sell_price AS uc_products_sell_price,
node_data_field_old_price.field_image_cache_fid AS node_data_field_old_price_field_image_cache_fid,
node_data_field_old_price.field_image_cache_list AS node_data_field_old_price_field_image_cache_list,
node_data_field_old_price.field_image_cache_data AS node_data_field_old_price_field_image_cache_data,
node.sticky AS node_sticky,
node.created AS node_created
FROM node node
node.type AS node_type,
node.title AS node_title,
node_data_field_old_price.field_old_price_value AS node_data_field_old_price_field_old_price_value,
node.vid AS node_vid,
uc_products.sell_price AS uc_products_sell_price,
node_data_field_old_price.field_image_cache_fid AS node_data_field_old_price_field_image_cache_fid,
node_data_field_old_price.field_image_cache_list AS node_data_field_old_price_field_image_cache_list,
node_data_field_old_price.field_image_cache_data AS node_data_field_old_price_field_image_cache_data,
node.sticky AS node_sticky,
node.created AS node_created
FROM node node