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 (tconnect_ab__stickers.usergroup_ids = '' ...' at line 6 (1064)
SELECT tconnect_ab__stickers.*, descriptions.*, images.image_id, tconnect_ab__stickers.sticker_id as sticker_id FROM tconnect_ab__stickers LEFT JOIN tconnect_ab__sticker_descriptions as descriptions ON tconnect_ab__stickers.sticker_id = descriptions.sticker_id AND descriptions.lang_code = 'en' LEFT JOIN tconnect_ab__sticker_images AS images ON tconnect_ab__stickers.sticker_id = images.sticker_id AND images.lang_code = 'en' WHERE FIND_IN_SET (3, storefront_ids) AND tconnect_ab__stickers.status = 'A' AND ((tconnect_ab__stickers.from_date <= 1770796800 OR tconnect_ab__stickers.from_date = 0) AND (tconnect_ab__stickers.to_date >= 1770796800 OR tconnect_ab__stickers.to_date = 0)) AND tconnect_ab__stickers.sticker_id IN (0) AND REPLACE(REPLACE(tconnect_ab__stickers.display_place, "/", ""), "\", "") NOT LIKE '%"detailed_page":"not_display"%' AND (tconnect_ab__stickers.usergroup_ids = '' OR FIND_IN_SET(0, tconnect_ab__stickers.usergroup_ids) OR FIND_IN_SET(1, tconnect_ab__stickers.usergroup_ids)) ORDER BY tconnect_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: | 744 |
| Function: | include |
| File: | app/functions/fn.control.php |
| Line: | 475 |
| Function: | fn_run_controller |
| File: | index.php |
| Line: | 19 |
| Function: | fn_dispatch |