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 category.`structure_id` < 1000000000000000000)' at line 7
fetch(array (
0 => '
SELECT
count(*) as acount
FROM
product
left outer join category on product.category_id = category.id
WHERE
1 and product.status!="HIDE" and (category.`structure_id` >= and category.`structure_id` < 1000000000000000000)
',
)
) at packages/frontend/modules/ProductList/db.php:36,
get_total_item(array (
0 => '1 and product.status!="HIDE" and (category.`structure_id` >= and category.`structure_id` < 1000000000000000000)',
)
) at packages/frontend/modules/ProductList/forms/list.php:25,
parse_layout(array (
0 => 'list',
)
) at packages/frontend/modules/ColumnLayout/forms/list.php:10,
run() at index.php:11
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 category.`structure_id` < 1000000000000000000)
ORDER BY
product.posit' at line 13
fetch_all(array (
0 => '
SELECT
product.id,
product.*,
product.price,
product.brief_1 as brief,
product.name_1 as name,
IF(product.small_thumb_url!="",product.small_thumb_url,product.image_url) as small_thumb_url,
product.name_id
FROM
product
left outer join category on product.category_id = category.id
WHERE
1 and product.status!="HIDE" and (category.`structure_id` >= and category.`structure_id` < 1000000000000000000)
ORDER BY
product.position desc,product.time desc
LIMIT
0,18
',
)
) at packages/frontend/modules/ProductList/db.php:24,
get_products(array (
0 => '1 and product.status!="HIDE" and (category.`structure_id` >= and category.`structure_id` < 1000000000000000000)',
1 => 18,
)
) at packages/frontend/modules/ProductList/forms/list.php:28,
parse_layout(array (
0 => 'list',
)
) at packages/frontend/modules/ColumnLayout/forms/list.php:10,
run() at index.php:11