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

SELECT id, url, sort_name, full_name, views, prepay FROM prints_vector WHERE `item_id` IN('3117','3121','3123','3124','3126','3127','3130','3132','3134','3136','3138','3139','3140','3141','3142','3143','3144','3145','3146','3147','3148','3149','3150','3151','3152','3153','3154','3155','3156','3157','3159','3161','3163','3165','3172','3175','3178','3180','3185','3187','3189','3192','3195','3199','3201','3204','3206','3209','3211','3214','3216','3218','3219','3220','3221','3222','3223','3224','3227','3229','3230','3233','3236','3239','3242','3247','3250','3252','3254','3257','3260','3264','3268','3269','8814','8815','8816','8817','8818','8819','8820','8821','8822','8823','8824','8825','8826','8827','8828','8829','8830','8831','8832','8833','8834','8835','8836','8837','8838','8839','8840','8841','8842','8843','8844','8845','8846','8847','8848','8849','8850','8851','8852','8853','8854','8855','8856','8857','8858','8859','8860','8861','8862','8863','8864','8865','8866','8867','8868','8869','8870','8871','8872','8873','8874','8875','8876','8877','8878','8879','8880','8881','8882','8883','8884','8885','8886','8887','8888','8889','8890','8891','8892','8893','8894','8895','8896','8897','8898','8931','8932','8933','8934','13126','13127','13128','13129','13130','13319','13320','13321','13322','13323','13984','13985','13986','13987','13988','13989','13990','13991','13992','13993','13994','13995','13996','13997','13998','13999','15601','15602','15603','15604','16446','16447','16448','16449','17592','17593','17594','17595','17596','17597','17598','18691','18692','18693','18694','18695','18696','18697','18698','18699','18700','18701','18702','19452','19453','20088','20089','20090','20091','20092','20093','20094','20095','20096','20097','20098','20099','20100','20101','20102','21559','22011','22119','22141','22492','22493','22494','22495','22496','22497','22498','22499','22500','22501','22502','22503','22504','22505','22506','22507','22508','22509','22510','22511','22512','22513','22514','22515','22516','22517','22518','22519','22520','22521','22522','22523','22524','22525','22526','22527','22528','22529','22530','22531','22532','22533','22534','22535','22536','22537','22538','22539','22540','22541','22542','22543','22544','22545','22546','22547','22548','22549','22550','22551','24921','24922','24923','24924','24925','24926','24927','24928','24929','24930','24931','24932','24933','24934','24935','24936','24937','24938','24939','24940','24941','24942','24943','24944','24945','24946','24947','24948','24949','24950','24951','24952','24953','24954','24955','24956','24957','24958','24959','24960','24961','24962','24963','24964','24965','24966','24967','24968','24969','24970','24971','24972','24973','24974','24975','24976','24977','24978','24979','24980','24981','24982','24983','24984','24985','24986','24987','24988','24989','24990','24991','24992','24993','24994','24995','24996','24997','24998','24999','25000','25001','25002','25003','25004','25005','25006','25007','25008','25009','25010','25011','25012','25013','25014','25015','25016','25017','25018','25019','25020','25021','25022','25023','25024','25025','25026','25027','25028','25029','25030','25031','25032','25033','25034','25035','25036','25037','25038','25039','25040','25041','25042','25043','25044','25045','25046','25047','25048','25049','25050','25051','25052','25053','25054','25055','25056','25057','25066','25067','25068','25069','25070','25071','25072','25073','25074','25075','25076','25077','25078','25079','25080','25081','25082','25083','25084','25085','25086','25087','25088','25089','25090','25091','25092','25093','25094','25095','25096','25097','25098','25099','25100','25101','25102','25103','25104','25105','25106','25107','25108','25109','25110','25111','25112','25113','25114','25115','25122','25123','25124','25125','25126','25127','25128','25129','25130','25131','25132','25133','25134','25135','25136','25137','25146','25147','25148','25149','25150','25151','25152','25153','25154','25155','25156','25157','25158','25159','25160','25161','25162','25163','25170','25172','25173','25174','25175','25176','25177','25178','25179','25180','25181','25182','25183','25190','25191','25192','25193','25194','25195','25196','25197','25198','25199','25200','25201','25202','25203','25204','25205','25206','25207','25208','25209','25210','25211','25212','25213','25214','25215','25216','25217','25218','25219','25224','25225','25226','25227','25228','25229','25230','25231','25232','25233','25234','25235','25236','25237','25238','25239','25240','25241','25242','25243','25244','25245','25246','25247','25251','25252','25253','25254','25255','25256','25257','25258','25259','25260','25261','25262','25263','25264','25265','25266','25267','25268','25269','25270','25271','25272','25273','25274','25275','25276','25277','25278','25279','25280','25281','25282','25283','25284','25285','25286','25287','25288','25289','25290','25291','25292','25293','25294','25295','25296','25297','25298','25299','25300','25301','25302','25303','25304','25305','25306','25307','25308','25309','25311','25312','25313','25314','25315','25316','25317','25318','25319','25320','25321','25322','25323','25324','25325','25326','25327','25328','25329','25330','25331','25332','25333','25334','25335','25336','25337','25338','25339','25340','25341','25342','25343','25344','25345','25346','25347','25348','25349','25350','25351','25352','25353','25354','25355','25356','25357','26077','26078','26083','26084','26087','26088','26580','27885','27886','27887','27888','27889','27890','27968','27969','32590','32591','32592','32593','32594','32595','32596','32597','32598','32599','32600','32601','32602','32603','32604','32605','32606','32607','32608','32609','32610','32611','32612','32613','32614','32615','32616','32617','32618','32619','32620','32621','32622','32623','32624','32625','32626','32627','32628','32629','32630','32631','32632','32633','32634','32635','32636','32637','32638','32639','32640','32641','32642','32643','32644','32645','32646','32647','32648','32649','32650','32651','32652','32653','32654','32655','32656','32657','32658','32659','32660','32661','32662','32663','32664','32665','32666','32667','32668','32669','32670','32671','32672','32673','32674','45743','46228','46293','46294','46411','46712','46713','47942','48044','48045','48046','48213','48214','48215','48359','48363','48399','48400','48401','48402','48403','48739','49007','49197','49198','49200','49201','50205','50206','50207','50208','50209','50210','50211','50212','50213','50214','50215','50216','50217','50218','50219','50220','50221','50828','50910','51561','51562','51563','51564','51565','51566','51567','51568','51569','51570','51571','51572','51573','51574','51575','51576','51577','51578','51579','51580','51581','51582','51583','51584','51585','51586','51587','51588','51589','51590','51591','51592','51593','51594','51595','51596','51597','51598','51599','51600','51601','51602','51603','51604','58626','58627','58628','58629','58630','58631','58632','58633','58634','58635','58636','58637','58638','58639','58640','58641','58642','58643','58644','58645','58646','58647','58648','58649','58650','58651','58652','58653','58654','58655','58656','58657','58658','58659','58660','58661','58662','58663','58664','58665','58666','58667','58668','58669','58670','58671','58672','58673','58674','58675','58676','58677','58678','58679','58680','58681','58682','58683','58684','58685','58686','58687','58688','58689','58690','58691','58692','58693','58694','58695','58696','58697','58698','58699','58700','58701','58702','58703','58704','58705','58706','58707','58708','58709','58710','58711','58712','58713','58714','58715','58716','58717','58718','58719','58720','58721','58722','58723','58724','58725','58726','58727','58728','58729','58730','58731','58732','58733','58734','58735','58736','58737','58738','58739','58740','58741','58742','58743','58744','58745','58746','58747','58748','61883','62065') AND `class_id`='1'

?page=###page###

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

802

SELECT `id`, `name`, `full_name`, `sort_name`, `make_id`, `url`, `views`, `type` FROM brv_summary_cache WHERE `make_id`='89' AND `type` IN('0','1','2') ORDER BY `sort_name`, `type` LIMIT 800, 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('778','779','780','781','782','783','784','785','786','787','788','789','1541','1542','2120','2121','2122','2123','2124','2125','2126','2127','2128','2129','2130','2131','2132','2133','3591','4060','4180','4206','4561','4562','4563','4564','4565','4566','4567','4568','4569','4570','4571','4572','4573','4575','4576','4577','4578','4580','4581','4582','4583','4584','4585','4586','4587','4588','4589','4590','4591','4592','4593','4594','4595','4596','4597','4598','4599','4600','4601','4602','4603','4604','4605','4606','4607','4608','4609','4610','4611','4612','4613','4614','4615','4616','4617','4618','4619','6993','6994','6995','6996','6997','6998','6999','7000','7001','7002','7003','7004','7005','7006','7007','7008','7009','7010','7011','7012','7013','7014','7015','7016','7017','7018','7019','7020','7021','7022','7023','7024','7025','7026','7027','7028','7029','7030','7031','7032','7033','7034','7035','7036','7037','7038','7039','7040','7041','7042','7043','7044','7045','7046','7047','7048','7049','7050','7051','7052','7053','7054','7055','7056','7057','7058','7059','7060','7061','7062','7063','7064','7065','7066','7067','7068','7069','7070','7071','7072','7073','7074','7075','7076','7077','7078','7079','7080','7081','7082','7083','7084','7085','7086','7087','7088','7089','7090','7091','7092','7093','7094','7095','7096','7097','7098','7099','7100','7101','7102','7103','7104','7105','7106','7107','7108','7109','7110','7111','7112','7113','7114','7115','7116','7117','7118','7119','7120','7121','7122','7123','7124','7125','7126','7127','7128','7129','7138','7139','7140','7141','7142','7143','7144','7145','7146','7147','7148','7149','7150','7151','7152','7153','7154','7155','7156','7157','7158','7159','7160','7161','7162','7163','7164','7165','7166','7167','7168','7169','7170','7171','7172','7173','7174','7175','7176','7177','7178','7179','7180','7181','7182','7183','7184','7185','7186','7187','7194','7195','7196','7197','7198','7199','7200','7201','7202','7203','7204','7205','7206','7207','7208','7209','7218','7219','7220','7221','7222','7223','7224','7225','7226','7227','7228','7229','7230','7231','7232','7233','7234','7235','7242','7244','7245','7246','7247','7248','7249','7250','7251','7252','7253','7254','7255','7262','7263','7264','7265','7266','7267','7268','7269','7270','7271','7272','7273','7274','7275','7276','7277','7278','7279','7280','7281','7282','7283','7284','7285','7286','7287','7288','7289','7290','7291','7296','7297','7298','7299','7300','7301','7302','7303','7304','7305','7306','7307','7308','7309','7310','7311','7312','7313','7314','7315','7316','7317','7318','7319','7323','7324','7325','7326','7327','7328','7329','7330','7331','7332','7333','7334','7335','7336','7337','7338','7339','7340','7341','7342','7343','7344','7345','7346','7347','7348','7349','7350','7351','7352','7353','7354','7355','7356','7357','7358','7359','7360','7361','7362','7363','7364','7365','7366','7367','7368','7369','7370','7371','7372','7373','7374','7375','7376','7377','7378','7379','7380','7381','7383','7384','7386','7387','7388','7389','7390','7391','7392','7393','7394','7395','7396','7397','7398','7399','7400','7401','7402','7403','7404','7405','7406','7407','7408','7409','7410','7411','7412','7413','7414','7415','7416','7417','7418','7419','7420','7421','7422','7423','7424','7425','7426','7427','7428','7429','8149','8150','8155','8156','8159','8160','8652','9957','9958','9959','9960','9961','9962','10040','10041','14666','14667','14668','14669','14670','14671','14673','14674','14675','14676','14677','14678','14679','14680','14682','14683','14684','14685','14686','14687','14688','14689','14690','14691','14692','14693','14694','14695','14696','14697','14698','14699','14700','14701','14702','14703','14704','14705','14706','14707','14708','14709','14710','14711','14712','14713','14714','14715','14716','14717','14718','14719','14720','14721','14722','14723','14724','14725','14726','14727','14728','14729','14730','14731','14732','14733','14734','14735','14736','14737','14738','14739','14740','14741','14742','14743','14744','14745','14746','14747','14748','14749','14750','27821','28378','28379','28496','28795','28796','29991','30084','30085','30086','30243','30244','30245','30388','30392','30428','30429','30430','30431','30432','30759','31026','31208','31211','31212','31385','31467','31717','31901')

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 = 4565)

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

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('3591','4561','4562','4563','4564','4565','31717') 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 = 779)

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

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('778','779','780','781','782','783','784','785','786','787','788','789','31026') 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 = 4594)

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

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('4584','4585','4586','4587','4588','4589','4590','4591','4592','4593','4594','4595') 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 = 30086)

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

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('4566','4568','4570','4571','4572','4573','4575','4582','30084','30085','30086') 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 = 4564)

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 = 4563)

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 = 788)

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 = 4613)

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

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('4613','4615','4616','28496') ORDER BY price LIMIT 0, 1

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