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$�<� �d3!� 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� �FZ Sh�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ӌ��>Γ�AoZ��^$���g;���6jΩ}~��Z�S��8�}�J�ԣ�������h� Ԣc�����3P*��>ڼ�f�]�� 8�M㴣��+>b��h�v�B6�)5�z�P��'5:&�haV�^�z�8;��mP�T�A�T��%���l�66�za �2U�4����k�2����ӵ&a}��s�Ú�53��}�z�bj��[��@�vD�T��^�Z�� l�`�i�{gc3 �ϯc|a,`4��3Ռ�A��!�d��5ˆd�N�pl�/�\1bTz�����jL�6R��d9dTq}>��uh�5f�����LL��y�5�uWH�<�xF\�s���"X�bx���*fhN\3f�|,>���iA�� \�4����S�R'F��'&��}�c##c(z���E��M����qZ+80G��{3�Ww�+a=ê�OP�Ga��_$|w{����0��>���~4=ID~ZLߘ陎���0 -�ka�e"-���������a�c���K�c.8��m:�=�{�΂��cOQ�9�r�ȓO?��:��X-��aƲ�Ϧ7�䉿��x����)�=�23��L��-*?u�S�E<��+9m։bM��Oe�y������P�������;��P-s��:�\�GO�����v^|�g�p pA5�=�L��Z�p�/V��X���z��\��s "���H��Y4z����� �(�*�2+��2�L`�~�ng�B�N}�x��7gDg �Ǔ����ޜ��~F2�����b���p�����3EXA�SW��Dj���O�Ezޗ���oXK�#@7x��ѳ�y�'��ح|4�'v&Ln�-�°1�q�O&Fk��Ȃ�r���C b�L��RE�3�e �(T��f��ۈ:�N�# Q#~����dUݹ${� �"= �g4l�� ��L0� �����֧7��t�3����|����w�}�s+]��e"�uɊa@#�4���;0^�m�ʝ�sWw�̊���/?��{���J�o�5��оӌX{�vD�Z�h�R���^�[�`� � �|{�$L��5t|T��E��v?;2�]�.���� ��,50��QP�U�H��|�-��_/��d始�ga�w���a �~��1���S��ҕ3|s�sH�K� ��oK�<]��g�o-�$�sIg;j�����{�V�}љ�D�{B�N��>q���ʹ{8D(����{�5C�Hs�W�Fw�^ ���GoG�A�`��gƶ����|y���� �mx1����:2�]Q� ���'���P4��{x~��ԍ�-��kJ0�����tw���=%�PQ�D�J�Ltk������_y�\��7�(Y&������s(y��7L=������5���h�5QqL� ���x ���2�L�\S6^����J7�'����cc������|��� 5�N�0�ϋ`6�@����lg���kh�c-�i��5�Z�qԚ=N>A�`�M;�'�z&_,��?,>��G��~itW#�4�.�;��~7T���r������� �5X��#�B��ыٙ?�g�Μ�{ѣ'gSy��>&\��$k$�8x�!%xB�+���P��N�� ���v���@��hK� �^�f���/�{:�$z����Qt"qpdx�b� �O����!;�Y��F�� l ����@�.����Z(�rQ�����������>yf�d�.���zv���O~�4 yp�y�Ϊʬ-d�� ��>��?�F81r;!v��>8��f��o�L$���aedlx��ѱ1a7�� *��54hƼ����dV�vI�wl�/����v�ŐEп�����^f�|�&�"�.A�d�|\w��O���]�U%_��8� )@�= MJ�]�S����~D�s������!_�|#X�I"8�q�3L�#��œfʅ���+jiv�4l8e��J�|�Z� A�_�g��fB��89�� 8�$���d���j�r���_�Y��Gk,��~�G�l��Ȁ�U��9�[Ed�Wo����:�2D9�d����YD����:�` ����w�~�c��?}x�Z�������aL�;k�@��� �T�J������kK��N��Z;�w<80Y����ϗK˷�>�Q�sw��3�~C}޹�P�k�./�^[:U:w�ty����m���΍4Y�+w��,�Z%�.D_� �*��P-p�Ba�oO �45ˋ��G�m氤?���ܛ�/Զ�e\^��|�2�.D��x�»C�I^n ���d�3��g��ӳ�(���G�%�'�G�ɃQ�'QXo�p�a��E^�D��-?eԼ7:�(z�b�R�$�a̻M�Yg�l)�Ľҕ���I"G; ��QY�Ia��8 )3�h܍�Qr�xM���,����U���xIfap�&ɽQi`qiu�#�X�E8Q©�0�P$ �e�-��v�C\�Ecn�7���5�����D���QX��s/�?����\ BC����) � @ؠdx��.yM���F��>���V�b���h�&�&����£��a�j�m�� ��:ɩx*d��(6rۓZ+!3L��NG2�YȘ Hbϊs��э�(u?Y}�a7�N����XG:"�Y(�uʾ���IчkE\�Q쨹H�h@A��|�߆bC�RxZx�A�Ss��>�M�p�|bx�H�^���W#'*�)n��m(���p��Zv�~n��- x�e��>�PB���./�/��\�~}���jC�k(_7�ep�I�s2Q�#J��^�֍|UU'(�wA�b�T��{�|���p�*�N�V[��^̳���А�yլ�<�v�z��᪁��W.s��k��`?j�x4DI}�W��F��#���U�F�AYpϚ�Zn�ww]P5o$R`�dvk��n� nxO�2}J�Wҕ���N#r):YϢ*n���("�!�ޕ޹�G�DO��N]��!/(�$�ܑP Q��+�4�"��\���e����T�2/�6��o�;ْ�L���!�+��[����څ�ߕ�h�|I�B+�?��o��FLi�Q�7�r[��s}�Y��,�����k�-��/�y����ի��_����yw�jQ�}�JR��x�Y-}� �7^���� �W����\�������Ґ���ƈ��nn�����-�KS�t6�lޔe�B:��n+j�#���S\t% \k�������8��ky`)��y5W�ψRȩi-�p��5)��\���gR)�2 ���� �"7G�b�2�^ꑺ�k5�v�+���XF�U�9G3��^y#��Vb�E<�*��BxP\S�����'��9��,����%��/]�(w�*�|�!U ��A�B�䴅��rLVs]����(Z��F ~��������N�Pny�("�S�h�P�>+�ߨ��UB�=,��Ja���E��2��J�P�}n��H.�1y��2�%�V�r(។y�+���E�Ŧ���W��y�hO.d"�� �?��G�'_M�9�L5R.��UW����G��)�����CFm�j�����GPw���$�����E[�Eg5��#��9��[���|uG���m��ܼ^J:�8��@Ҵ�$~� ��>��؟L�[U�c�E���7pVŚ۠��s����|��>�dzk6Ϣ�Gڊ�%.�W�T@�x>spf~x&�/�J���P":6rrb(V ��"�~���v��ʛ��z�[�/ ٪��͙,D�%_XHߐ��2�5���q��nK��+�}�� ɵ�&_J�w�����F:��O��b���a���>�D�^��1����`��5��E]!��&��9:25�����2����x'�d��p��*J�/��yW�B�� ,h�OjK�M�R^_ �ִZp �tGv���!B)�5HA������!��T ���<�UE������!Q�/v�"_�~�U�±�>���U���?��3I�f��G ��]�&��s*�����T����C��~�ש��������fȺ�H�{�+���b��X]AUE�K�S|�v�>��T���G�U�¤tM ��a��*��U���4pQ�.ES��݁���l%�jLD-vj�ָ�[ke���h�)*�T����TM����t��o�� {k���,\u�w� >�GM� ���8�s��&[�} İ�2��hj_��'��ڵ;�[�֠����M%&v �r��h�!;M��M�)HM��TM�X4���H%�����u�n�'}�~�54�?M�w��]�h��;5h*��nGS�M��l-�jD��FSPT��:顩�ꡩ����j�{gSz�V~����›�Mu콩��y�O��8���V_�����^}ijD@��ճk�.�@���3�rb�x�=z��D��;���}�]�Ҕ7���R���D�l(-ej�_9����zP��v.����A)=l�B�D����)J��A�Q�H�|�(p�c�.�R���TJ $�Լ�߭���%����P�NAzP��zPj�B���������@)��� � �� z�7&�T��_J?ެAS=~�R45�[Д�֢�FD�l4E��S��ꡩ�ڹh��濇�<��9hj��x�hj�㿮޸R��.z�إhj�nASb [�����h�NAzh���zhj碩��������)dt��ٔ��o"�1߄�����{_�@���3v)�ڷ[����B�FD�l(-��S���A��ڹP����<��9P �:�C!P ��k�}Yy��J]���K���n�Rb [ �������� ҃R=(ՃR;Ju������6JQ�@/agcL%�⟣P�?_:Uw0t���.ES�݂��@�M5"bg�)(*�T����TM����ES]5�=4塇�AS�.=�K �L����]��Q��T�E��J��� 1���R����P Z (U� =(ՃR=(�s�TW�����ݟpI����3��6�d�T���ʼn�)=�;��"[����Mp�4�,�"� X͡)�����H\M9ݔG"#���S�D�|�fe�"r���,��|X�� O�8�E�/V}��D̎esI^�t����[�>���x��>��3&��za�XV����r2�GF�ɀ�4,eFG�B_�U��(��[���W���<^A1 ]�%9�p���� �H גH��#��D�5�������IY�)ؓ����B���"!�i-Ɛ.� �Pi�d��1S��"s�Vp���Y݀�I�&��tW�(i�� �Cuxm���~̚&RS'y�V�+�?/�d��U�� N���7�8fa&���@)��F9FyZR�E'US��ew�S�aWYX�@p���������KH�Lڱt���Y�+���(/�j2�`F�Ӗ.r�Awx��7K��>�����ʭ����K�/�}�]��o��ݫ�xX�t�t���O~^�y�$��K��%edC"( m4oZ����-"��jk�\3T\��R��L������}X����g��?���)�[uI��j�i]͹�%���"K�H� a6�IŚK��*���A�(+�����[8/.-��y���u��gtà��R o$��R�y"DS��LOHm��dO��$�՜�W ��&�{+����4t��/�\&0�w5A�z��w�6��o��O��b���,�fwdG�����W^z��o$���*+�F���  �6��o�0��D���#Q�i0S$�3Y���A���ŕ��\�oWz�$���� �_V��zN�Mr'�K�R8��k7W?�Q^�T��~s��۵�N�EÉ[�qd}��|�5��z��&��Z^-D�V��o# t��$�~�K��0�W{j; -�����J#�mS]� ;�F�0 �2�n ���0�, x���ҥ��, ��z�ʍPj4Z_0��*��Y:�E��Ǎ�Xo��(�Oh����;�W�}U����viZH�����|]������ۡ���d��9��n���`�4P��t�ʷ�*���z �O����MsZ2VP���DuXė �l�5�o�p��+�Q�JL� l �9SDJzq�Z���Y٢]>#��S�T~��[Px���V`��t���ʩO�׾ǿ����z�����������>~m��7k�۸�%&ʷ��c�����@���x:���G#ɴ�{���<�s0O�ǛW2�n����~�����aedlx��ѱ1 ��# ~�^y�W,|�+?���0�d�j�c=Tx�P��t$��sYg214������(��8������Zڱ|[�RH����f���X\ǧv���dh7g�3h���(K�.�Z�bfL`e͎�IR�O��%�� 9S�����Zf���'�i#]-� ��/e�F&�Wm���fX_$���xF���XY�qV-�2͊;�b>e`�m\��Z/�8�| ��>)SQ R=1��,� j��*Ě�� -*�II �P�`Ԟ��o.�|�]u �%F;��=�!��؀��잩��(�hS��G�F��uf\���Z�2obئT7NT��Z(�rQ��$�=I��� ����l��F��xF���.d�9P,6J�\N����l��I[���-�Xc{Xvsf����4c^˙AF[�{T6@MYd����VsZ#\�����5]��o*IF�\�d)� )�q�� ���J�$��`�Y=kqE�I���6�e�<�nTB]����b� @Vuv��8��{��V��q��-|�4 �t�����9OCi+��n�P���� e��ʈ�0:�ճ��we��vE%��q}�����-qS%$�q��<�()������k 遼�*K}� ���{phϵ���9RЌ���(���� G#��uT�-(�fQ�ﳖ�)��XZޜǷ�����2JjQ�65��XP gPA�XEwleN�� ��@HqO��n�&�� ���y2��`g6�=Gsy����rT]<�� VK�=Q �����0)|lʳY-�)iPRo���j9�e��Z-�k���ؐB�� �J�j��X�B�|K��EBN>������wE7