/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`='hino' 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`='51'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('4933','4934','4935','4936','11980','11981','11982','11983','11984','11985','13048','13049','13050','13283','13618','13619','13620','13621','13622','13623','13624','13625','13626','13627','13628','13629','13630','13631','13632','13633','13634','13635','13636','13637','13638','13639','13640','13641','13642','13643','13644','13645','13646','13647','13648','13649','13650','13651','13652','13653','13654','13655','13656','13657','13658','16208','16927','16928','16930','16931','16933','22069','22070','22071','22072','22073','22074','22075','22076','22130','22185','30281','30282','30283','30284','30285','30286','30287','30288','46248','46741','46742','46754','46755','46791','47000','47508','47517','47518','47519','48048','48270','48271','48272','48273','48274','48275','48276','48277','48278','48279','48280','48416','48420','48421','48422','48432','48433','48556','49622','49623','49624','49625','49626','49627','49628','49629','49630','49631','49632','50082','50083','50084','50085','50086','50087','51278','51279','51280','51281','51282','51283','51284','51285','51286','51287','51288','51289','51290','51291','51292','51293','51294','51295','51296','51297','51298','51299','51300','51301','51302','51303','51304','51305','51306','51307','51308','51309','51310','51311','51312','51313','51314','51315','51316','51317','51318','51319','51320','51321','51322','51323','51324','51325','62085','62086','62087','62088') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('4933','4934','4935','4936','11980','11981','11982','11983','11984','11985','13048','13049','13050','13283','13618','13619','13620','13621','13622','13623','13624','13625','13626','13627','13628','13629','13630','13631','13632','13633','13634','13635','13636','13637','13638','13639','13640','13641','13642','13643','13644','13645','13646','13647','13648','13649','13650','13651','13652','13653','13654','13655','13656','13657','13658','16208','16927','16928','16930','16931','16933','22069','22070','22071','22072','22073','22074','22075','22076','22130','22185','30281','30282','30283','30284','30285','30286','30287','30288','46248','46741','46742','46754','46755','46791','47000','47508','47517','47518','47519','48048','48270','48271','48272','48273','48274','48275','48276','48277','48278','48279','48280','48416','48420','48421','48422','48432','48433','48556','49622','49623','49624','49625','49626','49627','49628','49629','49630','49631','49632','50082','50083','50084','50085','50086','50087','51278','51279','51280','51281','51282','51283','51284','51285','51286','51287','51288','51289','51290','51291','51292','51293','51294','51295','51296','51297','51298','51299','51300','51301','51302','51303','51304','51305','51306','51307','51308','51309','51310','51311','51312','51313','51314','51315','51316','51317','51318','51319','51320','51321','51322','51323','51324','51325','62085','62086','62087','62088') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='51'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "Hino%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='51'
230
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='51' ORDER BY `sort_name`, `type` LIMIT 200, 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`='51'
SELECT `id`, `tag` FROM tag WHERE `id` IN('183','518')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('4127','4128','4129','4130','4131','4132','4133','4134','4194','4254','12355','12356','12357','12358','12359','12360','12361','12362','28339','28824','28825','28837','28838','28874','29078','29576','29585','29586','29587','30088','30299','30300','30301','30302','30303','30304','30305','30306','30307','30308','30309','30445','30449','30450','30451','30461','30462','30585','31921','31922','31923','31924')
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 28837) ORDER BY name_title
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `id`='28837'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 4133) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 31283) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT vector_id FROM prints_set_vector WHERE `set_id`='31283'
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `id` IN('4133') ORDER BY price LIMIT 0, 1
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 28824) ORDER BY name_title
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `id`='28824' ORDER BY price LIMIT 0, 1
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `prepay`=0 AND `id` IN('4127','4128','4129','4130','4131','4132','4134','4194','4254','12355','12356','12357','12358','12359','12360','12361','12362','28339','28825','28838','28874','29078','29576','29585','29586','29587','30088','30299','30300','30301','30302','30303','30304','30305','30306','30307','30308','30309','30445','30449','30450','30451','30461','30462','30585','31921','31922','31923','31924')
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 30461) ORDER BY name_title
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `id`='30461'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT set_id FROM prints_set_vector WHERE vector_id = 30300) ORDER BY name_title
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34039) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1
SELECT vector_id FROM prints_set_vector WHERE `set_id`='34039'
SELECT `id`, `class_id`, `item_id`, `name`, `name_version`, `name_spec`, `full_name`, `sort_name`, `url`, `preview`, `filename`, `large_preview`, `detail`, `vector_dwg`, `wrap_template`, `views`, `scale`, `ext`, `copyright_type`, `copyright_url`, `copyright_text`, `added_date`, `update_date`, `updated_by`, `views_count`, `downloads_count`, `add_user_id`, `price`, `prepay`, `prm`, `flag`, `comment`, `bundle`, `bundle_text`, `market`, `segment`, `tier`, `make_source` FROM prints_vector WHERE `id` IN('29576','30299','30300','31921','31923') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group
