запрос к бд, в одном месте работает в другом нет.[РЕШЕНО]
есть вот такой запрос сформированый через views:
node_data_field_time_order.field_time_order_value AS node_data_field_time_order_field_time_order_value,
node_data_field_time_order.field_time_order_value2 AS node_data_field_time_order_field_time_order_value2,
node.type AS node_type,
node.vid AS node_vid
FROM node node
INNER JOIN content_type_order node_data_field_sauna_number ON node.vid = node_data_field_sauna_number.vid
LEFT JOIN content_type_order node_data_field_time_order ON node.vid = node_data_field_time_order.vid
WHERE ((node.type IN ('order')) AND (node_data_field_sauna_number.field_sauna_number_value = '11'))
Он работает везде, и во вьевс чтото возвращает и в phpmyadmin, и просто в файле(те нода с форматом ввода php)
и есть вот такой
node_data_field_time_order.field_time_order_value AS node_data_field_time_order_field_time_order_value,
node_data_field_time_order.field_time_order_value2 AS node_data_field_time_order_field_time_order_value2,
node.type AS node_type,
node.vid AS node_vid
FROM node node
INNER JOIN content_type_order node_data_field_sauna_number ON node.vid = node_data_field_sauna_number.vid
LEFT JOIN content_type_order node_data_field_time_order ON node.vid = node_data_field_time_order.vid
WHERE ((node.type IN ('order')) AND (node_data_field_sauna_number.field_sauna_number_value = '11'))