Browse Stores
[Cube\Exception]
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #59 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'yourbidz_v8.l.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [Query]: SELECT u.*, l.id AS listing_id FROM ppb_users AS u LEFT JOIN ppb_listings AS l ON l.user_id = u.id WHERE (u.store_category_id IN (3686, 5027, 5028, 5029, 5030, 5031, 5032, 5033, 5034, 5035, 5036, 5037, 5038, 5039, 5040, 5041, 5042, 5043, 5044, 5045, 5046, 5047, 5048, 5049, 5050, 5072, 5051, 5052, 5054, 5055, 5056, 5057, 5058, 5059, 5060, 5061, 5062, 5063, 5064, 5065, 5066, 5067, 5068, 5069, 5070, 5071, 5073, 5074, 5075, 5076, 5077, 5078, 5081, 5079, 5080, 5082, 5083, 5084, 5085, 5086, 5087, 5088, 5091, 5089, 5090, 5092, 5093, 5094, 5095, 5096, 5097, 5098, 5099, 5100, 5101, 5102, 5103, 5104, 5105, 5106, 5107, 5108, 5111, 5112, 5109, 5110, 5113, 5114, 5115, 5127, 5116, 5117, 5118, 5119, 5120, 5121, 5122, 5129, 5123, 5124, 5128, 5125, 5126, 5133, 5134, 5130, 5135, 5136, 5137, 5138, 5139, 5140, 5141, 5142, 5131, 5143, 5144, 5132, 5145, 5146, 5156, 5147, 5148, 5149, 5150, 5151, 5152, 5153, 5154, 5155, 5157, 5158, 5159, 5160, 5161, 5162, 5166, 5163, 5164, 5165, 5167, 5168, 5169, 5172, 5171, 5170, 5173, 5174, 5175, 5176, 5177, 5178, 5179, 5206, 5180, 5181, 5182, 5207, 5208, 5209, 5210, 5211, 5183, 5184, 5185, 5186, 5187, 5188, 5189, 5212, 5191, 5192, 5193, 5194, 5195, 5196, 5197, 5214, 5213, 5198, 5199, 5200, 5201, 5190, 5204, 5202, 5203, 5205, 5215, 5216, 5217, 5218, 5219, 5220, 5221, 5222, 5223, 5224, 5225, 5226, 5227, 5228, 5229, 5230, 5231, 5233, 5232, 5234, 5235, 5236, 5237, 5241, 5238, 5239, 5240, 5242, 5244, 5243, 5245, 5246, 5247, 5249, 5248, 5250, 5255, 5251, 5252, 5253, 5254, 5256, 5257, 5258, 5273, 5259, 5260, 5261, 5262, 5263, 5264, 5265, 5266, 5267, 5268, 5269, 5270, 5271, 5272, 5296, 5297, 5298, 5299, 5300, 5302, 5301, 5274, 5276, 5275, 5277, 5278, 5279, 5280, 5281, 5282, 5283, 5284, 5285, 5286, 5287, 5295, 5288, 5289, 5290, 5291, 5293, 5294, 5303, 5304, 5305, 5306, 5307, 5313, 5308, 5309, 5310, 5311, 5312, 5318, 5322, 5323, 5324, 5326, 5316, 5314, 5317, 5328, 5315, 5325, 5327, 5320, 5330, 5329, 5319, 5321, 5331, 5332, 5333, 5334, 5335, 5336, 5337, 5338, 5339, 5345, 5340, 5346, 5341, 5342, 5343, 5344, 5347, 5348, 5349, 5350, 5351, 5357, 5353, 5352, 5354, 5355, 5356, 5363, 5364, 5365, 5366, 5367, 5368, 5369, 5370, 5395, 5371, 5372, 5373, 5374, 5375, 5376, 5377, 5378, 5379, 5380, 5381, 5382, 5397, 5383, 5384, 5396, 5385, 5386, 5387, 5388, 5389, 5390, 5391, 5392, 5393, 5394, 5403, 5398, 5400, 5399, 5401, 5402, 5404, 5405, 5406, 5407, 5408, 5409, 5410, 5412, 5411, 5413, 5414, 5415, 5416, 5417, 5420, 5419, 5418, 5436, 5425, 5423, 5421, 5424, 5422, 5437, 5438, 5427, 5428, 5429, 5430, 5431, 5432, 5433, 5434, 5435, 5426, 5439, 5440, 5441, 5442, 5443, 5444, 5445, 5446, 5456, 5447, 5448, 5449, 5450, 5452, 5453, 5451, 5454, 5455, 5457, 5458, 5459, 5463, 5460, 5461, 5462, 5464, 5465, 5467, 5466, 5468, 5469, 5476, 5470, 5471, 5472, 5474, 5473, 5475, 5482, 5483, 5484, 5477, 5478, 5479, 5480, 5481, 5485, 5486, 5488, 5489, 5490, 5491, 5492, 5493, 5487, 5494, 5495, 5496, 5505, 5497, 5498, 5499, 5500, 5501, 5502, 5503, 5504, 5506, 5507, 5511, 5508, 5510, 5509, 5512, 5516, 5513, 5519, 5514, 5517, 5518, 5515, 5529, 5520, 5521, 5522, 5523, 5524, 5525, 5526, 5530, 5527, 5528, 5531, 5532, 5533, 5534, 5535, 5536, 5541, 5537, 5538, 5539, 5540, 5542, 5543, 5544, 5545, 5546, 5550, 5547, 5548, 5549, 5551, 5552, 5553, 5554, 5555, 5556, 5557, 5558, 5561, 5562, 5559, 5563, 5560)) AND (u.active = 1) AND (u.approved = 1) AND (u.store_active = 1) AND (l.list_in != 'site') AND (l.closed = 0) AND (l.deleted = 0) AND (l.active = 1) AND (l.approved = 1) GROUP BY u.id ORDER BY u.created_at DESC LIMIT 20
SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #59 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'yourbidz_v8.l.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [Query]: SELECT u.*, l.id AS listing_id FROM ppb_users AS u LEFT JOIN ppb_listings AS l ON l.user_id = u.id WHERE (u.store_category_id IN (3686, 5027, 5028, 5029, 5030, 5031, 5032, 5033, 5034, 5035, 5036, 5037, 5038, 5039, 5040, 5041, 5042, 5043, 5044, 5045, 5046, 5047, 5048, 5049, 5050, 5072, 5051, 5052, 5054, 5055, 5056, 5057, 5058, 5059, 5060, 5061, 5062, 5063, 5064, 5065, 5066, 5067, 5068, 5069, 5070, 5071, 5073, 5074, 5075, 5076, 5077, 5078, 5081, 5079, 5080, 5082, 5083, 5084, 5085, 5086, 5087, 5088, 5091, 5089, 5090, 5092, 5093, 5094, 5095, 5096, 5097, 5098, 5099, 5100, 5101, 5102, 5103, 5104, 5105, 5106, 5107, 5108, 5111, 5112, 5109, 5110, 5113, 5114, 5115, 5127, 5116, 5117, 5118, 5119, 5120, 5121, 5122, 5129, 5123, 5124, 5128, 5125, 5126, 5133, 5134, 5130, 5135, 5136, 5137, 5138, 5139, 5140, 5141, 5142, 5131, 5143, 5144, 5132, 5145, 5146, 5156, 5147, 5148, 5149, 5150, 5151, 5152, 5153, 5154, 5155, 5157, 5158, 5159, 5160, 5161, 5162, 5166, 5163, 5164, 5165, 5167, 5168, 5169, 5172, 5171, 5170, 5173, 5174, 5175, 5176, 5177, 5178, 5179, 5206, 5180, 5181, 5182, 5207, 5208, 5209, 5210, 5211, 5183, 5184, 5185, 5186, 5187, 5188, 5189, 5212, 5191, 5192, 5193, 5194, 5195, 5196, 5197, 5214, 5213, 5198, 5199, 5200, 5201, 5190, 5204, 5202, 5203, 5205, 5215, 5216, 5217, 5218, 5219, 5220, 5221, 5222, 5223, 5224, 5225, 5226, 5227, 5228, 5229, 5230, 5231, 5233, 5232, 5234, 5235, 5236, 5237, 5241, 5238, 5239, 5240, 5242, 5244, 5243, 5245, 5246, 5247, 5249, 5248, 5250, 5255, 5251, 5252, 5253, 5254, 5256, 5257, 5258, 5273, 5259, 5260, 5261, 5262, 5263, 5264, 5265, 5266, 5267, 5268, 5269, 5270, 5271, 5272, 5296, 5297, 5298, 5299, 5300, 5302, 5301, 5274, 5276, 5275, 5277, 5278, 5279, 5280, 5281, 5282, 5283, 5284, 5285, 5286, 5287, 5295, 5288, 5289, 5290, 5291, 5293, 5294, 5303, 5304, 5305, 5306, 5307, 5313, 5308, 5309, 5310, 5311, 5312, 5318, 5322, 5323, 5324, 5326, 5316, 5314, 5317, 5328, 5315, 5325, 5327, 5320, 5330, 5329, 5319, 5321, 5331, 5332, 5333, 5334, 5335, 5336, 5337, 5338, 5339, 5345, 5340, 5346, 5341, 5342, 5343, 5344, 5347, 5348, 5349, 5350, 5351, 5357, 5353, 5352, 5354, 5355, 5356, 5363, 5364, 5365, 5366, 5367, 5368, 5369, 5370, 5395, 5371, 5372, 5373, 5374, 5375, 5376, 5377, 5378, 5379, 5380, 5381, 5382, 5397, 5383, 5384, 5396, 5385, 5386, 5387, 5388, 5389, 5390, 5391, 5392, 5393, 5394, 5403, 5398, 5400, 5399, 5401, 5402, 5404, 5405, 5406, 5407, 5408, 5409, 5410, 5412, 5411, 5413, 5414, 5415, 5416, 5417, 5420, 5419, 5418, 5436, 5425, 5423, 5421, 5424, 5422, 5437, 5438, 5427, 5428, 5429, 5430, 5431, 5432, 5433, 5434, 5435, 5426, 5439, 5440, 5441, 5442, 5443, 5444, 5445, 5446, 5456, 5447, 5448, 5449, 5450, 5452, 5453, 5451, 5454, 5455, 5457, 5458, 5459, 5463, 5460, 5461, 5462, 5464, 5465, 5467, 5466, 5468, 5469, 5476, 5470, 5471, 5472, 5474, 5473, 5475, 5482, 5483, 5484, 5477, 5478, 5479, 5480, 5481, 5485, 5486, 5488, 5489, 5490, 5491, 5492, 5493, 5487, 5494, 5495, 5496, 5505, 5497, 5498, 5499, 5500, 5501, 5502, 5503, 5504, 5506, 5507, 5511, 5508, 5510, 5509, 5512, 5516, 5513, 5519, 5514, 5517, 5518, 5515, 5529, 5520, 5521, 5522, 5523, 5524, 5525, 5526, 5530, 5527, 5528, 5531, 5532, 5533, 5534, 5535, 5536, 5541, 5537, 5538, 5539, 5540, 5542, 5543, 5544, 5545, 5546, 5550, 5547, 5548, 5549, 5551, 5552, 5553, 5554, 5555, 5556, 5557, 5558, 5561, 5562, 5559, 5563, 5560)) AND (u.active = 1) AND (u.approved = 1) AND (u.store_active = 1) AND (l.list_in != 'site') AND (l.closed = 0) AND (l.deleted = 0) AND (l.active = 1) AND (l.approved = 1) GROUP BY u.id ORDER BY u.created_at DESC LIMIT 20