|
HI
The below query was working fine and then it stopped displaying data in the aridatatable module.
SELECT order_item_name AS 'Class', order_item_sku AS 'Code', firstname, lastname, phone, order_payment_status as PMT, IF(LENGTH(Product_Attribute)=0, 'Full Term', Product_Attribute) AS 'Option', IF(LENGTH(table1.data_txt)=0, 'NA',table1.data_txt) As 'Org', IF(LENGTH(table2.data_txt)=0, 'NA',table2.data_txt) As 'Term', IF(LENGTH(table3.data_txt)=0, 'NA',table3.data_txt) As 'Year', IF(LENGTH(table4.data_txt)=0, 'NA',table4.data_txt) As 'Instructor'
FROM #__redshop_order_item, #__redshop_users_info, #__redshop_fields_data As table1, #__redshop_fields_data As table2, #__redshop_fields_data As table3, #__redshop_fields_data As table4, #__redshop_orders, #__redshop_product_category_xref
WHERE #__redshop_product_category_xref.category_id Not In (30,22,29) and #__redshop_order_item.user_info_id = #__redshop_users_info.users_info_id and table1.itemid = #__redshop_order_item.product_id and table2.itemid = #__redshop_order_item.product_id and table3.itemid = #__redshop_order_item.product_id and table4.itemid = #__redshop_order_item.product_id and #__redshop_orders.order_id = #__redshop_order_item.order_id and #__redshop_order_item.product_id = #__redshop_product_category_xref.product_id and table1.fieldid=22 and table2.fieldid=29 and table3.fieldid=27 and table4.fieldid=28 and LENGTH(#__redshop_order_item.product_attribute) = 0
GROUP BY #__redshop_order_item.order_item_id
UNION ALL
SELECT order_item_name AS 'Class', order_item_sku AS 'Code', firstname, lastname, phone, order_payment_status as PMT, section_name AS 'Option', IF(LENGTH(table1.data_txt)=0, 'NA',table1.data_txt) As 'Org', IF(LENGTH(table2.data_txt)=0, 'NA',table2.data_txt) As 'Term', IF(LENGTH(table3.data_txt)=0, 'NA',table3.data_txt) As 'Year', IF(LENGTH(table4.data_txt)=0, 'NA',table4.data_txt) As 'Instructor'
FROM #__redshop_order_item, #__redshop_users_info, #__redshop_fields_data As table1, #__redshop_fields_data As table2, #__redshop_fields_data As table3, #__redshop_fields_data As table4, #__redshop_orders, #__redshop_product_category_xref, #__redshop_order_attribute_item
WHERE #__redshop_product_category_xref.category_id Not In (30,22,29) and #__redshop_order_item.user_info_id = #__redshop_users_info.users_info_id and table1.itemid = #__redshop_order_item.product_id and #__redshop_order_attribute_item.order_item_id = #__redshop_order_item.order_item_id and table2.itemid = #__redshop_order_item.product_id and table3.itemid = #__redshop_order_item.product_id and table4.itemid = #__redshop_order_item.product_id and #__redshop_orders.order_id = #__redshop_order_item.order_id and #__redshop_order_item.product_id = #__redshop_product_category_xref.product_id and table1.fieldid=22 and table2.fieldid=29 and table3.fieldid=27 and table4.fieldid=28 and LENGTH(#__redshop_order_item.product_attribute) <> 0 and #__redshop_order_attribute_item.section = 'property'
GROUP BY #__redshop_order_item.order_item_id
If if remove one of the columns than page is displayed correctly. Is there a limit on the number of columns.
The total number of records is only 146.
Thanks for your assistance
|
