/var/www/html/nox-modules/prints
/lib/action/frontend
/printsSearchDefaultAction.action.php
main
SELECT COUNT(*) as `count` FROM prints_set WHERE id IN(SELECT DISTINCT set_id FROM prints_set_vector WHERE vector_id IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927))
SELECT `id`, `url`, `name_title`, `name_full`, `id_new`, `market`, `tier`, `update_date`, `segment` FROM prints_set WHERE id IN(SELECT DISTINCT set_id FROM prints_set_vector WHERE vector_id IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927)) LIMIT 0, 30
SELECT `prints_set`.`id`, `prints_set`.`url`, `prints_set`.`name_full`, COUNT(`vector_id`) c, MIN(`price`) price, IF((SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `prepay` = 0 AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1) IS NOT NULL, (SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `prepay` = 0 AND `bundle` = 0 AND `preview` != "" 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` = `prints_set`.`id`) AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1)) as preview, IF((SELECT `preview` FROM `prints_vector` WHERE `id` IN(SELECT `vector_id` FROM `prints_set_vector` WHERE `set_id` = `prints_set`.`id`) AND `prepay` = 0 AND `bundle` = 0 AND `preview` != "" ORDER BY CAST(JSON_EXTRACT(`prm`, "$.year") AS UNSIGNED) DESC LIMIT 1) IS NOT NULL, 1, 0) as vector FROM `prints_set` LEFT JOIN `prints_set_vector` ON `prints_set`.`id` = `prints_set_vector`.`set_id` LEFT JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set`.`id` IN(29453, 4476, 32563, 35497, 34665, 29455, 12277, 4470, 32108, 9282, 7094, 7160, 8590, 9269, 9271, 9304, 9313, 9317, 9327, 9362, 10331, 11630, 36356) GROUP BY `prints_set`.`id` ORDER BY IF(MAX(`prints_vector`.`preview`) IS NOT NULL AND MAX(`prints_vector`.`preview`) != '', 0, 1), `prints_set`.`name_full`
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 9269 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 36356 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 9271 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 29455 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 7160 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 9327 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 34665 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 29453 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 4476 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 12277 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 9282 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 8590 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 4470 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 7094 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 35497 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 9304 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 10331 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 9313 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 9317 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 9362 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 32563 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 11630 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT COUNT(*) cnt FROM `prints_set_vector` INNER JOIN `prints_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `prints_set_vector`.`set_id` = 32108 AND `prints_set_vector`.`vector_id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `prints_vector`.`bundle` = 0
SELECT `prints_vector`.* FROM `prints_vector` LEFT JOIN `prints_set_vector` ON `prints_vector`.`id` = `prints_set_vector`.`vector_id` WHERE `id` IN(83,84,85,86,87,102,116,117,118,120,122,124,292,293,294,295,296,299,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,734,735,736,737,738,739,740,838,864,865,1004,1005,1530,1531,2783,3594,3595,3596,3597,3598,3599,3600,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3617,3618,3619,3620,3621,3622,3623,3624,3625,3626,3627,3628,3629,3630,3631,3632,3633,3634,3635,3636,3637,3638,3639,3640,3641,6656,6657,6742,6743,6744,8244,8245,8246,8247,8973,8974,8975,8980,8981,8992,9014,9015,9018,9019,9028,9029,9031,9034,9037,9038,9041,9051,9052,9053,9054,9067,9068,9069,9070,9071,9072,9085,9086,9087,9088,9089,9090,10179,10180,10181,10182,10183,10184,11527,11528,12168,27833,28046,28047,28048,28049,28050,28051,28052,28053,28054,28803,29358,29359,29360,29616,29629,30711,31195,31925,31926,31927) AND `set_id` IS NULL ORDER BY IF(`prints_vector`.`preview` IS NOT NULL AND `prints_vector`.`preview` != '', 0, 1), `prepay`, `prints_vector`.`full_name` LIMIT 7
?q=Vauxhall&page=###page###
611
SELECT `id`, `name`, `type` FROM nox_group