| Query | SELECT
(SELECT categories_id FROM categories_description WHERE language_id = 16 AND categories_id = 000) AS cat1,
(SELECT categories_id FROM categories_description WHERE language_id = 16 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2,
(SELECT categories_id FROM categories_description WHERE language_id = 16 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3,
(SELECT categories_id FROM categories_description WHERE language_id = 16 AND categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4,
(SELECT categories_name FROM categories_description WHERE language_id = 16 AND categories_id = 000) AS cat1name,
(SELECT categories_name FROM categories_description WHERE language_id = 16 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2name,
(SELECT categories_name FROM categories_description WHERE language_id = 16 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3name,
(SELECT categories_name FROM categories_description WHERE language_id = 16 AND categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4name,
(SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 000) AS cat1url,
(SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2url,
(SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3url,
(SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4url,
(SELECT wod_count_products FROM categories WHERE categories_id = 000) AS cat1cnt,
(SELECT wod_count_products FROM categories WHERE categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2cnt,
(SELECT wod_count_products FROM categories WHERE categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3cnt,
(SELECT wod_count_products FROM categories WHERE categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4cnt
|
![Cover of William Shakespeare: The Comedy of Errors: The Works of William Shakespeare [Cambridge Edition] [9 vols.] (ePUB)](https://static.worldofdigitals.com/info_webp/790/9781518384790.webp "William Shakespeare: The Comedy of Errors: The Works of William Shakespeare [Cambridge Edition] [9 vols.] (ePUB)")
