druid.underground: Блог

Главные вкладки

[решено] Критерий сортировки views со своей таблицы

6 декабря 2011 в 13:25

Добрый день.
Помогите программно исправить запрос 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