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�%[����DRwuծ]{��Uu����>y��9zH�9�|r���h�9}Vy���ɩ��iFF�}>�o(�
�Qq%�[ӑ�cE��jd�#%�Wm{:�k���'Zy~"����┉����?}h��d�����w$����=�<�����_�_q��V�H=h�f8�n(EK�ӵy��f5jY�d��9*J�E�r�#fv�d�#R�4�h:�s��d<>??3Ԃ��Z���B\72��X1W|�2K�6��2��/�FiVM;%K��k���N^�������f���*�?�Y~�\���3�}��R>{�r�տ_���������o\)�}�����{g��_�|xOyY��
%�N[z��M���(y?F�VVO]��{�|�\���l��;uā�埗ʯ߯^��|o�z����7���䕗��6�a��w*�\^��R��啯WϮ���X����+��Me��~V�S��G<�|����o���ꚝ9�-̛V�`��1�W�2q����_�_�9�u{�����;|�l¤ tm�0�!�D��Ӫ���l�7�$�3�mfn8v��m�eg�(5\�y-e�n�-���I^�'�b�xQk�
^ż�qr05�*�j����gs���p��{��u:�Z��LG���S��I9�#d ��%7È���v��(�1k�;����i5�M'"A*MC�^(�sӑ���уf��:z�t�c�Ӈ��D��f��k7�K+��*_Y������S��oL��}_S��)9K�mf�z/�8܃u}䑩�n�U�H��W�Tn��)˴m�mg!���-�XZ~:�~�9MIh�#�vҡ��qj�O8�Q���t$���/�4k!�?�ñ�+�F�8*���Y(�+�cm+��LӱK-Ə�q��:l���Ј�:��f*��X�-�WOy�N;�5�l^S����,����Z���G���c�aO����A(���Y+�r��-3KVZcm��e��G�>L���7F
�r�$qobh���W��>.}���� @m��B7�1�99
bu�������~��LA������M'bc��
��8�k�7E>�nBIA��������ܞ��Ml��p @��������u�f�sZV����9IbL;4�RK�|~���8��c�q1�^�������2ڬZ�;]�C�"�`�2��i=J���a&�
-+�P̫�W˫d���r�Q-GiX���,xl>�
}�j,ͥ_̨kL�hN�s�L��ZS��9��[��0!�џ��C��QS����z�S������xO[��ځК��c�ߔ��Y�* J� upmM��M����d�i�_����5�^ҟ��wǟ0������#��Z��{~�:�?g=?M�������K�>�{������=?+��\�jeK�v���2���o
ly=�٤��:��Z~�cv1�~s`�j,�FVs�U�ϪY����熞?��T{�HO'���2{�+�*x��h1ݰ�k�
j��SǨ�W��!f�f�4�j���o���9���n�ق��븍�Y�o��o�P�Y���S�7��aA=:���&�ZrLV����J�i��֮�oQ(��}�-$�K�+,Di��D���C_I�l�f��L*��������@&�G�G��������n�����2�
��0�`9�>\��f2��EœJb$���G7�)��T��ʽe;��JME;K�I�X�x�i�t1^ͳm�I��R���b-n�d�'�R{�i�u4��C5�L�/^��?��5 ��Q��F��-̨7J�^Og�Ԡ�
*s��1�8��=���#�����fS/ަb��b��Wt�P��8}��$�-� �v>XsrfFy<�M�U�XL-���H͎(����KI��0�U�L=u~�ll�i��}�/���f���2(�7D��fِL���
��+z�B�=\���T�)�B�r�ل,��*��W`��ͳ��s�Pء��i�3������g�ψ+}��5fd�V�8�V�͉k�̟��gS�MH�Xa���@���f*Y�������X"�otldd�^jx�h�`�Ь�{4�֊��,U����5<�JX˰*���Q���' ���l�j�bv��Y�oLOG���7fz�#�y6LC��*AG�s�H��@���c=�g���67���K6�뫎c���n�`��ؓG�g�<�>���O�����:V��n���os�h���T\��s/��)�=�23��K��-*�s�;����+ym։bN�o�Oe�9�����P�ס�����:�*/P-s�_;�\�GO�����vA|)d�ppQ5�:=�L���ְ�/f������z��[��s "v��G��Y2z��X��
�(��)Q3�8I���2�����3�E���q��)�ߜ�1�OV�P>{s*��ɘ�.Ӡ��s,��T�)�
��7{R�ʖ�{�.��D�{�T:��{
����(`7Iv��n����0Yr��LA
���(�s21BP�uE���cD��
-�N2��J����3(�P9�1���k n#�Y��G�F��)w#ɚ�sA���Ej@��hXe�}���`�p�)�f-mZ@y����P$\�2z� .�P���-?&Q\�f�j֎gS|������6���]��xR��"�������dM�F�䈕lN�@�#�m8�7�E�95_�F�ue���ca����g����!�n 7F�Lm�ur��3�C��J�M[�`DL�x�r=�KϨs���c�^��~������]*�],��Y0�z�I�',[�6Q�QLzt�S^m��V���^2��V,��,-V�ܮ\y����D�T<�'�j#_#��
���E�{�;Z'S�x���N����7��F՚tp~�>�~t��Q���i���gt>��"fM�\��J8}��ج���i�7עn=.�3�� O%i2�;VJE�d���W�^>������ �մMoT�ҥ��c7d����㽤�\=�9N>
GG*_}W��!���LAK�lR�{���h����p֎�}_���hb����$�3�O�;a>B�Mb�C5��
�
mp�)��H[2R8^�r�[�l3F [B;Ke�����K��`��$F�U%����>��A:���-^�Yƕ��U�]y�.v<����Q&b[��:42J*�ŏJV�<(���#hgV��ʿ�Xy���W�+_��3���}����툞���R�P���l'� ��v�U��I��/�kh��@ӛn
�~vd�b]FGa-���j`*;��ī�>"}��[d�/�^����O+W����I#0�@j�|�c:��-���s�+g��v琎#� ��o��<]��g�oM�$