Магия на практике

SELECT `key`, `value`, serialized FROM `oc_setting` WHERE `key` NOT IN ('config_image_resize_mode','config_image_resize_filter','config_image_resize_blur','config_image_auto_orient','config_image_preserve_alpha','config_image_background_color','config_image_strip_metadata','config_image_jpeg_quality_small','config_image_jpeg_quality_medium','config_image_jpeg_quality_large','config_image_jpeg_small_max','config_image_jpeg_medium_max','config_image_jpeg_progressive','config_image_jpeg_sampling','config_image_png_compression','config_image_png_filter','config_image_png_strategy','config_image_webp_quality','config_image_avif_quality')

SELECT language_id, name, code, locale, image, directory, sort_order, status, default_currency_code, url_prefix, hreflang FROM oc_language WHERE status = '1' ORDER BY sort_order, name

SELECT currency_id, title, code, symbol_left, symbol_right, decimal_place, value, status, date_modified FROM oc_currency ORDER BY title ASC

SELECT `trigger`, `action` FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC

SELECT `query` FROM `oc_url_alias` WHERE keyword = 'praktika-magii' LIMIT 1

SELECT keyword FROM `oc_url_alias` WHERE `query` = 'blog/home' LIMIT 1

SELECT c.category_id AS blog_category_id, c.parent_id, c.image, c.sort_order, c.status, cd.name, cd.h1, cd.description, cd.short_description, cd.meta_title, cd.meta_description, cd.meta_keyword FROM oc_blog_category c INNER JOIN oc_blog_category_description cd ON (c.category_id = cd.category_id AND cd.language_id = '3') WHERE c.category_id = '7' AND c.status = '1' LIMIT 1

SELECT cp.path_id AS blog_category_id, cd.name FROM oc_blog_category_path cp INNER JOIN oc_blog_category c ON (cp.path_id = c.category_id AND c.status = '1') INNER JOIN oc_blog_category_description cd ON (cp.path_id = cd.category_id AND cd.language_id = '3') WHERE cp.category_id = '7' ORDER BY cp.level ASC

SELECT c.category_id AS blog_category_id, c.parent_id, c.image, c.sort_order, cd.name, cd.short_description FROM oc_blog_category c INNER JOIN oc_blog_category_description cd ON (c.category_id = cd.category_id AND cd.language_id = '3') WHERE c.parent_id = '7' AND c.status = '1'  ORDER BY c.sort_order ASC, cd.name COLLATE NOCASE ASC

SELECT a.article_id AS blog_article_id, a.date_added, a.date_modified, a.image, ad.title, CASE WHEN ad.short_description != '' THEN ad.short_description ELSE substr(ad.description, 1, 1200) END AS short_description, COUNT(*) OVER() AS __total FROM oc_blog_article_to_category atc INNER JOIN oc_blog_article a ON (atc.article_id = a.article_id AND a.status = '1') INNER JOIN oc_blog_article_description ad ON (a.article_id = ad.article_id AND ad.language_id = '3') WHERE atc.category_id = '7' ORDER BY a.date_added DESC, a.article_id DESC LIMIT 0,6

SELECT layout_id FROM oc_layout_route WHERE 'blog/category' LIKE route ORDER BY route DESC LIMIT 1

SELECT layout_id FROM oc_blog_category_to_layout WHERE category_id = '7' LIMIT 1

SELECT code, position, sort_order FROM oc_layout_module WHERE layout_id = '14' ORDER BY position, sort_order

SELECT module_id, setting FROM oc_module WHERE module_id IN (33,37,40,42,43,46,47,48,50,51,54,55)

SELECT c.parent_id, c.category_id AS blog_category_id, c.sort_order, cd.name FROM oc_blog_category c INNER JOIN oc_blog_category_description cd ON (c.category_id = cd.category_id AND cd.language_id = '3') WHERE c.parent_id IN (0) AND c.status = '1'  ORDER BY c.parent_id, c.sort_order, cd.name COLLATE NOCASE

SELECT `query`, `keyword` FROM oc_url_alias WHERE `query` IN ('blog_category_id=1','blog_category_id=2','blog_category_id=3','blog_category_id=4','blog_category_id=6','blog_category_id=9','blog_category_id=5','blog_category_id=8')

SELECT sp.seo_page_id, sp.route, sp.status, spd.name, spd.meta_title, spd.h1, spd.meta_description, spd.meta_keyword, spd.short_description, spd.description
				FROM oc_seo_page sp
				LEFT JOIN oc_seo_page_description spd ON (sp.seo_page_id = spd.seo_page_id)
				WHERE sp.route IN ('blog/category&blog_category_id=7')
					AND sp.status = '1'
					AND spd.language_id = '3'
				ORDER BY CASE sp.route WHEN 'blog/category&blog_category_id=7' THEN 0 ELSE 9999 END
				LIMIT 1

SELECT `key`, `value`, serialized FROM `oc_setting` WHERE `key` NOT IN ('config_image_resize_mode','config_image_resize_filter','config_image_resize_blur','config_image_auto_orient','config_image_preserve_alpha','config_image_background_color','config_image_strip_metadata','config_image_jpeg_quality_small','config_image_jpeg_quality_medium','config_image_jpeg_quality_large','config_image_jpeg_small_max','config_image_jpeg_medium_max','config_image_jpeg_progressive','config_image_jpeg_sampling','config_image_png_compression','config_image_png_filter','config_image_png_strategy','config_image_webp_quality','config_image_avif_quality')

SELECT a.article_id AS blog_article_id, a.date_added, a.date_modified, a.image, ad.title, CASE WHEN ad.short_description != '' THEN ad.short_description ELSE substr(ad.description, 1, 1200) END AS short_description, COUNT(*) OVER() AS __total FROM oc_blog_article_to_category atc INNER JOIN oc_blog_article a ON (atc.article_id = a.article_id AND a.status = '1') INNER JOIN oc_blog_article_description ad ON (a.article_id = ad.article_id AND ad.language_id = '3') WHERE atc.category_id = '7' ORDER BY a.date_added DESC, a.article_id DESC LIMIT 0,6

SELECT c.category_id AS blog_category_id, c.parent_id, c.image, c.sort_order, c.status, cd.name, cd.h1, cd.description, cd.short_description, cd.meta_title, cd.meta_description, cd.meta_keyword FROM oc_blog_category c INNER JOIN oc_blog_category_description cd ON (c.category_id = cd.category_id AND cd.language_id = '3') WHERE c.category_id = '7' AND c.status = '1' LIMIT 1

SELECT c.category_id AS blog_category_id, c.parent_id, c.image, c.sort_order, cd.name, cd.short_description FROM oc_blog_category c INNER JOIN oc_blog_category_description cd ON (c.category_id = cd.category_id AND cd.language_id = '3') WHERE c.parent_id = '7' AND c.status = '1' ORDER BY c.sort_order ASC, cd.name COLLATE NOCASE ASC

SELECT c.parent_id, c.category_id AS blog_category_id, c.sort_order, cd.name FROM oc_blog_category c INNER JOIN oc_blog_category_description cd ON (c.category_id = cd.category_id AND cd.language_id = '3') WHERE c.parent_id IN (0) AND c.status = '1' ORDER BY c.parent_id, c.sort_order, cd.name COLLATE NOCASE

SELECT code, position, sort_order FROM oc_layout_module WHERE layout_id = '14' ORDER BY position, sort_order

SELECT sp.seo_page_id, sp.route, sp.status, spd.name, spd.meta_title, spd.h1, spd.meta_description, spd.meta_keyword, spd.short_description, spd.description FROM oc_seo_page sp LEFT JOIN oc_seo_page_description spd ON (sp.seo_page_id = spd.seo_page_id) WHERE sp.route IN ('blog/category&blog_category_id=7') AND sp.status = '1' AND spd.language_id = '3' ORDER BY CASE sp.route WHEN 'blog/category&blog_category_id=7' THEN 0 ELSE 9999 END LIMIT 1

SELECT `query`, `keyword` FROM oc_url_alias WHERE `query` IN ('blog_category_id=1','blog_category_id=2','blog_category_id=3','blog_category_id=4','blog_category_id=6','blog_category_id=9','blog_category_id=5','blog_category_id=8')

SELECT module_id, setting FROM oc_module WHERE module_id IN (33,37,40,42,43,46,47,48,50,51,54,55)

SELECT language_id, name, code, locale, image, directory, sort_order, status, default_currency_code, url_prefix, hreflang FROM oc_language WHERE status = '1' ORDER BY sort_order, name

SELECT cp.path_id AS blog_category_id, cd.name FROM oc_blog_category_path cp INNER JOIN oc_blog_category c ON (cp.path_id = c.category_id AND c.status = '1') INNER JOIN oc_blog_category_description cd ON (cp.path_id = cd.category_id AND cd.language_id = '3') WHERE cp.category_id = '7' ORDER BY cp.level ASC

SELECT layout_id FROM oc_layout_route WHERE 'blog/category' LIKE route ORDER BY route DESC LIMIT 1

SELECT `query` FROM `oc_url_alias` WHERE keyword = 'praktika-magii' LIMIT 1

SELECT currency_id, title, code, symbol_left, symbol_right, decimal_place, value, status, date_modified FROM oc_currency ORDER BY title ASC

SELECT `trigger`, `action` FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `event_id` ASC

SELECT keyword FROM `oc_url_alias` WHERE `query` = 'blog/home' LIMIT 1

SELECT layout_id FROM oc_blog_category_to_layout WHERE category_id = '7' LIMIT 1