Евтини книги
Couldn't execute query.
select items.id, title, autor, image, cover, price, state, paused, customer_id, 0 as ntx, year from items inner join customers c on c.id = items.customer_id where (paused = 0 or paused is null) and `state`=4 and c.enabled = 1 and (title like '%Анжелик%' or title like '%АНЖЕЛИК%' or title like '%анжелик%' or title like '%Анжелик%' or autor like '%Анжелик%' or autor like '%АНЖЕЛИК%' or autor like '%анжелик%' or autor like '%Анжелик%')
union
select * from (select items.id, title, autor, image, cover, price, state, paused, customer_id, 1 as ntx, year from items inner join customers c on c.id = items.customer_id where (paused = 0 or paused is null) and `state`<>4 and c.enabled = 1 and (title like '%Анжелик%' or title like '%АНЖЕЛИК%' or title like '%анжелик%' or title like '%Анжелик%' or autor like '%Анжелик%' or autor like '%АНЖЕЛИК%' or autor like '%анжелик%' or autor like '%Анжелик%')
union
select items.id, title, autor, image, cover, price, state, paused, customer_id, 1 as ntx, year from items inner join customers c on c.id = items.customer_id where (paused = 0 or paused is null) and `state`=0 and c.enabled = 1 and (title like '%Анжелик%' or title like '%АНЖЕЛИК%' or title like '%анжелик%' or title like '%Анжелик%' or autor like '%Анжелик%' or autor like '%АНЖЕЛИК%' or autor like '%анжелик%' or autor like '%Анжелик%')
union
select items.id, title, autor, image, cover, price, state, paused, customer_id, 1 as ntx, year from items inner join customers c on c.id = items.customer_id where (paused = 0 or paused is null) and `state`=3 and c.enabled = 1 and (title like '%Анжелик%' or title like '%АНЖЕЛИК%' or title like '%анжелик%' or title like '%Анжелик%' or autor like '%Анжелик%' or autor like '%АНЖЕЛИК%' or autor like '%анжелик%' or autor like '%Анжелик%')
union
select items.id, title, autor, image, cover, price, state, paused, customer_id, 1 as ntx, year from items inner join customers c on c.id = items.customer_id where (paused = 0 or paused is null) and (`state` <> 3 and `state` <> 4 and `state` <> 0) and c.enabled = 1 and (title like '%Анжелик%' or title like '%АНЖЕЛИК%' or title like '%анжелик%' or title like '%Анжелик%' or autor like '%Анжелик%' or autor like '%АНЖЕЛИК%' or autor like '%анжелик%' or autor like '%Анжелик%')) as T and `language`= 27
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 `language`= 27' at line 9