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 fittings.fitting_status != "3" AND' at line 8
fetch(array (
0 => '
SELECT
count(*) AS total
FROM
fittings
LEFT OUTER JOIN category ON fittings.category_id = category.id
LEFT OUTER JOIN manufacturer ON manufacturer.id = fittings.manufacturer_id
WHERE
fittings.status!="HIDE" and category.status!="HIDE" and category.type="FITTINGS" AND (`structure_id` >= and `structure_id` < 1000000000000000000) AND fittings.fitting_status != "3" AND 1
',
1 => 'total',
)
) at packages/frontend/modules/FittingsList/db.php:67,
get_total_item(array (
0 => 'fittings.status!="HIDE" and category.status!="HIDE" and category.type="FITTINGS" AND (`structure_id` >= and `structure_id` < 1000000000000000000)',
1 => '1',
)
) at packages/frontend/modules/FittingsList/forms/list.php:101,
on_draw() at cache/pages/phu-kien.portal=default.cache.php:2323,
run() at index.php:18
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 fittings.status != "HIDE" AND fitt' at line 22
fetch_all(array (
0 => '
SELECT
fittings.id,
fittings.name_id,
fittings.name,
fittings.status,
fittings.image,
fittings.image_detail,
fittings.price_old,
fittings.price,
fittings.price_promotion,
fittings.color,
fittings.icon,
fittings.icon_tg,
fittings.hitcount,
category.name_id AS category_name_id,
manufacturer.name_id AS manufacturer_name_id
FROM
fittings
LEFT OUTER JOIN category ON fittings.category_id = category.id
LEFT OUTER JOIN manufacturer ON manufacturer.id = fittings.manufacturer_id
WHERE
fittings.status!="HIDE" and category.status!="HIDE" and category.type="FITTINGS" AND (`structure_id` >= and `structure_id` < 1000000000000000000) AND fittings.status != "HIDE" AND fittings.fitting_status != "3" AND 1
ORDER BY
fittings.price DESC, fittings.id DESC
LIMIT
',
)
) at packages/frontend/modules/FittingsList/db.php:45,
get_items(array (
0 => 'fittings.status!="HIDE" and category.status!="HIDE" and category.type="FITTINGS" AND (`structure_id` >= and `structure_id` < 1000000000000000000)',
1 => '!= "HIDE"',
2 => '1',
3 => 'fittings.price DESC, fittings.id DESC',
4 => false,
)
) at packages/frontend/modules/FittingsList/forms/list.php:111,
on_draw() at cache/pages/phu-kien.portal=default.cache.php:2323,
run() at index.php:18
Warning: Invalid argument supplied for foreach() in /home/huymobile/domains/huymobile.vn/public_html/packages/frontend/modules/FittingsList/db.php on line 48
Warning: Invalid argument supplied for foreach() in /home/huymobile/domains/huymobile.vn/public_html/packages/frontend/modules/FittingsList/forms/list.php on line 112