Доставка по Москве:
350 руб.
Доставка за МКАД:
от 400 руб.
Database error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND pd.lang_code = 'RU'
ORDER BY p.amount DESC , pd.product ASC
' at line 10 (1064)
Invalid query: SELECT *
FROM (
SELECT * , @i := @i +1 AS s
FROM (
SELECT p.product_id, pd.product, p.amount
FROM cscart_products p
LEFT OUTER JOIN cscart_products_categories c ON p.product_id = c.product_id
LEFT OUTER JOIN cscart_product_descriptions pd ON p.product_id = pd.product_id
WHERE c.category_id =
AND pd.lang_code = 'RU'
ORDER BY p.amount DESC , pd.product ASC
) AS pp,
(
SELECT @i :=0
) AS t
) AS oO
WHERE oO.s = (
SELECT temp.position
FROM (
SELECT * , @j := @j +1 AS position
FROM (
SELECT p1.product_id, pd1.product, p1.amount
FROM cscart_products p1
LEFT OUTER JOIN cscart_products_categories c1 ON p1.product_id = c1.product_id
LEFT OUTER JOIN cscart_product_descriptions pd1 ON p1.product_id = pd1.product_id
WHERE c1.category_id =
AND pd1.lang_code = 'RU'
ORDER BY p1.amount DESC , pd1.product ASC
) AS pp1, (
SELECT @j :=0
) AS t1 ) AS temp
WHERE temp.product_id = 2446
) -2 LIMIT 1
Backtrace:
| File: | /home/i/infoliek/korzin.net/public_html/core/fn.database.php |
| Line: | 341 |
| Function: | db_error |
| File: | /home/i/infoliek/korzin.net/public_html/core/fn.database.php |
| Line: | 178 |
| Function: | db_query |
| File: | /home/i/infoliek/korzin.net/public_html/core/fn.catalog.php |
| Line: | 2965 |
| Function: | db_get_fields |
| File: | /home/i/infoliek/korzin.net/public_html/core/fn.catalog.php |
| Line: | 3078 |
| Function: | fn_get_neighbours |
| File: | /home/i/infoliek/korzin.net/public_html/core/fn.cms.php |
| Line: | 722 |
| Function: | fn_get_products |
| File: | /home/i/infoliek/korzin.net/public_html/core/templater_plugins/function.block.php |
| Line: | 124 |
| Function: | fn_get_block_items |
| File: | /home/i/infoliek/korzin.net/public_html/core/templater_plugins/function.block.php |
| Line: | 42 |
| Function: | smarty_function_block_output |
| File: | /home/i/infoliek/korzin.net/public_html/var/compiled/customer/%%90^906^9061AB18%%default_template.tpl.php |
| Line: | 185 |
| Function: | smarty_function_block |
| File: | /home/i/infoliek/korzin.net/public_html/core/class.templater.php |
| Line: | 87 |
| Function: | include |
| File: | /home/i/infoliek/korzin.net/public_html/var/compiled/customer/%%93^933^933B9DDF%%view.tpl.php |
| Line: | 24 |
| Function: | _smarty_include |
| File: | /home/i/infoliek/korzin.net/public_html/lib/templater/Smarty.class.php |
| Line: | 1265 |
| Function: | include |
| File: | /home/i/infoliek/korzin.net/public_html/core/class.templater.php |
| Line: | 123 |
| Function: | fetch |
| File: | /home/i/infoliek/korzin.net/public_html/core/templater_plugins/function.block.php |
| Line: | 101 |
| Function: | display |
| File: | /home/i/infoliek/korzin.net/public_html/core/templater_plugins/function.block.php |
| Line: | 64 |
| Function: | smarty_function_block_output |
| File: | /home/i/infoliek/korzin.net/public_html/core/templater_plugins/function.block.php |
| Line: | 32 |
| Function: | smarty_function_group_output |
| File: | /home/i/infoliek/korzin.net/public_html/var/compiled/customer/%%72^72D^72DAF6E8%%main.tpl.php |
| Line: | 47 |
| Function: | smarty_function_block |
| File: | /home/i/infoliek/korzin.net/public_html/core/class.templater.php |
| Line: | 87 |
| Function: | include |
| File: | /home/i/infoliek/korzin.net/public_html/var/compiled/customer/%%45^45E^45E480CD%%index.tpl.php |
| Line: | 86 |
| Function: | _smarty_include |
| File: | /home/i/infoliek/korzin.net/public_html/lib/templater/Smarty.class.php |
| Line: | 1258 |
| Function: | include |
| File: | /home/i/infoliek/korzin.net/public_html/lib/templater/Smarty.class.php |
| Line: | 1108 |
| Function: | fetch |
| File: | /home/i/infoliek/korzin.net/public_html/core/class.templater.php |
| Line: | 121 |
| Function: | display |
| File: | /home/i/infoliek/korzin.net/public_html/core/fn.control.php |
| Line: | 506 |
| Function: | display |
| File: | /home/i/infoliek/korzin.net/public_html/index.php |
| Line: | 18 |
| Function: | fn_dispatch |