• user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND term_data.vid = 3 AND field_date1_priority_value = 1 AND field_cours' at line 14 query: SELECT * FROM ((SELECT node.nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date1_value AS timestamp, field_date1_priority_value AS priority, field_hot_value, field_new_value, users.name AS user, 1 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_date1_priority_value = 1 AND field_course_date1_value != "" OR field_course_date1_value != NULL AND node.status = 1 )UNION(SELECT node.nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date2_value AS timestamp, field_date2_priority_value AS priority, field_hot_value, field_new_value, users.name AS user, 2 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_date2_priority_value = 1 AND field_course_date2_value != "" OR field_course_date2_value != NULL AND node.status = 1 )UNION(SELECT node.nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date3_value AS timestamp, field_date3_priority_value AS priority, field_hot_value, field_new_value, users.name AS user, 3 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_date3_priority_value = 1 AND field_course_date3_value != "" OR field_course_date3_value != NULL AND node.status = 1 )UNION(SELECT node.nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date4_value AS timestamp, field_date4_priority_value AS priority, field_hot_value, field_new_value, users.name AS user, 4 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_date4_priority_value = 1 AND field_course_date4_value != "" OR field_course_date4_value != NULL AND node.status = 1 )UNION(SELECT node.nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date5_value AS timestamp, field_date5_priority_value AS priority, field_hot_value, field_new_value, users.name AS user, 5 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_date5_priority_value = 1 AND field_course_date5_value != "" OR field_course_date5_value != NULL AND node.status = 1 )UNION(SELECT node.nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date6_value AS timestamp, field_date6_priority_value AS priority, field_hot_value, field_new_value, users.name AS user, 6 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_date6_priority_value = 1 AND field_course_date6_value != "" OR field_course_date6_value != NULL AND node.status = 1 )UNION(SELECT nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date1_value AS timestamp, field_date1_priority_value, field_hot_value, field_new_value, users.name AS user, 1 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_course_date1_value != "" OR field_course_date1_value != NULL AND field_date1_priority_value != 1 AND node.status = 1 )UNION(SELECT nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date2_value AS timestamp, field_date2_priority_value, field_hot_value, field_new_value, users.name AS user, 2 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_course_date2_value != "" OR field_course_date2_value != NULL AND field_date2_priority_value != 1 AND node.status = 1 )UNION(SELECT nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date3_value AS timestamp, field_date3_priority_value, field_hot_value, field_new_value, users.name AS user, 3 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_course_date3_value != "" OR field_course_date3_value != NULL AND field_date3_priority_value != 1 AND node.status = 1 )UNION(SELECT nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date4_value AS timestamp, field_date4_priority_value, field_hot_value, field_new_value, users.name AS user, 4 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_course_date4_value != "" OR field_course_date4_value != NULL AND field_date4_priority_value != 1 AND node.status = 1 )UNION(SELECT nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date5_value AS timestamp, field_date5_priority_value, field_hot_value, field_new_value, users.name AS user, 5 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_course_date5_value != "" OR field_course_date5_value != NULL AND field_date5_priority_value != 1 AND node.status = 1 )UNION(SELECT nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date6_value AS timestamp, field_date6_priority_value, field_hot_value, field_new_value, users.name AS user, 6 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_course_date6_value != "" OR field_course_date6_value != NULL AND field_date6_priority_value != 1 AND node.status = 1 )) as jj ORDER BY priority DESC, timestamp ASC in /var/www/html/sg/modules/learningdb/view_course_col.inc on line 390.
  • warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/html/sg/modules/learningdb/view_course_col.inc on line 390.
  • user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND term_data.vid = 3 AND field_date1_priority_value = 1 AND field_cours' at line 14 query: SELECT COUNT(*) FROM ((SELECT node.nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date1_value AS timestamp, field_date1_priority_value AS priority, field_hot_value, field_new_value, users.name AS user, 1 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_date1_priority_value = 1 AND field_course_date1_value != "" OR field_course_date1_value != NULL AND node.status = 1 )UNION(SELECT node.nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date2_value AS timestamp, field_date2_priority_value AS priority, field_hot_value, field_new_value, users.name AS user, 2 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_date2_priority_value = 1 AND field_course_date2_value != "" OR field_course_date2_value != NULL AND node.status = 1 )UNION(SELECT node.nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date3_value AS timestamp, field_date3_priority_value AS priority, field_hot_value, field_new_value, users.name AS user, 3 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_date3_priority_value = 1 AND field_course_date3_value != "" OR field_course_date3_value != NULL AND node.status = 1 )UNION(SELECT node.nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date4_value AS timestamp, field_date4_priority_value AS priority, field_hot_value, field_new_value, users.name AS user, 4 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_date4_priority_value = 1 AND field_course_date4_value != "" OR field_course_date4_value != NULL AND node.status = 1 )UNION(SELECT node.nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date5_value AS timestamp, field_date5_priority_value AS priority, field_hot_value, field_new_value, users.name AS user, 5 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_date5_priority_value = 1 AND field_course_date5_value != "" OR field_course_date5_value != NULL AND node.status = 1 )UNION(SELECT node.nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date6_value AS timestamp, field_date6_priority_value AS priority, field_hot_value, field_new_value, users.name AS user, 6 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_date6_priority_value = 1 AND field_course_date6_value != "" OR field_course_date6_value != NULL AND node.status = 1 )UNION(SELECT nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date1_value AS timestamp, field_date1_priority_value, field_hot_value, field_new_value, users.name AS user, 1 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_course_date1_value != "" OR field_course_date1_value != NULL AND field_date1_priority_value != 1 AND node.status = 1 )UNION(SELECT nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date2_value AS timestamp, field_date2_priority_value, field_hot_value, field_new_value, users.name AS user, 2 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_course_date2_value != "" OR field_course_date2_value != NULL AND field_date2_priority_value != 1 AND node.status = 1 )UNION(SELECT nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date3_value AS timestamp, field_date3_priority_value, field_hot_value, field_new_value, users.name AS user, 3 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_course_date3_value != "" OR field_course_date3_value != NULL AND field_date3_priority_value != 1 AND node.status = 1 )UNION(SELECT nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date4_value AS timestamp, field_date4_priority_value, field_hot_value, field_new_value, users.name AS user, 4 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_course_date4_value != "" OR field_course_date4_value != NULL AND field_date4_priority_value != 1 AND node.status = 1 )UNION(SELECT nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date5_value AS timestamp, field_date5_priority_value, field_hot_value, field_new_value, users.name AS user, 5 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_course_date5_value != "" OR field_course_date5_value != NULL AND field_date5_priority_value != 1 AND node.status = 1 )UNION(SELECT nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date6_value AS timestamp, field_date6_priority_value, field_hot_value, field_new_value, users.name AS user, 6 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_course_date6_value != "" OR field_course_date6_value != NULL AND field_date6_priority_value != 1 AND node.status = 1 )) as jj in /var/www/html/sg/modules/learningdb/view_course_col.inc on line 394.
  • user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND term_data.vid = 3 AND field_date1_priority_value = 1 AND field_cours' at line 14 query: SELECT * FROM ((SELECT node.nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date1_value AS timestamp, field_date1_priority_value AS priority, field_hot_value, field_new_value, users.name AS user, 1 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_date1_priority_value = 1 AND field_course_date1_value != "" OR field_course_date1_value != NULL AND node.status = 1 )UNION(SELECT node.nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date2_value AS timestamp, field_date2_priority_value AS priority, field_hot_value, field_new_value, users.name AS user, 2 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_date2_priority_value = 1 AND field_course_date2_value != "" OR field_course_date2_value != NULL AND node.status = 1 )UNION(SELECT node.nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date3_value AS timestamp, field_date3_priority_value AS priority, field_hot_value, field_new_value, users.name AS user, 3 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_date3_priority_value = 1 AND field_course_date3_value != "" OR field_course_date3_value != NULL AND node.status = 1 )UNION(SELECT node.nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date4_value AS timestamp, field_date4_priority_value AS priority, field_hot_value, field_new_value, users.name AS user, 4 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_date4_priority_value = 1 AND field_course_date4_value != "" OR field_course_date4_value != NULL AND node.status = 1 )UNION(SELECT node.nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date5_value AS timestamp, field_date5_priority_value AS priority, field_hot_value, field_new_value, users.name AS user, 5 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_date5_priority_value = 1 AND field_course_date5_value != "" OR field_course_date5_value != NULL AND node.status = 1 )UNION(SELECT node.nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date6_value AS timestamp, field_date6_priority_value AS priority, field_hot_value, field_new_value, users.name AS user, 6 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_date6_priority_value = 1 AND field_course_date6_value != "" OR field_course_date6_value != NULL AND node.status = 1 )UNION(SELECT nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date1_value AS timestamp, field_date1_priority_value, field_hot_value, field_new_value, users.name AS user, 1 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_course_date1_value != "" OR field_course_date1_value != NULL AND field_date1_priority_value != 1 AND node.status = 1 )UNION(SELECT nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date2_value AS timestamp, field_date2_priority_value, field_hot_value, field_new_value, users.name AS user, 2 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_course_date2_value != "" OR field_course_date2_value != NULL AND field_date2_priority_value != 1 AND node.status = 1 )UNION(SELECT nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date3_value AS timestamp, field_date3_priority_value, field_hot_value, field_new_value, users.name AS user, 3 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_course_date3_value != "" OR field_course_date3_value != NULL AND field_date3_priority_value != 1 AND node.status = 1 )UNION(SELECT nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date4_value AS timestamp, field_date4_priority_value, field_hot_value, field_new_value, users.name AS user, 4 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_course_date4_value != "" OR field_course_date4_value != NULL AND field_date4_priority_value != 1 AND node.status = 1 )UNION(SELECT nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date5_value AS timestamp, field_date5_priority_value, field_hot_value, field_new_value, users.name AS user, 5 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_course_date5_value != "" OR field_course_date5_value != NULL AND field_date5_priority_value != 1 AND node.status = 1 )UNION(SELECT nid, tid, title, sell_price, term_data.name, uid, field_course_duration_value AS duration, field_course_duration_context_value AS duration_context, field_course_date6_value AS timestamp, field_date6_priority_value, field_hot_value, field_new_value, users.name AS user, 6 AS query_no FROM node LEFT JOIN uc_products USING (nid) LEFT JOIN content_type_courses USING (nid) LEFT JOIN term_node USING (nid) LEFT JOIN term_data USING (tid) LEFT JOIN users USING (uid) WHERE node.type = "courses" AND uid = AND term_data.vid = 3 AND field_course_date6_value != "" OR field_course_date6_value != NULL AND field_date6_priority_value != 1 AND node.status = 1 )) as jj ORDER BY priority DESC, timestamp ASC LIMIT 0, 20 in /var/www/html/sg/modules/learningdb/view_course_col.inc on line 394.

View By Columns Preview

Courses Fee Category Trainer Date Duration

No records found