/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`='opel' 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`='102'
SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('4114','4115','4116','4117','4118','4119','4120','4121','4122','4123','4124','4125','4126','4127','4128','4129','4130','4131','4132','4133','4134','4135','4136','4137','4138','4139','4140','4141','4142','4143','4144','4145','4146','4147','4148','4149','4150','4151','4152','4153','4154','4155','4156','4157','4158','4159','4160','4161','4162','4163','4164','4165','4166','4167','4168','4169','4170','4171','4172','4173','4174','4175','4176','4177','4178','4179','4180','4181','4182','4183','4184','4185','4186','4187','4188','4189','4190','4191','4192','4193','4194','4195','4196','4197','4198','8944','8945','8946','8947','8948','8949','8950','8951','8952','8953','8954','8955','8956','8957','8958','8959','8960','8961','8962','8963','8964','8965','8966','8967','8968','8969','8970','8971','8972','8973','8974','8975','8976','8977','8978','8979','8980','8981','8982','8983','8984','8985','8986','8987','8988','8989','8990','8991','8992','8993','8994','8995','8996','8997','8998','8999','9000','9001','9002','9003','9004','9005','9006','9007','9008','9009','9010','9011','9012','9013','9014','9015','9016','9017','11151','13146','13147','13347','14048','14049','14050','14051','14052','14053','14327','14328','14329','14330','14331','14332','14333','14334','14335','14336','14337','14338','14339','14340','14341','14342','14343','14344','14345','14346','14347','14348','14349','14350','14351','14352','14353','14354','14355','14356','14357','14358','14359','14360','14361','14362','14363','14364','14365','14366','14367','14368','14369','14370','14371','14372','14373','16314','16316','16459','16460','16461','16462','16508','16509','16510','16511','16512','16513','16514','17669','17670','17671','17672','17992','17993','17994','17995','18087','18088','18089','18090','18091','18092','18093','18197','18198','18199','18200','18201','18202','18203','18204','18210','18211','18335','18336','18337','18338','18339','18340','18341','18342','18343','18344','18351','18352','18353','18354','18355','18356','18357','18358','18359','18360','18361','18362','18363','18364','18365','18612','18613','18614','18615','18616','18617','18618','18749','18750','18773','18774','18785','18814','20179','20180','20181','20182','20183','20184','20185','20186','20187','20188','20189','20601','20602','20603','20604','20605','20606','20607','20608','20609','20610','20611','20612','20613','20614','20615','20616','20617','20618','20619','20620','20621','20622','20623','20624','20625','20626','20627','20628','20811','20812','20813','20814','20815','21058','21059','21060','21061','21062','21063','22046','22724','22725','22726','22727','22728','22729','22730','22731','22732','22733','22734','22735','22736','22737','22738','22739','22740','22741','22742','22743','22744','22745','22746','22747','22748','22749','24667','24668','24669','25980','25981','25982','25983','26898','26899','26900','26906','26907','26915','26916','26917','26921','26922','26923','26924','26925','26926','26928','26929','26930','26931','26932','26933','26940','26941','26944','26945','26954','26955','26958','26960','26963','26964','26968','26971','26972','26973','26974','26983','26984','26985','26986','26987','26988','27001','27002','27003','27004','27005','27006','27019','27020','27021','27022','30025','30026','30036','30037','30093','30094','30879','30880','30881','30882','30883','30884','30885','30886','31361','31362','31363','31364','31365','31366','31946','31947','31948','31949','31950','31951','45870','45878','45880','46114','46224','46225','46719','46850','46851','46852','46853','46854','46855','46856','46942','46963','47004','47547','47560','48243','48244','48431','49183','50742','51973','51974','51975','51976','51977','51978','51979','53186','53187','53188','53189','53190','53191','53192','53193','53194','53195','53196','53197','53198','53199','53200','53201','53202','53203','53204','53205','53206','53207','53208','53209','53210','53211','53212','53213','53214','53215','53216','53217','53218','53219','53220','53221','53222','53223','53224','53225','53226','53227','53228','53229','53230','53231','53232','53233','53234','53235','53236','53237','53238','53239','53240','53241','53242','53243','53244','53245','53246','53247','53248','59510','59511','59512','59513','59514','59515','59516','59517','59518','59519','59520','59521','59522','59523','59524','59525','59526','59527','59528','59529','59530','59531','59532','59533','59534','59535','59536','59537','59538','59539','59540','59541','59542','59543','59544','59545','59546','59547','59548','59549','59550','59551','59552','59553','59554','59555','59556','59557','59558','59559','59560','59561','59562','59563','59564','59565','59566','59567','59568','59569','59570','59571','59572','59573','59574','59575','59576','59577','59578','59579','59580','59581','59582','59583','59584','59585','59586','59587','59588','59589','59590','59591','59592','59593','59594','59595','59596','59597','59598','59599','59600','59601','59602','59603','59604','59605','59606','59607','59608','59609','59610','59611','59612','59613','59614','59615','59616','59617','59618','59619','59620','59621','59622','59623','59624','59625','59626','59627','59628','59629','59630','59631','59632','59633','59634','59635','59636','59637','59638','59639','59640','59641','59642','59643','59644','59645','59646','59647','59648','59649','59650','59651','59652','59653','59654','59655','59656','59657','59658','59659','59660','59661','59662','59663','59664','59665','59666','59667','59668','59669','59670','59671','59672','59673','59674','59675','59676','59677','59678','59679','59680','59681','59682','59683','59684','59685','59686','59687','59688','59689','59690','59691','59692','59693','59694','59695','59696','59697','59698','59699','59700','59701','59702','59703','59704','59705','59706','59707','59708','59709','59710','59711','59712','59713','59714','59715','59716','59717','59718','59719','59720','62054') AND `class_id`='1'
?page=###page###
SELECT COUNT(*) as `count` FROM brv_summary_cache WHERE `make_id`='102' AND `type` IN('0','1','2')
429
SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='102' AND `type` IN('0','1','2') 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`='1'
SELECT `id`, `tag` FROM tag WHERE `id` IN('91')
SELECT DISTINCT `purchase_id` FROM payment WHERE `status`='approved' AND `purchase_id` IN('79','80','81','82','174','175','176','177','178','179','180','284','285','286','287','288','289','290','291','297','298','422','423','424','425','426','427','428','429','430','431','438','439','440','441','442','443','444','445','446','447','448','449','450','451','452','699','700','701','702','703','704','705','836','837','860','861','872','901','2211','2212','2213','2214','2215','2216','2217','2218','2219','2220','2221','2633','2634','2635','2636','2637','2638','2639','2640','2641','2642','2643','2644','2645','2646','2647','2648','2649','2650','2651','2652','2653','2654','2655','2656','2657','2658','2659','2660','2843','2844','2845','2846','2847','3090','3091','3092','3093','3094','3095','4103','4793','4794','4795','4796','4797','4799','4800','4801','4802','4803','4804','4805','4806','4807','4808','4809','4810','4811','4812','4813','4814','4815','4816','4817','4818','6739','6740','6741','8052','8053','8054','8055','8970','8971','8972','8978','8979','8987','8988','8989','8993','8994','8995','8996','8997','8998','9000','9001','9002','9003','9004','9005','9012','9013','9016','9017','9026','9027','9030','9032','9035','9036','9040','9043','9044','9045','9046','9055','9056','9057','9058','9059','9060','9073','9074','9075','9076','9077','9078','9091','9092','9093','9094','12098','12099','12109','12110','12166','12167','12955','12956','12957','12958','12959','12960','12961','12962','13437','13438','13439','13440','13441','13442','14022','14023','14024','14025','14026','14027','27961','27969','27971','28213','28319','28320','28802','28933','28934','28935','28936','28937','28938','28939','29023','29044','29615','29628','30272','30273','30460','31194','31306','31889')
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 = 860)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 32574) 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`='32574'
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('699','700','701','702','703','704','705','860','861','872','901','2211','27961','29628') 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 = 427)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 35496) 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`='35496'
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('422','423','424','425','426','427','428','429','430','431','438','439','440','441','442','443','444','445','446','447','448','449','450','451','452','12955','12956','12957','12958','12959','12960','12961','12962','28802','31194') 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 = 2659)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29539) 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`='29539'
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('2633','2634','2635','2636','2637','2638','2639','2640','2641','2642','2643','2644','2645','2646','2647','2648','2649','2650','2651','2652','2653','2654','2655','2656','2657','2658','2659','2660','2843','2844') 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 = 2655)
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 = 704)
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 = 178)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 32562) 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`='32562'
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('174','175','176','177','178','179','180','284','285','286','287','288','289','290','291','297','298','3090','3091','3092','3093','3094','3095','28933','28934','28935','28936','28937','28938','28939','29615') 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 = 699)
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 = 703)
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 = 290)
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 = 452)
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 = 2213)
SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = 29568) 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`='29568'
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('79','80','81','82','2212','2213','2214','2215','2216','2217','2218','2219','2220','2221','2845','2846','2847') ORDER BY price LIMIT 0, 1
SELECT `id`, `name`, `type` FROM nox_group