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 `structure_id` < 1000000000000000000) AND 1' at line 9
fetch(array (
0 => '
SELECT
count(*) AS total,
attribute2.price AS price
FROM
product
LEFT OUTER JOIN category ON product.category_id = category.id
LEFT OUTER JOIN (SELECT *, attribute_value AS price FROM attribute) attribute2 ON product.id = attribute2.product_id AND attribute2.product_attribute_id = 33
WHERE
product.status!="HIDE" and product.portal_id = "#default" and category.status!="HIDE" and category.type="PRODUCT" AND (`structure_id` >= and `structure_id` < 1000000000000000000) AND 1
',
)
) at packages/frontend/modules/ItemsList/db.php:50,
get_total_item(array (
0 => 'product.status!="HIDE" and product.portal_id = "#default" and category.status!="HIDE" and category.type="PRODUCT" AND (`structure_id` >= and `structure_id` < 1000000000000000000) AND 1',
)
) at packages/frontend/modules/ItemsList/forms/list.php:59,
get_sub_regions(array (
0 => 'content',
)
) at packages/core/modules/Paging/forms/list.php(47) : eval()'d code:2,
get_sub_regions(array (
0 => 'content',
)
) at packages/core/modules/Frame/forms/list.php(48) : eval()'d code:32,
parse_layout(array (
0 => 'list',
)
) at packages/backend/modules/ColumnLayout/forms/list.php:8,
on_draw() at cache/pages/san-pham.portal=default.cache.php:1550,
run() at index.php:17
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 `structure_id` < 1000000000000000000) AND 1 AND product.status != "HIDE" AND' at line 21
fetch_all(array (
0 => '
SELECT
product.id,
product.name_id,
product.name_1 AS name,
product.brief_1 AS brief,
product.description_1 AS description,
product.status,
product.small_thumb_url,
product.image_url,
product.date,
product.author,
product.hitcount,
attribute2.price AS price,
attribute3.sale AS sale
FROM
product
LEFT OUTER JOIN category ON product.category_id = category.id
LEFT OUTER JOIN (SELECT *, attribute_value AS price FROM attribute) attribute2 ON product.id = attribute2.product_id AND attribute2.product_attribute_id = 33
LEFT OUTER JOIN (SELECT *, attribute_value AS sale FROM attribute) attribute3 ON product.id = attribute3.product_id AND attribute3.product_attribute_id = 34
WHERE
product.status!="HIDE" and product.portal_id = "#default" and category.status!="HIDE" and category.type="PRODUCT" AND (`structure_id` >= and `structure_id` < 1000000000000000000) AND 1 AND product.status != "HIDE" AND 1
ORDER BY
product.time ASC, product.id ASC
LIMIT
',
)
) at packages/frontend/modules/ItemsList/db.php:34,
get_items(array (
0 => 'product.status!="HIDE" and product.portal_id = "#default" and category.status!="HIDE" and category.type="PRODUCT" AND (`structure_id` >= and `structure_id` < 1000000000000000000) AND 1',
1 => '!= "HIDE"',
2 => '1',
3 => 'product.time ASC, product.id ASC',
4 => NULL,
)
) at packages/frontend/modules/ItemsList/forms/list.php:179,
get_sub_regions(array (
0 => 'content',
)
) at packages/core/modules/Paging/forms/list.php(47) : eval()'d code:2,
get_sub_regions(array (
0 => 'content',
)
) at packages/core/modules/Frame/forms/list.php(48) : eval()'d code:32,
parse_layout(array (
0 => 'list',
)
) at packages/backend/modules/ColumnLayout/forms/list.php:8,
on_draw() at cache/pages/san-pham.portal=default.cache.php:1550,
run() at index.php:17