/var/www/html/nox-modules/prints
/lib/action/frontend
/printsVectorSubcategoryAction.action.php
SELECT `id`, `db_table`, `enabled`, `url`, `name`, `name_singular`, `category_image` FROM prints_class WHERE `enabled`='1' AND `url`='train'
SELECT UPPER(SUBSTRING( name, 1, 1 )) AS "letter" FROM `prints_vector` WHERE class_id = 16 GROUP BY `letter`
SELECT UPPER(SUBSTRING( name, 1, 1 )) AS "letter" FROM `prints_request_vector` WHERE category_id = 16 GROUP BY `letter`
SELECT `tag_id`, `category_id` FROM tag_categoryitem WHERE `category_id`='16'
SELECT `tag_id`, `category_id` FROM tag_category WHERE `category_id`='16'
SELECT `id`, `tag` FROM tag WHERE `id` IN('266','267','268','269','270','271','272','273','274','275','276')
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `class_id` = "16" AND name LIKE "2%"
SELECT id, url, sort_name, full_name, "15" as views FROM prints_request_vector WHERE `category_id` = "16" AND name LIKE "2%" AND `vector_id` IS NULL
SELECT id FROM prints_vector WHERE `id` IN(0) AND `prepay`=0
SELECT id FROM prints_vector WHERE `class_id`='16' AND `prepay`=0
SELECT id FROM prints_vector WHERE `class_id`='16' AND `prepay`=0
