/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`='zil' 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`='148'
SELECT id, url, sort_name, full_name, views FROM prints_blueprint WHERE `item_id` IN('1562','1563','1564','1565','1566','1567','1568','1569','1570','12055','12056','12064','12065','14629','14630','14631','14632','14633','14634','14635','14636','14637','14638','14639','14640','14641','14642','14643','14644','14645','14646','14647','14648','14649','14650','14651','14652','14653','14654','14655','14656','14657','14658','14659','14660','14661','14662','14663','14664','14665','14666','14667','14668','14669','14670','14671','14672','14673','14674','14675','14676','14677','14678','14679','14680','14681','14682','14683','14684','14685','14686','14687','14688','14689','14690','14691','14692','14693','14694','14695','14696','14697','14698','14700','14701','15872','15873','16569','16570','17043','17044','17046','46933','53795','53796','53797','53798','53799','53800','53801','53802','53803','53804','53805','53806','53807','53808','53809','53810','53811','53812','53813','53814','53815','53816','53817','53818','53819','53820','53821','53822','53823','53824','53825','53826','53827','53828','53829','53830','53831','53832','53833','53834','53835','53836','53837','53838','53839','53840','53841') AND `class_id`='1'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('1562','1563','1564','1565','1566','1567','1568','1569','1570','12055','12056','12064','12065','14629','14630','14631','14632','14633','14634','14635','14636','14637','14638','14639','14640','14641','14642','14643','14644','14645','14646','14647','14648','14649','14650','14651','14652','14653','14654','14655','14656','14657','14658','14659','14660','14661','14662','14663','14664','14665','14666','14667','14668','14669','14670','14671','14672','14673','14674','14675','14676','14677','14678','14679','14680','14681','14682','14683','14684','14685','14686','14687','14688','14689','14690','14691','14692','14693','14694','14695','14696','14697','14698','14700','14701','15872','15873','16569','16570','17043','17044','17046','46933','53795','53796','53797','53798','53799','53800','53801','53802','53803','53804','53805','53806','53807','53808','53809','53810','53811','53812','53813','53814','53815','53816','53817','53818','53819','53820','53821','53822','53823','53824','53825','53826','53827','53828','53829','53830','53831','53832','53833','53834','53835','53836','53837','53838','53839','53840','53841') AND `class_id`='1'
SELECT name FROM prints_make WHERE `id`='148'
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE `name_full` LIKE "ZIL%" ORDER BY name_title
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='148'
216
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='148' 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`='148'
SELECT `id`, `tag` FROM tag WHERE `id` IN('168')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('29014')
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('29014')
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`=1 AND `id` IN('29014')
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 = 29014) 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`='29014'
SELECT `id`, `name`, `type` FROM nox_group