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 'detailed_page":"not_display"%' AND (ushop_ab__stickers.usergroup_ids = '' OR ...' at line 6 (1064)
SELECT ushop_ab__stickers.*, descriptions.*, images.image_id, ushop_ab__stickers.sticker_id as sticker_id FROM ushop_ab__stickers LEFT JOIN ushop_ab__sticker_descriptions as descriptions ON ushop_ab__stickers.sticker_id = descriptions.sticker_id AND descriptions.lang_code = 'es' LEFT JOIN ushop_ab__sticker_images AS images ON ushop_ab__stickers.sticker_id = images.sticker_id AND images.lang_code = 'es' WHERE FIND_IN_SET (1, storefront_ids) AND ushop_ab__stickers.status = 'A' AND ((ushop_ab__stickers.from_date <= 1757386800 OR ushop_ab__stickers.from_date = 0) AND (ushop_ab__stickers.to_date >= 1757386800 OR ushop_ab__stickers.to_date = 0)) AND ((0) OR ushop_ab__stickers.type = 'D') AND REPLACE(REPLACE(ushop_ab__stickers.display_place, "/", ""), "\", "") NOT LIKE '%"detailed_page":"not_display"%' AND (ushop_ab__stickers.usergroup_ids = '' OR FIND_IN_SET(0, ushop_ab__stickers.usergroup_ids) OR FIND_IN_SET(1, ushop_ab__stickers.usergroup_ids)) ORDER BY ushop_ab__stickers.position asc
app/Tygh/Database/Connection.php, line: 1713
| File: | app/Tygh/Database/Connection.php |
| Line: | 1490 |
| Function: | throwError |
| File: | app/Tygh/Database/Connection.php |
| Line: | 700 |
| Function: | execQuery |
| File: | app/Tygh/Database/Connection.php |
| Line: | 333 |
| Function: | query |
| File: | app/functions/fn.database.php |
| Line: | 35 |
| Function: | getArray |
| File: | app/controllers/common/debugger.php |
| Line: | 60 |
| Function: | db_get_array |
| File: | app/functions/fn.control.php |
| Line: | 727 |
| Function: | include |
| File: | app/functions/fn.control.php |
| Line: | 458 |
| Function: | fn_run_controller |
| File: | index.php |
| Line: | 19 |
| Function: | fn_dispatch |