Db error: Unknown column 'catalog_models.ID' in 'where clause'
Error code: 1054
Query: SELECT DISTINCT MIN(catalog_fast_models.Price), MAX(catalog_fast_models.Price) FROM catalog_fast_models WHERE catalog_fast_models.Domains = ? AND catalog_models.ID IN (556822,592329,592330,592331,592294,557183,559805,559842,560205,560206,560270,560271,560272,560313,592343,564052,593769,593480,564368,564590,564591,564595,564674,564675,582703,582704,582705,583098,583099,583527,583992,585162,586160,586161,586179,586180,586181,586224,586587,586588,586655,586841,586852,586853,586854,587078,587279,587280,587281,592117,592118,592156,592157,592158,592189,592191,592192,592234,592287,592442,592844,592845,592847,592848,592849,592850,592851,592853,592854,592913,592914,592926,593018,593015,593016,593017,593019,593030,593190,593345,593346,593464,593485,593850,593741,593728,593742,594391,594392,594393,593943,593944,593965,593976,594035,594330,594390,594394,594409,594449,594506,594546,594547,594548,594549,701811,704505,704500,703894,682736,704496,623172,623200,623237,623889,624060,624107,624140,624226,624338,624422,624454,624457,624616,624766,624837,624875,624955,625077,625199,625213,625612,625706,625836,626027,626097,626167,626174,627021,627722,628024,628372,691233,691238,691259,702158,681432,681439,664083,664088,664141,686485,686486,701685,701686,701688,665746,703546,680528,705624,707135,682829,682832,682844,704805,671273,674583,686521,686541,686742,679150,703408,703409,670353,658739,658742,682333,658931,677810,676171,676176,678658,702926,703775,701753,686220,686471,686472,686479,686480,686481,686482,686465,686466,662875,662876,662881,703224,702098,687796,680259,680165,667343,704119,704120,704122,704112,704113,704114,704116,704777,681635,681651,681654,687643,687644,702003,687713,660459,660477,660537,687832,687833,679246,701335,703903,703896,703125,687356,687358,687362,687364,687368,687370,687372,687374,687376,687378,687380,703122,683369,687944,672464,659663,659740,677131,706004,706007,706014,706015,706021,683764,676746,701271,687432,687433,668067,687384,705108,704395,682557,704988,704998,704999,682627,675723,690514,702095,701281,686276,653223,690245,690246,690326,690459,702944,702945,702943,702143,702151,704969,691561,697683,692159,692161,692163,692167,692168,700022,699995,699997,692447,699604,699516,699517,699518,693460,694049,698686,698674,698671,698666,698535,698534,698402,698414,698386,698357,695369,695475,697796,697802,696072,696121,707681,707763,708025,708064,709108,709294,709326,709403,710345,710442,710443,710608,710771,711589,711590,720950,720825,712719,712958,713803,713815,713818,713827,713842,713847,714521,714667,715173,715201,715204,720735,720734,715490,715497,715619,715967,716767,716966,718039,718290,718364,718752,718905,719073,719092,719128,719132,719134,719138,719152,719159,719313,719314,719408,719412,719416,719418,719421,719608,719613,719615,719747,719748,719750,719751,719834,719905,719906,719931,719962,721400,721891,721893,721895,721896,722170,722173,722285,722418,722463,722577,722579,722594,722668,723120,723148,723469,723569,723677,724388,724389,724371,724364,724321,724016,724471,724472,724525) AND catalog_fast_models.Price > 0
Db error: Unknown column 'catalog_models.ID' in 'where clause'
Error code: 1054
Query: SELECT DISTINCT catalog_cats.ID,catalog_cats.Parent,catalog_cats.Name,catalog_cats.Code,catalog_cats.Image,catalog_cats.Image2,catalog_cats.FontIcon,catalog_cats.SingleName,catalog_cats.AllName,catalog_cats.FilterName,catalog_cats.H,catalog_cats.SortIndex,catalog_cats.Hide,catalog_cats.DiscountID,catalog_cats.PseudoID,catalog_cats.NameShort,catalog_cats.Title,catalog_cats.Keywords,catalog_cats.Description,catalog_cats.NoIndex,catalog_cats.ModelTitleTemplate,catalog_cats.ModelDescriptionTemplate,catalog_cats.ModelH1Template,catalog_cats.OfferType,catalog_cats.SalesNotes,catalog_cats.BrandWarranty,catalog_cats.YmlPriceTypeID,catalog_cats.Domains,catalog_cats.ImportID,catalog_cats.DisablePaymentSystems,catalog_cats.DisableDeliveries,catalog_cats.NumModels,catalog_cats.NumModelsRaw,catalog_cats.NumModelsCp,catalog_cats.ModifiedDate,catalog_cats.SearchSyn,catalog_cats.NumBindings,catalog_cats.ClassName,catalog_cats.NumGifts,catalog_cats.NaToStatus,catalog_cats.NaToStatusDiscountID,catalog_cats.NameLocative,catalog_cats.BaseUnit,catalog_cats.Weight,catalog_cats.WeightBrutto,catalog_cats.Volume,catalog_cats.Length,catalog_cats.Width,catalog_cats.Height,catalog_cats.ReviewsBlockHeader,catalog_cats.Source,catalog_cats.LocalDeliveryCost,catalog_cats.SortByProp,catalog_cats.PriceTypeID,catalog_cats.WearType,catalog_cats.Tnved,catalog_cats.MandatoryMark FROM catalog_cats INNER JOIN catalog_fast_models ON catalog_fast_models.CatID = catalog_cats.ID
LEFT JOIN catalog_num_models
ON catalog_num_models.Resource = 'iCatalogCategory'
AND catalog_num_models.ResourceID = catalog_cats.ID
AND catalog_num_models.Domain = 75 WHERE catalog_fast_models.Domains = ? AND catalog_models.ID IN (556822,592329,592330,592331,592294,557183,559805,559842,560205,560206,560270,560271,560272,560313,592343,564052,593769,593480,564368,564590,564591,564595,564674,564675,582703,582704,582705,583098,583099,583527,583992,585162,586160,586161,586179,586180,586181,586224,586587,586588,586655,586841,586852,586853,586854,587078,587279,587280,587281,592117,592118,592156,592157,592158,592189,592191,592192,592234,592287,592442,592844,592845,592847,592848,592849,592850,592851,592853,592854,592913,592914,592926,593018,593015,593016,593017,593019,593030,593190,593345,593346,593464,593485,593850,593741,593728,593742,594391,594392,594393,593943,593944,593965,593976,594035,594330,594390,594394,594409,594449,594506,594546,594547,594548,594549,701811,704505,704500,703894,682736,704496,623172,623200,623237,623889,624060,624107,624140,624226,624338,624422,624454,624457,624616,624766,624837,624875,624955,625077,625199,625213,625612,625706,625836,626027,626097,626167,626174,627021,627722,628024,628372,691233,691238,691259,702158,681432,681439,664083,664088,664141,686485,686486,701685,701686,701688,665746,703546,680528,705624,707135,682829,682832,682844,704805,671273,674583,686521,686541,686742,679150,703408,703409,670353,658739,658742,682333,658931,677810,676171,676176,678658,702926,703775,701753,686220,686471,686472,686479,686480,686481,686482,686465,686466,662875,662876,662881,703224,702098,687796,680259,680165,667343,704119,704120,704122,704112,704113,704114,704116,704777,681635,681651,681654,687643,687644,702003,687713,660459,660477,660537,687832,687833,679246,701335,703903,703896,703125,687356,687358,687362,687364,687368,687370,687372,687374,687376,687378,687380,703122,683369,687944,672464,659663,659740,677131,706004,706007,706014,706015,706021,683764,676746,701271,687432,687433,668067,687384,705108,704395,682557,704988,704998,704999,682627,675723,690514,702095,701281,686276,653223,690245,690246,690326,690459,702944,702945,702943,702143,702151,704969,691561,697683,692159,692161,692163,692167,692168,700022,699995,699997,692447,699604,699516,699517,699518,693460,694049,698686,698674,698671,698666,698535,698534,698402,698414,698386,698357,695369,695475,697796,697802,696072,696121,707681,707763,708025,708064,709108,709294,709326,709403,710345,710442,710443,710608,710771,711589,711590,720950,720825,712719,712958,713803,713815,713818,713827,713842,713847,714521,714667,715173,715201,715204,720735,720734,715490,715497,715619,715967,716767,716966,718039,718290,718364,718752,718905,719073,719092,719128,719132,719134,719138,719152,719159,719313,719314,719408,719412,719416,719418,719421,719608,719613,719615,719747,719748,719750,719751,719834,719905,719906,719931,719962,721400,721891,721893,721895,721896,722170,722173,722285,722418,722463,722577,722579,722594,722668,723120,723148,723469,723569,723677,724388,724389,724371,724364,724321,724016,724471,724472,724525) AND catalog_cats.Code NOT REGEXP '\/|\:' AND (catalog_cats.Domains = '' OR FIND_IN_SET('75', catalog_cats.Domains)) AND catalog_cats.Hide = ? AND (catalog_num_models.NumModels IS NULL OR catalog_num_models.NumModels > 0)
Params: Array
(
[0] =>
[1] =>
)
Db error: Unknown column 'catalog_models.ID' in 'where clause'
Error code: 1054
Query: SELECT DISTINCT catalog_brands.ID,catalog_brands.Parent,catalog_brands.Name,catalog_brands.Code,catalog_brands.LocationID,catalog_brands.CountryOriginID,catalog_brands.Image,catalog_brands.H,catalog_brands.SortIndex,catalog_brands.Hide,catalog_brands.DiscountID,catalog_brands.Title,catalog_brands.Keywords,catalog_brands.Description,catalog_brands.NoIndex,catalog_brands.ModelTitleTemplate,catalog_brands.ModelDescriptionTemplate,catalog_brands.ModelH1Template,catalog_brands.Domains,catalog_brands.ImportID,catalog_brands.SalesNotes,catalog_brands.BrandWarranty,catalog_brands.NumModels,catalog_brands.NumModelsRaw,catalog_brands.NumModelsCp,catalog_brands.ModifiedDate,catalog_brands.SearchSyn,catalog_brands.PriceList,catalog_brands.PresentationID,catalog_brands.Images,catalog_brands.NumBindings,catalog_brands.NumGifts,catalog_brands.NaToStatus,catalog_brands.NaToStatusDiscountID,catalog_brands.Source,catalog_brands.LocalDeliveryCost FROM catalog_brands INNER JOIN catalog_fast_models ON catalog_fast_models.BrandID = catalog_brands.ID WHERE catalog_fast_models.Domains = ? AND catalog_models.ID IN (556822,592329,592330,592331,592294,557183,559805,559842,560205,560206,560270,560271,560272,560313,592343,564052,593769,593480,564368,564590,564591,564595,564674,564675,582703,582704,582705,583098,583099,583527,583992,585162,586160,586161,586179,586180,586181,586224,586587,586588,586655,586841,586852,586853,586854,587078,587279,587280,587281,592117,592118,592156,592157,592158,592189,592191,592192,592234,592287,592442,592844,592845,592847,592848,592849,592850,592851,592853,592854,592913,592914,592926,593018,593015,593016,593017,593019,593030,593190,593345,593346,593464,593485,593850,593741,593728,593742,594391,594392,594393,593943,593944,593965,593976,594035,594330,594390,594394,594409,594449,594506,594546,594547,594548,594549,701811,704505,704500,703894,682736,704496,623172,623200,623237,623889,624060,624107,624140,624226,624338,624422,624454,624457,624616,624766,624837,624875,624955,625077,625199,625213,625612,625706,625836,626027,626097,626167,626174,627021,627722,628024,628372,691233,691238,691259,702158,681432,681439,664083,664088,664141,686485,686486,701685,701686,701688,665746,703546,680528,705624,707135,682829,682832,682844,704805,671273,674583,686521,686541,686742,679150,703408,703409,670353,658739,658742,682333,658931,677810,676171,676176,678658,702926,703775,701753,686220,686471,686472,686479,686480,686481,686482,686465,686466,662875,662876,662881,703224,702098,687796,680259,680165,667343,704119,704120,704122,704112,704113,704114,704116,704777,681635,681651,681654,687643,687644,702003,687713,660459,660477,660537,687832,687833,679246,701335,703903,703896,703125,687356,687358,687362,687364,687368,687370,687372,687374,687376,687378,687380,703122,683369,687944,672464,659663,659740,677131,706004,706007,706014,706015,706021,683764,676746,701271,687432,687433,668067,687384,705108,704395,682557,704988,704998,704999,682627,675723,690514,702095,701281,686276,653223,690245,690246,690326,690459,702944,702945,702943,702143,702151,704969,691561,697683,692159,692161,692163,692167,692168,700022,699995,699997,692447,699604,699516,699517,699518,693460,694049,698686,698674,698671,698666,698535,698534,698402,698414,698386,698357,695369,695475,697796,697802,696072,696121,707681,707763,708025,708064,709108,709294,709326,709403,710345,710442,710443,710608,710771,711589,711590,720950,720825,712719,712958,713803,713815,713818,713827,713842,713847,714521,714667,715173,715201,715204,720735,720734,715490,715497,715619,715967,716767,716966,718039,718290,718364,718752,718905,719073,719092,719128,719132,719134,719138,719152,719159,719313,719314,719408,719412,719416,719418,719421,719608,719613,719615,719747,719748,719750,719751,719834,719905,719906,719931,719962,721400,721891,721893,721895,721896,722170,722173,722285,722418,722463,722577,722579,722594,722668,723120,723148,723469,723569,723677,724388,724389,724371,724364,724321,724016,724471,724472,724525) AND (catalog_brands.Domains = '' OR FIND_IN_SET('75', catalog_brands.Domains)) AND catalog_brands.Hide = ?
Params: Array
(
[0] =>
[1] =>
)
Db error: Unknown column 'catalog_models.ID' in 'where clause'
Error code: 1054
Query: SELECT catalog_props_values.PropID, catalog_props_values.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_props_values INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_props_values.ModelID WHERE catalog_props_values.PropID IN (190,181,184,191,226,227,231,236,237,240,967,1034,1069,1164,1165,1166,1167) AND catalog_fast_models.Domains = ? AND catalog_models.ID IN (556822,592329,592330,592331,592294,557183,559805,559842,560205,560206,560270,560271,560272,560313,592343,564052,593769,593480,564368,564590,564591,564595,564674,564675,582703,582704,582705,583098,583099,583527,583992,585162,586160,586161,586179,586180,586181,586224,586587,586588,586655,586841,586852,586853,586854,587078,587279,587280,587281,592117,592118,592156,592157,592158,592189,592191,592192,592234,592287,592442,592844,592845,592847,592848,592849,592850,592851,592853,592854,592913,592914,592926,593018,593015,593016,593017,593019,593030,593190,593345,593346,593464,593485,593850,593741,593728,593742,594391,594392,594393,593943,593944,593965,593976,594035,594330,594390,594394,594409,594449,594506,594546,594547,594548,594549,701811,704505,704500,703894,682736,704496,623172,623200,623237,623889,624060,624107,624140,624226,624338,624422,624454,624457,624616,624766,624837,624875,624955,625077,625199,625213,625612,625706,625836,626027,626097,626167,626174,627021,627722,628024,628372,691233,691238,691259,702158,681432,681439,664083,664088,664141,686485,686486,701685,701686,701688,665746,703546,680528,705624,707135,682829,682832,682844,704805,671273,674583,686521,686541,686742,679150,703408,703409,670353,658739,658742,682333,658931,677810,676171,676176,678658,702926,703775,701753,686220,686471,686472,686479,686480,686481,686482,686465,686466,662875,662876,662881,703224,702098,687796,680259,680165,667343,704119,704120,704122,704112,704113,704114,704116,704777,681635,681651,681654,687643,687644,702003,687713,660459,660477,660537,687832,687833,679246,701335,703903,703896,703125,687356,687358,687362,687364,687368,687370,687372,687374,687376,687378,687380,703122,683369,687944,672464,659663,659740,677131,706004,706007,706014,706015,706021,683764,676746,701271,687432,687433,668067,687384,705108,704395,682557,704988,704998,704999,682627,675723,690514,702095,701281,686276,653223,690245,690246,690326,690459,702944,702945,702943,702143,702151,704969,691561,697683,692159,692161,692163,692167,692168,700022,699995,699997,692447,699604,699516,699517,699518,693460,694049,698686,698674,698671,698666,698535,698534,698402,698414,698386,698357,695369,695475,697796,697802,696072,696121,707681,707763,708025,708064,709108,709294,709326,709403,710345,710442,710443,710608,710771,711589,711590,720950,720825,712719,712958,713803,713815,713818,713827,713842,713847,714521,714667,715173,715201,715204,720735,720734,715490,715497,715619,715967,716767,716966,718039,718290,718364,718752,718905,719073,719092,719128,719132,719134,719138,719152,719159,719313,719314,719408,719412,719416,719418,719421,719608,719613,719615,719747,719748,719750,719751,719834,719905,719906,719931,719962,721400,721891,721893,721895,721896,722170,722173,722285,722418,722463,722577,722579,722594,722668,723120,723148,723469,723569,723677,724388,724389,724371,724364,724321,724016,724471,724472,724525) GROUP BY catalog_props_values.ValID ORDER BY filter_num DESC
Db error: Unknown column 'catalog_models.ID' in 'where clause'
Error code: 1054
Query: SELECT catalog_mods_params.PropID, catalog_mods_params.ValID, COUNT(DISTINCT catalog_fast_models.ID) as filter_num FROM catalog_mods_params INNER JOIN catalog_mods ON catalog_mods.ID = catalog_mods_params.ModID INNER JOIN catalog_fast_models ON catalog_fast_models.ID = catalog_mods_params.ModelID WHERE catalog_mods_params.PropID IN (954) AND catalog_fast_models.Domains = ? AND catalog_models.ID IN (556822,592329,592330,592331,592294,557183,559805,559842,560205,560206,560270,560271,560272,560313,592343,564052,593769,593480,564368,564590,564591,564595,564674,564675,582703,582704,582705,583098,583099,583527,583992,585162,586160,586161,586179,586180,586181,586224,586587,586588,586655,586841,586852,586853,586854,587078,587279,587280,587281,592117,592118,592156,592157,592158,592189,592191,592192,592234,592287,592442,592844,592845,592847,592848,592849,592850,592851,592853,592854,592913,592914,592926,593018,593015,593016,593017,593019,593030,593190,593345,593346,593464,593485,593850,593741,593728,593742,594391,594392,594393,593943,593944,593965,593976,594035,594330,594390,594394,594409,594449,594506,594546,594547,594548,594549,701811,704505,704500,703894,682736,704496,623172,623200,623237,623889,624060,624107,624140,624226,624338,624422,624454,624457,624616,624766,624837,624875,624955,625077,625199,625213,625612,625706,625836,626027,626097,626167,626174,627021,627722,628024,628372,691233,691238,691259,702158,681432,681439,664083,664088,664141,686485,686486,701685,701686,701688,665746,703546,680528,705624,707135,682829,682832,682844,704805,671273,674583,686521,686541,686742,679150,703408,703409,670353,658739,658742,682333,658931,677810,676171,676176,678658,702926,703775,701753,686220,686471,686472,686479,686480,686481,686482,686465,686466,662875,662876,662881,703224,702098,687796,680259,680165,667343,704119,704120,704122,704112,704113,704114,704116,704777,681635,681651,681654,687643,687644,702003,687713,660459,660477,660537,687832,687833,679246,701335,703903,703896,703125,687356,687358,687362,687364,687368,687370,687372,687374,687376,687378,687380,703122,683369,687944,672464,659663,659740,677131,706004,706007,706014,706015,706021,683764,676746,701271,687432,687433,668067,687384,705108,704395,682557,704988,704998,704999,682627,675723,690514,702095,701281,686276,653223,690245,690246,690326,690459,702944,702945,702943,702143,702151,704969,691561,697683,692159,692161,692163,692167,692168,700022,699995,699997,692447,699604,699516,699517,699518,693460,694049,698686,698674,698671,698666,698535,698534,698402,698414,698386,698357,695369,695475,697796,697802,696072,696121,707681,707763,708025,708064,709108,709294,709326,709403,710345,710442,710443,710608,710771,711589,711590,720950,720825,712719,712958,713803,713815,713818,713827,713842,713847,714521,714667,715173,715201,715204,720735,720734,715490,715497,715619,715967,716767,716966,718039,718290,718364,718752,718905,719073,719092,719128,719132,719134,719138,719152,719159,719313,719314,719408,719412,719416,719418,719421,719608,719613,719615,719747,719748,719750,719751,719834,719905,719906,719931,719962,721400,721891,721893,721895,721896,722170,722173,722285,722418,722463,722577,722579,722594,722668,723120,723148,723469,723569,723677,724388,724389,724371,724364,724321,724016,724471,724472,724525) AND catalog_mods.Q > 0 AND catalog_mods.Status != 200 GROUP BY catalog_mods_params.ValID ORDER BY filter_num DESC