You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and `structure_id` < 1000000000000000000) AND 1' at line 8
fetch(array (
0 => '
SELECT
count(*) AS total
FROM
product
LEFT OUTER JOIN category ON product.category_id = category.id
LEFT OUTER JOIN manufacturer ON manufacturer.id = product.manufacturer_id
WHERE
product.status!="HIDE" and category.status!="HIDE" and category.type="PRODUCT" AND (`structure_id` >= 1080100000000000000 and `structure_id` < 1080200000000000000) AND (`structure_id` >= and `structure_id` < 1000000000000000000) AND 1
',
1 => 'total',
)
) at packages/frontend/modules/ItemsList/db.php:48,
get_total_item(array (
0 => 'product.status!="HIDE" and category.status!="HIDE" and category.type="PRODUCT" AND (`structure_id` >= 1080100000000000000 and `structure_id` < 1080200000000000000) AND (`structure_id` >= and `structure_id` < 1000000000000000000)',
1 => '1',
)
) at packages/frontend/modules/ItemsList/forms/list.php:89,
parse_layout(array (
0 => 'list',
)
) at packages/backend/modules/ColumnLayout/forms/list.php:8,
on_draw() at cache/pages/da-xanh-reu-ha-trung.portal=default.cache.php:1587,
run() at index.php:18
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and `structure_id` < 1000000000000000000) AND product.status != "HIDE" AND 1
...' at line 17
fetch_all(array (
0 => '
SELECT
product.id,
product.name_id,
product.name_1 AS name,
product.status,
product.image,
product.position,
product.price,
product.hitcount,
product.info_1 AS info,
category.name_id AS category_name_id,
category.name_1 AS category_name
FROM
product
LEFT OUTER JOIN category ON product.category_id = category.id
WHERE
product.status!="HIDE" and category.status!="HIDE" and category.type="PRODUCT" AND (`structure_id` >= 1080100000000000000 and `structure_id` < 1080200000000000000) AND (`structure_id` >= and `structure_id` < 1000000000000000000) AND product.status != "HIDE" AND 1
ORDER BY
product.position DESC,product.id DESC
LIMIT
',
)
) at packages/frontend/modules/ItemsList/db.php:28,
get_items(array (
0 => 'product.status!="HIDE" and category.status!="HIDE" and category.type="PRODUCT" AND (`structure_id` >= 1080100000000000000 and `structure_id` < 1080200000000000000) AND (`structure_id` >= and `structure_id` < 1000000000000000000)',
1 => '!= "HIDE"',
2 => '1',
3 => 'product.position DESC,product.id DESC',
4 => false,
)
) at packages/frontend/modules/ItemsList/forms/list.php:114,
parse_layout(array (
0 => 'list',
)
) at packages/backend/modules/ColumnLayout/forms/list.php:8,
on_draw() at cache/pages/da-xanh-reu-ha-trung.portal=default.cache.php:1587,
run() at index.php:18
Warning: Invalid argument supplied for foreach() in /home/marblestonemanhtrang.com/public_html/packages/frontend/modules/ItemsList/db.php on line 30
Warning: Invalid argument supplied for foreach() in /home/marblestonemanhtrang.com/public_html/packages/frontend/modules/ItemsList/forms/list.php on line 115