Notice: Error: Unknown column 'p.date' in 'order clause'
Error No: 1054
SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' GROUP BY p.product_id ORDER BY p.date DESC, LCASE(pd.name) DESC LIMIT 0,2 in /var/www/name-story.com/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/name-story.com/public_html/catalog/model/catalog/product.php on line 246Warning: Invalid argument supplied for foreach() in /var/www/name-story.com/public_html/catalog/model/catalog/product.php on line 246Notice: Error: Unknown column 'p.date' in 'order clause'
Error No: 1054
SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' GROUP BY p.product_id ORDER BY p.date DESC, LCASE(pd.name) DESC LIMIT 0,2 in /var/www/name-story.com/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /var/www/name-story.com/public_html/catalog/model/catalog/product.php on line 246Warning: Invalid argument supplied for foreach() in /var/www/name-story.com/public_html/catalog/model/catalog/product.php on line 246� �}}wE�����q��Z���v��b� w�{Br7�}�=��H[�H3bfdǼ��!7�&�
�X �%�$���%���_�˨G�ы#ű��n$��tWWWU����jz磇<��Ïiy�XH���?m�iO<�Lzz�ӆ�3瞉���>
����3��X�sbZA��gb1-[�]w&f�b��Ov��d���=�M�~a�'�MT2����t;�7�\zǎ�;�/���AUk����-ϰ<ʹ��c,�ƢV��
jY�d�hx:J�%��fb��T�)Ĕ"Y^�L,�y��drqq1a�E#�z�����Ťi��R���c�=c���Y/Yԭ��ʎ�'۶�^������z�J��7��-��ƙʫ�WO�����Z�����o��v�*�gWoݪ�~�r��ڗW��^�u���M�-Hn'��7�%ϴ-�ǧ�It��[[?q����ʵ3�3�����o7�VZ��r�v�����ک˫�^����WY� �Ї��߮~s~��s�k�^^[>�v�'�b�֗�7o�}�����Y��v�����ͯ�'OY���Km;s�XZ����V�c>��U�AQ���V�zc���p�ӏ�'��h�6��,B�B�&ar#��IfuO/��I��N���ҷم����|'-{K%���.��p��<2�xE���ɣ%�#*x�f����HU�32�y�yÜ�{�ӣ!O����ټ7��S���E�H�1#Q��F�L�#k�ُaX�3�B���c&Siڸ�l�\���������%�33��>�xl��A4j`& ]�t��r����ʅ��Hk�>Q{���$��kFw
-�s�FE�US���}0�<0]0�c�.)�Ě�Q}A�&!��!�̺n���
F�b�cfb췛7���f&��=*�����5���Ģ�;�l�p���#>�Hῢi%��R��:�������v�Zƶ=�s�R��l���9��닆k���z�5�1{��T�1��t�=_0���I�><����̡�a��n�S{GF��s: