Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.bs_satelit_books' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT 'main_filter' as allbooks,
group_concat(DISTINCT bs_satelit_books.content_id order by bs_satelit_books.content_id) as allIds,
count(DISTINCT bs_satelit_books.content_id) as cntIds
FROM bookstore_mng_books_2020_07_30.bs_satelit_books
JOIN bookstore_mng_books_2020_07_30.ib_data on ib_data.content_id = bs_satelit_books.content_id and ib_data.statusInfo = 1
WHERE bs_satelit_books.id_satelit = '1'
AND bs_satelit_books.status_to_web in ('activated')
AND bs_satelit_books.status in ('approved')
GROUP BY allbooks--- in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1064: 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 ')
GROUP BY family_id_to, kw_id_to' at line 11 in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT family_id_to, kw_id_to,
group_concat(DISTINCT relations.content_id order by relations.content_id) as allIds,
count(DISTINCT relations.content_id) as cntIds
FROM bookstore_mng_books_2020_07_30.bs_satelit_books_relations_sitemap as relations
WHERE relations.id_satelit = '1'
AND relations.status in ('approved')
AND family_id_to > 0
AND kw_id_to > 0
AND relations.content_id in ()
GROUP BY family_id_to, kw_id_to--- in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1064: 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 ')
GROUP BY family_id_to, kw_id_to' at line 11 in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT family_id_to, kw_id_to,
group_concat(DISTINCT relations.content_id order by relations.content_id) as allIds,
count(DISTINCT relations.content_id) as cntIds
FROM bookstore_mng_books_2020_07_30.bs_satelit_books_relations as relations
WHERE relations.id_satelit = '1'
AND relations.status in ('approved')
AND family_id_to > 0
AND kw_id_to > 0
AND relations.content_id in ()
GROUP BY family_id_to, kw_id_to--- in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.z_kursi_kembimit_monedha' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: --- SELECT coalesce(z_session_preferences.monedhID) as monedhID, shortName
FROM z_session_preferences
JOIN bookstore_mng_books_2020_07_30.z_kursi_kembimit_monedha
ON z_kursi_kembimit_monedha.monedhID = z_session_preferences.monedhID
AND active = 'y'
WHERE uni = '20251212100130192168191676011446'--- in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.z_kursi_kembimit_monedha' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: --- SELECT coalesce(monedhID) as monedhID, shortName
FROM bookstore_mng_books_2020_07_30.z_kursi_kembimit_monedha
WHERE active = 'y' AND is_reference = 'y'--- in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT count(distinct kwTable.kw_id) as cnt
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
JOIN bookstore_mng_books_2020_07_30.ib_data as ib_data ON ib_data.content_id=structureTable.kw_id AND statusInfo='1'
JOIN bookstore_mng_books_2020_07_30.bs_satelit_books_relations_sitemap as relations
ON relations.id_satelit = '1'
AND relations.content_id = structureTable.kw_id
AND relations.family_id_to = '7' in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT DISTINCT(kwTable.kw_id) as kw_id,coalesce(relationsPromo.priority,2) as priorityrel,
kwTable.family_id as family_id,
synTable.synonim as term,
if(release_year>0,release_year,0) as release_year_ord,
coalesce(synTable.synonim,kwTable.description) as term,
coalesce(kwTable.abstract,'') as abstract,
coalesce(kwTable.dc_img,'') as dc_img
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT count(distinct kwTable.kw_id) as cnt
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
JOIN bookstore_mng_books_2020_07_30.ib_data as ib_data ON ib_data.content_id=structureTable.kw_id AND statusInfo='1'
JOIN bookstore_mng_books_2020_07_30.bs_satelit_books_relations_sitemap as relations
ON relations.id_satelit = '1'
AND relations.content_id = structureTable.kw_id
AND relations.family_id_to = '4' in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT DISTINCT(kwTable.kw_id) as kw_id,coalesce(relationsPromo.priority,2) as priorityrel,
kwTable.family_id as family_id,
synTable.synonim as term,
if(release_year>0,release_year,0) as release_year_ord,
coalesce(synTable.synonim,kwTable.description) as term,
coalesce(kwTable.abstract,'') as abstract,
coalesce(kwTable.dc_img,'') as dc_img
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT count(distinct kwTable.kw_id) as cnt
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
JOIN bookstore_mng_books_2020_07_30.ib_data as ib_data ON ib_data.content_id=structureTable.kw_id AND statusInfo='1'
JOIN bookstore_mng_books_2020_07_30.bs_satelit_books_relations_sitemap as relations
ON relations.id_satelit = '1'
AND relations.content_id = structureTable.kw_id
AND relations.family_id_to = '4' in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT DISTINCT(kwTable.kw_id) as kw_id,coalesce(relationsPromo.priority,2) as priorityrel,
kwTable.family_id as family_id,
synTable.synonim as term,
if(release_year>0,release_year,0) as release_year_ord,
coalesce(synTable.synonim,kwTable.description) as term,
coalesce(kwTable.abstract,'') as abstract,
coalesce(kwTable.dc_img,'') as dc_img
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT count(distinct kwTable.kw_id) as cnt
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
JOIN bookstore_mng_books_2020_07_30.ib_data as ib_data ON ib_data.content_id=structureTable.kw_id AND statusInfo='1'
JOIN bookstore_mng_books_2020_07_30.bs_satelit_books_relations_sitemap as relations
ON relations.id_satelit = '1'
AND relations.content_id = structureTable.kw_id
AND relations.family_id_to = '8' in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT DISTINCT(kwTable.kw_id) as kw_id,coalesce(relationsPromo.priority,2) as priorityrel,
kwTable.family_id as family_id,
synTable.synonim as term,
if(release_year>0,release_year,0) as release_year_ord,
coalesce(synTable.synonim,kwTable.description) as term,
coalesce(kwTable.abstract,'') as abstract,
coalesce(kwTable.dc_img,'') as dc_img
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT count(distinct kwTable.kw_id) as cnt
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
JOIN bookstore_mng_books_2020_07_30.ib_data as ib_data ON ib_data.content_id=structureTable.kw_id AND statusInfo='1'
JOIN bookstore_mng_books_2020_07_30.bs_satelit_books_relations_sitemap as relations
ON relations.id_satelit = '1'
AND relations.content_id = structureTable.kw_id
AND relations.family_id_to = '7' in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT DISTINCT(kwTable.kw_id) as kw_id,coalesce(relationsPromo.priority,2) as priorityrel,
kwTable.family_id as family_id,
synTable.synonim as term,
if(release_year>0,release_year,0) as release_year_ord,
coalesce(synTable.synonim,kwTable.description) as term,
coalesce(kwTable.abstract,'') as abstract,
coalesce(kwTable.dc_img,'') as dc_img
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.z_kursi_kembimit_monedha' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: --- SELECT coalesce(z_session_preferences.monedhID) as monedhID, shortName
FROM z_session_preferences
JOIN bookstore_mng_books_2020_07_30.z_kursi_kembimit_monedha
ON z_kursi_kembimit_monedha.monedhID = z_session_preferences.monedhID
AND active = 'y'
WHERE uni = '20251212100130192168191676011446'--- in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.z_kursi_kembimit_monedha' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: --- SELECT coalesce(monedhID) as monedhID, shortName
FROM bookstore_mng_books_2020_07_30.z_kursi_kembimit_monedha
WHERE active = 'y' AND is_reference = 'y'--- in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.z_kursi_kembimit_monedha' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: --- SELECT coalesce(z_session_preferences.monedhID) as monedhID, shortName
FROM z_session_preferences
JOIN bookstore_mng_books_2020_07_30.z_kursi_kembimit_monedha
ON z_kursi_kembimit_monedha.monedhID = z_session_preferences.monedhID
AND active = 'y'
WHERE uni = '20251212100130192168191676011446'--- in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.z_kursi_kembimit_monedha' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: --- SELECT coalesce(monedhID) as monedhID, shortName
FROM bookstore_mng_books_2020_07_30.z_kursi_kembimit_monedha
WHERE active = 'y' AND is_reference = 'y'--- in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Sale on packages
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.bs_satelit_books' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT 'main_filter' as allbooks,
group_concat(DISTINCT bs_satelit_books.content_id order by bs_satelit_books.content_id) as allIds,
count(DISTINCT bs_satelit_books.content_id) as cntIds
FROM bookstore_mng_books_2020_07_30.bs_satelit_books
JOIN bookstore_mng_books_2020_07_30.ib_data on ib_data.content_id = bs_satelit_books.content_id and ib_data.statusInfo = 1
WHERE bs_satelit_books.id_satelit = '1'
AND bs_satelit_books.status_to_web in ('activated')
AND bs_satelit_books.status in ('approved')
GROUP BY allbooks--- in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1064: 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 ')
GROUP BY family_id_to, kw_id_to' at line 11 in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT family_id_to, kw_id_to,
group_concat(DISTINCT relations.content_id order by relations.content_id) as allIds,
count(DISTINCT relations.content_id) as cntIds
FROM bookstore_mng_books_2020_07_30.bs_satelit_books_relations_sitemap as relations
WHERE relations.id_satelit = '1'
AND relations.status in ('approved')
AND family_id_to > 0
AND kw_id_to > 0
AND relations.content_id in ()
GROUP BY family_id_to, kw_id_to--- in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1064: 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 ')
GROUP BY family_id_to, kw_id_to' at line 11 in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT family_id_to, kw_id_to,
group_concat(DISTINCT relations.content_id order by relations.content_id) as allIds,
count(DISTINCT relations.content_id) as cntIds
FROM bookstore_mng_books_2020_07_30.bs_satelit_books_relations as relations
WHERE relations.id_satelit = '1'
AND relations.status in ('approved')
AND family_id_to > 0
AND kw_id_to > 0
AND relations.content_id in ()
GROUP BY family_id_to, kw_id_to--- in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.z_kursi_kembimit_monedha' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: --- SELECT coalesce(z_session_preferences.monedhID) as monedhID, shortName
FROM z_session_preferences
JOIN bookstore_mng_books_2020_07_30.z_kursi_kembimit_monedha
ON z_kursi_kembimit_monedha.monedhID = z_session_preferences.monedhID
AND active = 'y'
WHERE uni = '20251212100130192168191676011446'--- in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.z_kursi_kembimit_monedha' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: --- SELECT coalesce(monedhID) as monedhID, shortName
FROM bookstore_mng_books_2020_07_30.z_kursi_kembimit_monedha
WHERE active = 'y' AND is_reference = 'y'--- in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT count(distinct kwTable.kw_id) as cnt
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
JOIN bookstore_mng_books_2020_07_30.ib_data as ib_data ON ib_data.content_id=structureTable.kw_id AND statusInfo='1'
WHERE 1=1 AND (
(( ulje_data_start_book!='' AND DATE_FORMAT(now(),'%Y-%m-%d')>=DATE_FORMAT(ulje_data_start_book,'%Y-%m-%d') )
AND
(ulje_data_end_book!='' AND DATE_FORMAT(now(),'%Y-% in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT DISTINCT(kwTable.kw_id) as kw_id,
kwTable.family_id as family_id,
synTable.synonim as term,
if(release_year>0,release_year,0) as release_year_ord,
coalesce(synTable.synonim,kwTable.description) as term,
coalesce(kwTable.abstract,'') as abstract,
coalesce(kwTable.dc_img,'') as dc_img
, if(ulje_perqindje_book!='' and 1=if(
1=if(ulje_data_start_book!='',if(DATE_FORMAT(now(),'%Y-%m-%d')>=DATE_FORMAT(ulje_data_start_book,'%Y-%m-%d'),'1','2'),'1')
AND
1=if(ulje_data_end_book!='',if(DATE_FORMAT(now(),'%Y-%m-%d')<=DATE_FORMAT(ulje_data_end_book,'%Y-%m-%d'),'1','2'),'1')
,'1','2')
,'show_book_sale_data','not_show_book_sale_data') as show_book_sale_data,
if(ulje_perqindje_shb!='' and 1=if(
1=if(ulje_data_start_shb!='',if(DATE_FORMAT(now(),'%Y-%m- in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.bs_satelit_books' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT 'main_filter' as allbooks,
group_concat(DISTINCT bs_satelit_books.content_id order by bs_satelit_books.content_id) as allIds,
count(DISTINCT bs_satelit_books.content_id) as cntIds
FROM bookstore_mng_books_2020_07_30.bs_satelit_books
JOIN bookstore_mng_books_2020_07_30.ib_data on ib_data.content_id = bs_satelit_books.content_id and ib_data.statusInfo = 1
WHERE bs_satelit_books.id_satelit = '1'
AND bs_satelit_books.status_to_web in ('activated')
AND bs_satelit_books.status in ('approved')
GROUP BY allbooks--- in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1064: 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 ')
GROUP BY family_id_to, kw_id_to' at line 11 in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT family_id_to, kw_id_to,
group_concat(DISTINCT relations.content_id order by relations.content_id) as allIds,
count(DISTINCT relations.content_id) as cntIds
FROM bookstore_mng_books_2020_07_30.bs_satelit_books_relations_sitemap as relations
WHERE relations.id_satelit = '1'
AND relations.status in ('approved')
AND family_id_to > 0
AND kw_id_to > 0
AND relations.content_id in ()
GROUP BY family_id_to, kw_id_to--- in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1064: 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 ')
GROUP BY family_id_to, kw_id_to' at line 11 in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT family_id_to, kw_id_to,
group_concat(DISTINCT relations.content_id order by relations.content_id) as allIds,
count(DISTINCT relations.content_id) as cntIds
FROM bookstore_mng_books_2020_07_30.bs_satelit_books_relations as relations
WHERE relations.id_satelit = '1'
AND relations.status in ('approved')
AND family_id_to > 0
AND kw_id_to > 0
AND relations.content_id in ()
GROUP BY family_id_to, kw_id_to--- in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.z_kursi_kembimit_monedha' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: --- SELECT coalesce(z_session_preferences.monedhID) as monedhID, shortName
FROM z_session_preferences
JOIN bookstore_mng_books_2020_07_30.z_kursi_kembimit_monedha
ON z_kursi_kembimit_monedha.monedhID = z_session_preferences.monedhID
AND active = 'y'
WHERE uni = '20251212100130192168191676011446'--- in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.z_kursi_kembimit_monedha' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: --- SELECT coalesce(monedhID) as monedhID, shortName
FROM bookstore_mng_books_2020_07_30.z_kursi_kembimit_monedha
WHERE active = 'y' AND is_reference = 'y'--- in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT count(distinct kwTable.kw_id) as cnt
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
JOIN bookstore_mng_books_2020_07_30.ib_data as ib_data ON ib_data.content_id=structureTable.kw_id AND statusInfo='1'
JOIN bookstore_mng_books_2020_07_30.bs_satelit_books_relations_sitemap as relations
ON relations.id_satelit = '1'
AND relations.content_id = structureTable.kw_id
AND relations.family_id_to = '7' in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT DISTINCT(kwTable.kw_id) as kw_id,coalesce(relationsPromo.priority,5) as priorityrel,
kwTable.family_id as family_id,
synTable.synonim as term,
if(release_year>0,release_year,0) as release_year_ord,
coalesce(synTable.synonim,kwTable.description) as term,
coalesce(kwTable.abstract,'') as abstract,
coalesce(kwTable.dc_img,'') as dc_img
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT count(distinct kwTable.kw_id) as cnt
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
JOIN bookstore_mng_books_2020_07_30.ib_data as ib_data ON ib_data.content_id=structureTable.kw_id AND statusInfo='1'
JOIN bookstore_mng_books_2020_07_30.bs_satelit_books_relations_sitemap as relations
ON relations.id_satelit = '1'
AND relations.content_id = structureTable.kw_id
AND relations.family_id_to = '3' in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT DISTINCT(kwTable.kw_id) as kw_id,coalesce(relationsPromo.priority,5) as priorityrel,
kwTable.family_id as family_id,
synTable.synonim as term,
if(release_year>0,release_year,0) as release_year_ord,
coalesce(synTable.synonim,kwTable.description) as term,
coalesce(kwTable.abstract,'') as abstract,
coalesce(kwTable.dc_img,'') as dc_img
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT count(distinct kwTable.kw_id) as cnt
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
JOIN bookstore_mng_books_2020_07_30.ib_data as ib_data ON ib_data.content_id=structureTable.kw_id AND statusInfo='1'
JOIN bookstore_mng_books_2020_07_30.bs_satelit_books_relations_sitemap as relations
ON relations.id_satelit = '1'
AND relations.content_id = structureTable.kw_id
AND relations.family_id_to = '4' in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT DISTINCT(kwTable.kw_id) as kw_id,coalesce(relationsPromo.priority,5) as priorityrel,
kwTable.family_id as family_id,
synTable.synonim as term,
if(release_year>0,release_year,0) as release_year_ord,
coalesce(synTable.synonim,kwTable.description) as term,
coalesce(kwTable.abstract,'') as abstract,
coalesce(kwTable.dc_img,'') as dc_img
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT count(distinct kwTable.kw_id) as cnt
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
JOIN bookstore_mng_books_2020_07_30.ib_data as ib_data ON ib_data.content_id=structureTable.kw_id AND statusInfo='1'
JOIN bookstore_mng_books_2020_07_30.bs_satelit_books_relations_sitemap as relations
ON relations.id_satelit = '1'
AND relations.content_id = structureTable.kw_id
AND relations.family_id_to = '4' in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT DISTINCT(kwTable.kw_id) as kw_id,coalesce(relationsPromo.priority,5) as priorityrel,
kwTable.family_id as family_id,
synTable.synonim as term,
if(release_year>0,release_year,0) as release_year_ord,
coalesce(synTable.synonim,kwTable.description) as term,
coalesce(kwTable.abstract,'') as abstract,
coalesce(kwTable.dc_img,'') as dc_img
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT count(distinct kwTable.kw_id) as cnt
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
JOIN bookstore_mng_books_2020_07_30.ib_data as ib_data ON ib_data.content_id=structureTable.kw_id AND statusInfo='1'
JOIN bookstore_mng_books_2020_07_30.bs_satelit_books_relations_sitemap as relations
ON relations.id_satelit = '1'
AND relations.content_id = structureTable.kw_id
AND relations.family_id_to = '4' in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT DISTINCT(kwTable.kw_id) as kw_id,coalesce(relationsPromo.priority,5) as priorityrel,
kwTable.family_id as family_id,
synTable.synonim as term,
if(release_year>0,release_year,0) as release_year_ord,
coalesce(synTable.synonim,kwTable.description) as term,
coalesce(kwTable.abstract,'') as abstract,
coalesce(kwTable.dc_img,'') as dc_img
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT count(distinct kwTable.kw_id) as cnt
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
JOIN bookstore_mng_books_2020_07_30.ib_data as ib_data ON ib_data.content_id=structureTable.kw_id AND statusInfo='1'
JOIN bookstore_mng_books_2020_07_30.bs_satelit_books_relations_sitemap as relations
ON relations.id_satelit = '1'
AND relations.content_id = structureTable.kw_id
AND relations.family_id_to = '4' in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT DISTINCT(kwTable.kw_id) as kw_id,coalesce(relationsPromo.priority,5) as priorityrel,
kwTable.family_id as family_id,
synTable.synonim as term,
if(release_year>0,release_year,0) as release_year_ord,
coalesce(synTable.synonim,kwTable.description) as term,
coalesce(kwTable.abstract,'') as abstract,
coalesce(kwTable.dc_img,'') as dc_img
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT count(distinct kwTable.kw_id) as cnt
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
JOIN bookstore_mng_books_2020_07_30.ib_data as ib_data ON ib_data.content_id=structureTable.kw_id AND statusInfo='1'
JOIN bookstore_mng_books_2020_07_30.bs_satelit_books_relations_sitemap as relations
ON relations.id_satelit = '1'
AND relations.content_id = structureTable.kw_id
AND relations.family_id_to = '4' in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT DISTINCT(kwTable.kw_id) as kw_id,coalesce(relationsPromo.priority,5) as priorityrel,
kwTable.family_id as family_id,
synTable.synonim as term,
if(release_year>0,release_year,0) as release_year_ord,
coalesce(synTable.synonim,kwTable.description) as term,
coalesce(kwTable.abstract,'') as abstract,
coalesce(kwTable.dc_img,'') as dc_img
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT count(distinct kwTable.kw_id) as cnt
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
JOIN bookstore_mng_books_2020_07_30.ib_data as ib_data ON ib_data.content_id=structureTable.kw_id AND statusInfo='1'
JOIN bookstore_mng_books_2020_07_30.bs_satelit_books_relations_sitemap as relations
ON relations.id_satelit = '1'
AND relations.content_id = structureTable.kw_id
AND relations.family_id_to = '8' in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
Notice: https://devlibrat.easy-web.cloud/-1146: Table 'bookstore_mng_books_2020_07_30.ib_data' doesn't exist in
/var/www/html/asp4/web_app/database/class.Connection.php on line
157
Notice: ---
SELECT DISTINCT(kwTable.kw_id) as kw_id,coalesce(relationsPromo.priority,5) as priorityrel,
kwTable.family_id as family_id,
synTable.synonim as term,
if(release_year>0,release_year,0) as release_year_ord,
coalesce(synTable.synonim,kwTable.description) as term,
coalesce(kwTable.abstract,'') as abstract,
coalesce(kwTable.dc_img,'') as dc_img
FROM bookstore_mng_books_fjalor.library_books as structureTable
JOIN bookstore_mng_books_fjalor.library_books_lng as kwTable
ON structureTable.family_id = kwTable.family_id
AND structureTable.kw_id = kwTable.kw_id
AND kwTable.lng_id = '2'
JOIN bookstore_mng_books_fjalor.glossary_synonims as synTable
ON synTable.family_id = kwTable.family_id
AND synTable.kw_id = kwTable.kw_id
AND synTable.lng_id = kwTable.lng_id
AND synTable.term_type = 'main'
in
/var/www/html/asp4/web_app/database/class.Connection.php on line
158
