/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`='car'

SELECT `id`, `class_id`, `country_id`, `url`, `name`, `logo`, `top`, `blueprints_count`, `vectors_count`, `downloads_count`, `purchases_count` FROM prints_make WHERE `url`='alfa-romeo' 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 (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`='3'

SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','112','113','114','115','116','117','118','119','5225','5226','5227','5228','5229','5230','5231','5232','5233','5234','5235','5236','5237','5238','5239','5240','5241','5242','5243','5244','5245','5246','5247','5248','5249','5250','5251','5252','5253','5254','5255','5256','5264','5265','5266','5267','5268','5269','5270','5271','5272','5273','5274','5275','5276','5277','5278','5279','5280','5281','5282','5283','5284','5285','5286','5287','5288','5289','5291','5292','5293','5294','5295','5296','5297','5298','5299','5300','5301','5302','5303','5304','5305','5306','5307','6364','6365','6366','6367','6368','6369','6370','6371','6372','6373','6374','6375','6376','6377','6378','6379','6380','6381','6382','6383','6384','6385','6386','6387','6388','6389','6390','6391','6392','6393','6394','6395','6396','6397','6398','6399','6400','6401','6402','6403','6404','6405','6406','6407','6408','6409','6410','6411','6412','6413','6414','6415','6416','6417','6418','6419','6420','6421','6422','6423','6424','6425','6426','6427','6428','6429','6430','6431','6432','6433','6434','6435','6436','6437','8005','9031','9032','9033','9034','9035','9036','12067','12068','12069','12070','12071','12072','12073','12074','12075','12585','12586','12587','12588','12589','12590','12591','12891','12892','12917','13218','13804','13805','14201','14202','14203','14204','14205','14206','14207','14208','14209','15296','15370','15371','15372','15373','15374','15375','15376','16067','16068','16069','16070','16071','16072','16073','16074','16075','16389','16906','16907','17142','17143','17249','17250','17251','17252','17253','17254','17255','17256','19481','22184','23311','23755','23756','23757','23758','23759','23760','23761','23762','23763','23764','23765','23766','23767','23768','23769','23770','23771','23772','23773','23774','23775','23776','23777','23778','23779','23780','23781','23782','23783','23784','23785','23786','23787','23788','23789','23790','23791','26515','26516','33708','33709','33710','33711','33712','33713','33714','33715','33716','33717','33718','33719','33720','33721','33722','33723','33724','33725','33726','33727','33728','33729','33730','33731','33732','33733','33734','33735','33736','33737','33738','33739','33740','33741','33742','33743','33744','46104','46204','47496','47620','48817','52302','52303','52304','52305','53966','53967','53968','53969','53970','53971','53972','53973','53974','53975','53976','53977','53978','53979','53980','53981','53982','53983','53984','53985','53986','53987','53988','53989','53990','53991','53992','53993','53994','53995','53996','53997','53998','53999','54000','54001','54002','54003','54004','54005','54006','54007','54008','54009','54010','54011','54012','54013','54014','54015','54016','54017','54018','54019','54020','54021','54022','54023','54024','54025','54026','54027','54028','54029','54030','54031','54032','54033','54034','54035','54036','54037','54038','54039','54040','54041','54042','54043','54044','54045','54046','54047','54048','54049','54050','54051','54052','54053','54054','54055','54056','54057','54058','54059','54060','54061','54062','54063','54064','54065','54066','54067','54068','54069','54070','54071','54072','54073','54074','54075','54076','54077','54078','54079','54080','54081','54082','54083','54084','54085','54086','54087','54088','54089','54090','54091','54092','54093','54094','54095','54096','54097','54098','54099','54100','54101','54102','54103','54104','54105','54106','54107','54108','54109','54110','54111','54112','54113','54114','54115','54116','54117','54118','54119','54120','62119') AND `class_id`='1'

?page=###page###

SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='3' AND `type` IN('0','1','2')

328

SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='3' AND `type` IN('0','1','2') ORDER BY `sort_name`, `type` LIMIT 300, 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`='1'

SELECT `id`, `tag` FROM tag WHERE `id` IN('91')

SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('1560','4253','5382','5827','5828','5829','5830','5831','5832','5833','5834','5835','5836','5837','5838','5839','5840','5841','5842','5843','5844','5845','5846','5847','5848','5849','5850','5851','5852','5853','5854','5855','5856','5857','5858','5859','5860','5861','5862','5863','8587','8588','15786','15787','15788','15789','15790','15791','15792','15793','15794','15795','15796','15797','15798','15799','15800','15801','15802','15803','15804','15805','15806','15807','15808','15809','15810','15811','15812','15813','15814','15815','15816','15817','15818','15819','15820','15821','15822','28203','28301','29564','29688','30836','31956')

SELECT set_id FROM prints_set_vector WHERE `vector_id`='15801'

SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='16586'

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 16586) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1

SELECT set_id FROM prints_set_vector WHERE `vector_id`='15794'

SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='31537'

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 31537) 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`='31537'

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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id` IN('5852','5853','15786','15787','15788','15789','15790','15791','15792','15793','15794','15795','15796','15797','15798','15799','15800') ORDER BY price LIMIT 0, 1

SELECT set_id FROM prints_set_vector WHERE `vector_id`='15801'

SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='16586'

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 16586) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1

SELECT set_id FROM prints_set_vector WHERE `vector_id`='15801'

SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='16586'

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 16586) AND `prepay` = 0 AND `bundle` = 0 ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 16586) 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`='16586'

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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id` IN('15801','15802') 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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `prepay`=0 AND `id` IN('1560','4253','5382','5827','5828','5829','5830','5831','5832','5833','5834','5835','5836','5837','5838','5839','5840','5841','5842','5843','5844','5845','5846','5847','5848','5849','5850','5851','5852','5853','5854','5855','5856','5857','5858','5859','5860','5861','5862','5863','8587','8588','15786','15787','15788','15789','15790','15791','15792','15793','15795','15796','15797','15798','15799','15800','15802','15803','15804','15805','15806','15807','15808','15809','15810','15811','15812','15813','15814','15815','15816','15817','15818','15819','15820','15821','15822','28203','28301','29564','29688','30836','31956')

SELECT set_id FROM prints_set_vector WHERE `vector_id`='5827'

SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='6505'

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 6505) 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`='6505'

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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id` IN('5827','5828','5829','5830','31956') ORDER BY price LIMIT 0, 1

SELECT set_id FROM prints_set_vector WHERE `vector_id`='30836'

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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='30836'

SELECT `id`, `name_full` FROM `prints_set` WHERE "1980 - 1985 alfa romeo gtv6 2.5 coupe" LIKE CONCAT(LOWER(`name_full`), "%") ORDER BY CHAR_LENGTH(`name_full`) DESC, `id` ASC LIMIT 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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id`='30836' ORDER BY price LIMIT 0, 1

SELECT set_id FROM prints_set_vector WHERE `vector_id`='5855'

SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `set_market_mid`, `tier`, `update_date`, `set_segment`, `set_market`, `set_body_segment` FROM prints_set WHERE `id`='34918'

SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 34918) 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`='34918'

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`, `item_market_mid`, `item_segment`, `tier`, `make_source`, `item_market`, `item_body_segment`, `make_source_id`, `make_source_filename` FROM prints_vector WHERE `id` IN('5855','5856','5857') ORDER BY price LIMIT 0, 1

SELECT `id`, `name`, `type` FROM nox_group