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�����ͯ�'O׾Y���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:0�o$�o/WX���WR��fR�����jܶ"�mQ@�[PR4�-�����nO''6t}j� $W���� ��u�n � Ƽ��}s�Ƙ�h\����¬��$��&q1!/������%rƜ^.x}�C��*�h[�2�i#L���A&��+<�X*���(�d���v��OkZ���,|l=� }�j"˥_̨m�λhN�s�L�h�)�.�9���0�0!��OK�!���w�`�.zP��}���xO;��]��� �.��)!�s�S�x.D ,`{M|��E�aKAj4��DzeuA;�d`�va�PKw�&�]�𕤄 l�[ߩ���xj\�����п3<����<3��5���33�~�i�����w?�꣫�g��ij/���3����ߥ;��"����/�2��ԯ-lz=��d���� :���XӋ���wS�Eܘ7>^U�t��4�dz��˔�\δ�A�d鸖�"��1�x�������r���^�AS����}�4{ F8]�W�lcgJÊ'����X�[.��)�\�.m���_ �CM[�����Y���v�$��tc�I�y��& �ޏ=zH{��S��C�>������c��F��6�>@�'����u������t��-�7��[\}놷�Kx%� Ɯǜ�p�Ι x+.1s��/�/D]�;�C�u"�U ^�:�b�v�3�ڏw�{ �ݢ�R�� �.&��n $���!74�a�_̜{1Qk;�"���-oLl�7��ԳY�ly�6ɴ�*&�; P�T�fvq���e� "v7o�J@����ST�=+c�=���w�r��tR2�1/ ��\�A<��X���ӄ4�u��o�B��-_�$%���4�~�\:��� ����(b?������9���1a�U����&$ ��J��b}Q%�Y�y쇖D/��Mgʀg�d �hT�m����ۊ{�9���U����#�LLKW~���O�+g^^��W��Z���͐�:�ԓq��������'>lj���X���*?�����)託- �����:���}D;;��%h�S�}2�%⯽ � ���^��H�`����B-d�nE6x�)���[1R�^kg���2c��%��T��͐�:�t?�}��qpUK�k���W��P!����-��ǵW����u��;t��_+��F��m}�b���8u�r�:�?BY�~�r�■�Y1�����C����^��r�c�-� �[͈uGoO��#�V EZ���vb n:a7!^�oϑ�)��_#�GZޔ5t�ٓa�u��d�a���썂��G��0��3o��?�J��'�?��^< s�%l$�����Ֆ�V������T.��ۭC:Nނ�����d募�-4���L�0�7����V>����[���Ua�u��Υʛ�~�!B_-��^&>�ݪ�����w�����9m�D 8�5�3�>����%_� pF�+^�I6K<�7�����h��4:�t�� Hg+��Y^���/ڡ2��?�/3� �;�g�íЋQfg/[�N��Ƿܭ@x��!�]!3&b㬑������:s�o��|��D'F� ]�y.�ի��r��7�?�����t����ӏ+�^Z;�Eo�?�f?�4B���9�Ȯڙ�XWs��.;�ә!n�9�3A���E�r�W���s���v���q��؆BL��G�U�Ϫ!����my3���.�d�������K���-���pX��ՙz�jKl�[�R����48ݽ��N��D$R��щ�A%�����pN��\�8S=�M$JV�������*ޱ�Й�v�O�s�[K��]�4������᫉����29|L�8T[?�F�ǔ<�������~���(�OH��6v�u���&Ȑ��?m<��;4A'`Y+�y݅,'� ɵr�X��(J�%߁\�k��;@-�φ����B���+�T+�/ :��!��0��5�$�3��=�K�2܁"��v�/�s����!��� ���s�"��� 3�3��<���<� ��]�^��� ��v�ƁK1ʡGQY� �i��ds�?������� [98�M�����G�/�Ə�����`��c��K�ԕ n��3(b��]eG��ʅB�a�{�60���_�tɃ�UMqp6x8�|C��K'�I<_��Ų�9]���<�d@�pK�p����be��㬾&��E������olT�ݻw|bB؍p3G�c����Z0 �:�����- 9��qN�P��aF1b N�c���7���� ���{��y@P}١����{��YbU�n��P����"��H�#C��(u��h~��~��a�bSd0:.����Ԅ���v�c;Lr]>C��l˅�&�e�b�o��|!�� �L1�L�wO�X�%Q�`�t����|�*�߭������W�����+��_�P �pH�������z��A�f�O^fP�(Ǔl6�0�h�n�d�.ᔼry�����~����/wN���r�\u��،��x}�������m���8�J���Rz}������K�P#�� ��//��t��ru���+�o��t���o���72o��OՕ���'*g�Un���|�ڗ5>��(�%�rW-�ALF2�BD��TR5�t��.6�� ���>�)x��vS����ǽ^��@u����i��'y��q.1���PhR��g���Xe��{�G���&�����d��d@�0"y:i{�L��Ҧ-��ֹ����{����+�B�������)��l�Me8}�r�k9;)�ǁss:�G',�ꏝ� �J��=�kO̯��D�F(`Q��('���8�����_�"7(��ťITG�',��p���SiJ#�w�d^�(2����}O�i����N#�}/�k�{+�'{�S���t�F����SL�*'T ��72GG;sl��G�����i�7��ݸ uӳveМ�H7f�q֭��+�O��w 4DY����8DuJ�'�9��GT�w{��=QEe'0c���\�!�:17�� �^U�EY�_w��TMnS��L�ty������F �e�1۱�6���6V���$ 2�SB�(!�%0'����u˙��+p?\���� 6��;a�ںfɆ��Za�Vte��7�Z5�ɽ�vR'OtR�k��sR1���s����@��������s��{�Y�%�h|�!�Z���� &�~yCv͑���-ˢ�wm7{�*<�O݋a0݅o�cZK�7݆ ��ư5=� �'�?�1������-� ���`�^�D�-T��P(ā꧟l���?��� ���ݒ�!�nhj���݊܁�p��^�[�')x$��}�G�!��E�,�*�5���9N�ݤ ����zpCk���O�ܳ����E��D�}���� S�-}o�ͻe���8����ƾ5Y�t����`��ea��a�嵍����w���M: �}�N��i����ھ�ma28��H*������M��KR�B��T�:x�E���)*!BԸ�O��1�"���S~\��g��,��^0��3�ΆC{,�V�K�O1���~<.���yNS>D���l�_S��_QS: ��AI� U&�-5T���j�X������G��2.����p�x�<�m��ݦ jm�2�ʈ ��[���@�QZ �ؓ����ā`�:�"��oV���Jc�&ύ�ĨZ�/46 �;Vh�s���3�C!G�8�śԑ<�)* �$�톟7�eF�T��� �L�S�L�QY�y������9N����� ���O�DBm�5d"����|���IJ?������5���k����p�GS41�y�E$m�.�n�����ܯ�M�򗘌|�������/wΌ�r�U4�����9�"���7�7�ǐhc��O'�?�T�o׾c��߻��XG] �#.�;��6��ψ%��Нl>�B����U�6��q��x`�DW₴&�U*{q��Zb�|�]�8�"��z��xx��P�ϘV*�Y#��j�3C���?>�M*�,e��KO�M�)�"f��)�ǁ�ZB;�c`,g���'�z����7@+1�"6b���o<��p��$(��O�� :��]G9w��I��ݘ�s� �� O�XX� 2�f�HR�c���F ��E �=�O��F�Ϡ�o�Q���[e����g��כ[�J����J��)d6_B��Mq�R�� ��#��Gp_��)�� (ٲRʡ�2�q� �k,z#4����2�r���N`�5=�?�n�����'�Q'Y �"�%�X���2n ����@ �46X������j�D�`�&�:p�]v�B��q��i8rq�2��j-."`"*�����z�"J��(���9:�����4`�${���4�� ��L��֚t��c +�7�I��y9v���f�������Y��@W1q1�%q�N�IsfFgS{�Ro$��GR��#�� =�ࣸȝ��n\��qi\��1��������B�$��B����ټ����\�˚���^RK�[R h�;+�����me f��>H >�! ��n�O�� Щ������a�\�G�&QW}9 �Xa��<�.x&�����U���2YYCG��ɀ /aca#TT���~�B���"Xހ04^6���� �i��%i�'�{7� �l��a � hT�X����Rr�,�|W�jZ�׿�ݗ ^��Ŷ]�����8�v��'�p�hط�[Qx���R7L�����˳��&@�O�֬]��b�>���h��I̓��)'�6KֽA��&����_��Mk�PWyK|��J����0�{���P��^���045*�T��7k�Ӏ�Bnno4��h���f���D4b�l��0�\�Z�{����M5)�M ��M�%�nR�{��|���[�.�X���/� >��M%J���ؿ�6K�=)ă�3��hjO��#�����ի/5�����M�&� ���T4Ւ�-��HQ���d��hj���,��k��R�zq�.ce���MߞI� M� CS{图��]~�M����hj�vAS�#���Z���h�IAhj��hj뢩����ޔ�p�*�t6rʰ��T��M���|쑃I���x��������1��O��x�J����јX��z��D��[��Ԟ�694�wds���f([JAK�Z�#��� ��J ��օR}5�(壇{��}LE#?4�B��((5.��+V�|��Bn��ئPj|��J����~ Sh����=�VDlm(-�jR��@��ںP����|�po��Q�J�x�M���h���ϕ�4����>?�)��.hJtds�T+"�6���M5)�M ��Mm]4�W�?@S>z�7hjo�Ծ04�O��������4r���6ES{� ��\4Պ������@SM 2@S45@S[M���Д�� �B����M���&�^�M��|�߯���J�����M�Ԟ��DG6J�"bkC)h)�T�� ��J ��օR}5�(壇{��5��P*5�p��]���;��P*�όm �F� ��\(Պ�� ���mV��@��ںP����|�po�� ���6�T*,�9.����'�6��n��ئh*�]Д��梩VDlm4E�jҞ����ںh�����|�po�T��+��R�QS2|s��;k?lؘ ��3c�B���<%:��P�[JAK��d�Pj��.��������.��~�"&2�漼� 1�@Z[0]3cLoiJd���e�K��diy^�zM�͏�EG�j�yX�g�Iט�Χ��KWj+g���ra�z����x���$nʶX���z�mͧy�ʙ�k���r�}�j����!�1Q��[Ų҇�MW�Q>x �>@��b%3:�򯪏�y~�� ��"� ���:ʈih�Oȉ�M4Ķo�DV�D�A�%�l�F��H��� �Iy�+�S����b���"!��,%���(4g��j�)Eb ���(y�֜iAҔn��?_��(i�� �C!exi��*?�l���[]�����ڏ_TW�5 �0g�Y����;����+�K�*|t_��b���ʝ���]��o��ެ}|�r�Z��k����� I:���O:�ȆDP�x�v ����5<\Fc�5b"�f�� ѥ1��94u/?3��z���>�~��ʧ�n]��pյ��^��%���"��H� a��)͙���R���5|����W�ׯb�������*�'�Uk�5-���*)��������M������0��K�=H8kx31�[�|C�=�(����u���,$��KMP�Yś�]>F��~�\�� ��jI�}:?��݀���v�����A��"J�YI60^�ظ�"*� D}R���$2?N�m��"�ɚr� �H..ܑr!8ʈ(:��{@/����տ� �ŗ��7���S]�� riB gPu����WW�Uξמ��6�g�v�򒎁4�VY_a)�}���߿��I"��Qԑ?�kEe��@�nZ&����?Ŕ���;�%�����z�B+�U,_'�A� �%j�,�2(��]dSV1F�e�\;S9�ܚ�a|ڨ\��nɠ�#�ꏕ3W*������5mR��������}y��W���o����,�y���կ~����� ����$K|�!|۴�E�`x�z������e�u4D?V?�6Y*�DI_*b�7a��h�U�Ԟ����/�B� 1&�)��l)��>j�TTxfe�n����N|S�������Pg��8:� T�v�d��'�K���k���v�⾽��ѵ�.���ڷo ���q�KMV����T��O9�� a�L(�����Y��� �y�_�`���?�d0��>1��^���)�7��F���ѽ{�'&�CX�X$��vx��_0�U/�X��.� ��j,��P��B��3��a�罩��������⊲���%�]�5����ۢ�Ad��& k�OG���>u���"C�=��Ee�G�YBv�:o#c+n��D� �~���(�}�\*�z.i��g��z�~<�����R����2�n�E݅> �n��Eb�M��b�����dŲ�f8I/_.f, ����y�Y/_̠�c���U*A�/�*�V�\� H$�,����2�b���h"� G���/�Km�W�}t$5�C��[aU��/gwL��iF��t�X8��4 ~n2 �,�_yج(�����u�n~��R�P�;�'!�)�ư�i�x�d��p6���;����e�P:� �찒d��]ŏ�����"c���'��r�M� 4ւQ�K���� �j��l����狫�V��-1�M�k;�)��t"��ǹ��R(6A2����YH���iE>"�X�B��W^g��ӄ�5�J�� >-��d���9������h���n��I�`KH����̇?�&1Cϙ� �߈xJ(�vUF�Dѱ��U�h�*kմ��Ǎq@��W�Ζ�m��(�F����Q��ڥ�����Kuu���m$3n���=�R�z�D��Pɰ莧��3fi��c�[Ա���-�e���9��y��E{��V� ��i�%�^�{bQ��a 1b5�s�y�,��!P�3%�˪,��Ж�Ɉ�l���$v.�D� ��е���a�@T�R�o�j��̎d�I�}Ӟ�EC�b��Z���(`?(�4r� _�4�&F4��^�E�T5&��42u�[��-������F��Թ.