Lending Products
user warning: Unknown column 'node_data_field_effective_date_field_effective_date_value' in 'order clause'
query: SELECT DISTINCT(node.nid), node_data_field_lending_weight.field_lending_weight_value AS node_data_field_lending_weight_field_lending_weight_value, node_data_field_lend_prod_type.field_lend_prod_type_value AS node_data_field_lend_prod_type_field_lend_prod_type_value, node.title AS node_title, node.changed AS node_changed, node_data_field_apr.field_apr_value AS node_data_field_apr_field_apr_value FROM node node LEFT JOIN content_type_lending_product node_data_field_lend_prod_type ON node.vid = node_data_field_lend_prod_type.vid LEFT JOIN content_type_lending_product node_data_field_lending_weight ON node.vid = node_data_field_lending_weight.vid LEFT JOIN content_field_apr node_data_field_apr ON node.vid = node_data_field_apr.vid LEFT JOIN content_field_effective_date node_data_field_effective_date ON node.vid = node_data_field_effective_date.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'simple_access') OR (na.gid = 0 AND na.realm = 'simple_access_author'))) AND ( (node.status = '1') AND (node_data_field_lend_prod_type.field_lend_prod_type_value IN ('personalloan','autoloan','creditcard')) ) ORDER BY node_data_field_lending_weight_field_lending_weight_value ASC, node_data_field_lend_prod_type_field_lend_prod_type_value ASC, node_title ASC, node_data_field_effective_date_field_effective_date_value ASC LIMIT 0, 20 in /var/www/html/pf-5/includes/database.mysqli.inc on line 169.
