| Query | SELECT
(SELECT categories_id FROM categories_description WHERE language_id = 1 AND categories_id = 000) AS cat1,
(SELECT categories_id FROM categories_description WHERE language_id = 1 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2,
(SELECT categories_id FROM categories_description WHERE language_id = 1 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3,
(SELECT categories_id FROM categories_description WHERE language_id = 1 AND categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4,
(SELECT categories_name FROM categories_description WHERE language_id = 1 AND categories_id = 000) AS cat1name,
(SELECT categories_name FROM categories_description WHERE language_id = 1 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2name,
(SELECT categories_name FROM categories_description WHERE language_id = 1 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3name,
(SELECT categories_name FROM categories_description WHERE language_id = 1 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
|
![Обкладинка Mark Twain: Tom Sawyer Collection - All Four Books [Free Audiobooks Includes 'Adventures of Tom Sawyer, ' 'Huckleberry Finn', 'Tom Sawyer Abroad' and 'Tom Sawyer, Detective'] (ePUB)](https://static.worldofdigitals.com/info_webp/433/9788826484433.webp "Mark Twain: Tom Sawyer Collection - All Four Books [Free Audiobooks Includes 'Adventures of Tom Sawyer, ' 'Huckleberry Finn', 'Tom Sawyer Abroad' and 'Tom Sawyer, Detective'] (ePUB)")
