/var/www/html/nox-modules/prints
/lib/action/frontend
/printsBlueprintsSubcategoryAction.action.php
SELECT `id`, `db_table`, `enabled`, `url`, `name`, `name_singular`, `category_image` FROM prints_class WHERE `enabled`='1' AND `url`='car'
SELECT `id`, `class_id`, `country_id`, `url`, `name`, `logo`, `top`, `blueprints_count`, `vectors_count`, `downloads_count`, `purchases_count` FROM prints_make WHERE `url`='henschel-werke' AND `class_id`='1' ORDER BY name
SELECT `id`, `class_id`, `country_id`, `url`, `name`, `logo`, `top`, `blueprints_count`, `vectors_count`, `downloads_count`, `purchases_count` FROM prints_make WHERE class_id = 1 AND ((vectors_count > 0) OR (blueprints_count > 0) OR (id IN (SELECT make_id FROM `prints_request_vector`))) ORDER BY name
SELECT `id`, `make_id`, `year`, `end`, `class`, `body` FROM prints_class_car WHERE `make_id`='273'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('15770','15771','15772','15773','15774','15775','16641','16642','16643','16644','16645','16646','16647','16648','16649','16650','16651','16652','16653','16654','51277','52908','52909','52910','52911','52912','52913','52914','52915','52916','52917','52918','52919','52920','52921','52922','52923','52924','52925','52926','52927','52928','52929','52930','52931','52932','52933','52934','52935','52936','52937','52938','52939','52940','52941','52942','52943','52944','52945','52946','52947','52948','52949','52950','52951','52952','52953','52954','52955','52956','52957','52958','52959') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('15770','15771','15772','15773','15774','15775','16641','16642','16643','16644','16645','16646','16647','16648','16649','16650','16651','16652','16653','16654','51277','52908','52909','52910','52911','52912','52913','52914','52915','52916','52917','52918','52919','52920','52921','52922','52923','52924','52925','52926','52927','52928','52929','52930','52931','52932','52933','52934','52935','52936','52937','52938','52939','52940','52941','52942','52943','52944','52945','52946','52947','52948','52949','52950','52951','52952','52953','52954','52955','52956','52957','52958','52959') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='273'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Henschel Werke%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='273'
73
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='273' ORDER BY `sort_name`, `type` LIMIT 0, 100
SELECT `tag_id`, `category_id` FROM tag_categoryitem WHERE `category_id`='1'
SELECT `id`, `tag` FROM tag WHERE `id` IN('64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','289','290','291')
SELECT `tag_id`, `make_id` FROM tag_make WHERE `make_id`='273'
