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���d��q.�g,�r�gl1Lg8g��N�{�,˫%��N�n�ݲck9$�<� �d 3!�BH�]�X��_��vUu�Z��Ö�:23�T]]�k�~U�{墳O9��_�R�N>��3�7}N�U�>�|rj�s���g��F�ʸ�kT]���t$�X%�sӑ��Ω�=ѵ�H����?r��┉����?}h��d�����$����=�<�����_�_q��V�H=h�f8�n(K����iԳ��T^sT�0��,NG̹ɢ��HUҼ��H�q
�����B�P�Z�vLk1�6�q��h'c�l�q�,:�4���N<��Y5�-
�7��ѝ�V���y����go�/,U~x������g.���
�t�V��7k������Ko\)�}�����{gW�_,xOyY��
%�N[z��M���(y?F�V�N]��{�t�\���l��;5ā����K�߯\��ro�r����7*��䕖��6�a��w��\^��R���կ�V�ή���X���ʽ���Mu��~V�S��Gܵr��鳕o����j����L+c���ǫA��APT�������=X��F��>M��0�y]@�$Lv�4�-��9s.���q��63?;^�k�gg� u\��-e�.5�GF�$o�V?^�Z��7��g�,L��J���Z�?��sYG�{8��={�:�U-[s�#~���xH���2Ӓ�aDOg`;�Z���5�]�E���Ӧ� ����j/����������A3_P=E�����C�Z�Q�3���Wo��,��|HZ�Ω��7�����)�֔���r"Vu×l����>��TN7N��\ $�ď��*7 ��eڶ㶳��b�Q,-7a������$5�G;�PU�9uড়���Vz:���������X��u#v�J�T �2�
���R��؎������c����Y�DT]�l3�O��m���S��8kӎ͙�\NS��-������s��G
��c�aO����Ah���Y+�s_E+���w�2Y����OO����9D��614�Lj�J]�>W��j�:-��'h����H�vgG�5�a}a��_����:r����Pb|?WX���WR�������ꪟܦ"�m�O�P�����dk9nOj'6u]�$���n�ƅiy�]5��ymN����9IbN;4�RO�BnƝ��86�c�Qs��7�{&z��6�sNh��űțF��FZSh�r�ɿB�
G�r*��r*i%�sT�Q�-b-^ /�B���Ks�+j��s݉~���n�Do���X�5�M3B��4�O����660��4�z�#m�g�Bk�r�Y�~WB�gM+(�b�@�X��x�Ȅ�aCA�5���as~;[g`7غ�dh�=t]��H�N҅ l�[=����hb4V0��d+���S�.�P|T����6O�Z�*.�%���&��?[4�t�үڃ��ܠ5��^ҟ��w�ǟ0�ܢ���#��Z��{~�:�?g=?M����w��K�=*���.�^x�����v�_��y�w���:���o
z=����:��Z~�ay1�~s`�Z���R��Ϫst܁��
=@������N�I�܁|��Zh�3��t�ƹ�4��O�&_�_����0�1ӌ��>Γ�A oZ��^$���g;���6jΩ}~��Z�S��8�}�J�ԣ�������h�
Ԣc�����3P*��>ڼ�f�]�