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 (3704, 8174, 8175, 8176, 8177, 8178, 8179, 8180, 8181, 8182, 8183, 8184, 8185, 8186, 8187, 8188, 8189, 8190, 8191, 8192, 8193, 8194, 8195, 8196, 8197, 8198, 8199, 8200, 8201, 8218, 8202, 8203, 8204, 8205, 8206, 8207, 8208, 8209, 8210, 8211, 8212, 8213, 8214, 8215, 8216, 8217, 8655, 8219, 8220, 8221, 8222, 8223, 8226, 8224, 8225, 8227, 8228, 8233, 8229, 8230, 8231, 8232, 8234, 8235, 8236, 8237, 8238, 8242, 8239, 8240, 8241, 8243, 8244, 8245, 8246, 8247, 8248, 8249, 8252, 8250, 8251, 8253, 8254, 8255, 8256, 8261, 8257, 8258, 8259, 8260, 8263, 8262, 8264, 8265, 8266, 8268, 8267, 8269, 8270, 8271, 8272, 8273, 8275, 8274, 8276, 8277, 8278, 8279, 8286, 8280, 8281, 8282, 8283, 8284, 8285, 8287, 8288, 8289, 8290, 8291, 8292, 8293, 8300, 8294, 8296, 8295, 8297, 8299, 8298, 8301, 8302, 8303, 8304, 8305, 8306, 8310, 8307, 8308, 8309, 8311, 8312, 8313, 8314, 8315, 8316, 8317, 8318, 8319, 8320, 8321, 8323, 8322, 8325, 8324, 8326, 8327, 8328, 8329, 8336, 8330, 8331, 8332, 8333, 8334, 8335, 8340, 8339, 8338, 8341, 8337, 8342, 8343, 8344, 8345, 8347, 8346, 8348, 8349, 8350, 8351, 8354, 8352, 8353, 8355, 8356, 8357, 8358, 8359, 8365, 8360, 8361, 8362, 8363, 8364, 8366, 8367, 8368, 8369, 8370, 8375, 8371, 8372, 8373, 8374, 8376, 8377, 8378, 8379, 8385, 8380, 8381, 8383, 8382, 8384, 8386, 8387, 8388, 8389, 8390, 8399, 8391, 8392, 8393, 8394, 8395, 8396, 8397, 8398, 8400, 8404, 8401, 8406, 8407, 8405, 8402, 8403, 8408, 8409, 8410, 8411, 8412, 8413, 8415, 8414, 8416, 8417, 8418, 8419, 8424, 8420, 8421, 8422, 8423, 8425, 8428, 8426, 8427, 8429, 8430, 8431, 8433, 8432, 8434, 8435, 8436, 8437, 8438, 8439, 8440, 8441, 8442, 8443, 8449, 8444, 8445, 8446, 8447, 8448, 8451, 8450, 8452, 8453, 8459, 8454, 8455, 8456, 8457, 8458, 8460, 8462, 8461, 8463, 8467, 8464, 8465, 8466, 8468, 8469, 8470, 8471, 8472, 8474, 8473, 8475, 8477, 8476, 8481, 8478, 8479, 8480, 8482, 8483, 8484, 8485, 8486, 8492, 8487, 8488, 8489, 8490, 8491, 8493, 8494, 8495, 8496, 8502, 8497, 8498, 8499, 8500, 8501, 8503, 8504, 8505, 8507, 8512, 8506, 8508, 8509, 8510, 8511, 8513, 8514, 8515, 8519, 8516, 8517, 8518, 8520, 8521, 8522, 8523, 8528, 8524, 8525, 8526, 8527, 8529, 8533, 8530, 8532, 8531, 8535, 8536, 8537, 8538, 8539, 8540, 8541, 8542, 8543, 8544, 8534, 8545, 8546, 8547, 8548, 8549, 8550, 8551, 8559, 8552, 8553, 8554, 8555, 8558, 8556, 8557, 8560, 8561, 8562, 8563, 8564, 8572, 8565, 8566, 8567, 8568, 8569, 8570, 8571, 8573, 8574, 8575, 8580, 8576, 8577, 8578, 8579, 8581, 8582, 8583, 8585, 8586, 8584, 8587, 8596, 8588, 8589, 8590, 8591, 8592, 8593, 8594, 8595, 8597, 8598, 8604, 8599, 8601, 8600, 8602, 8603, 8605, 8606, 8607, 8608, 8609, 8614, 8610, 8611, 8612, 8613, 8615, 8616, 8623, 8617, 8618, 8619, 8620, 8621, 8622, 8624, 8625, 8626, 8631, 8627, 8628, 8629, 8630, 8633, 8632, 8634, 8635, 8644, 8637, 8636, 8638, 8639, 8640, 8641, 8642, 8643, 8645, 8646, 8647, 8649, 8654, 8650, 8648, 8651, 8652, 8653, 8664, 8665, 8666, 8667, 8668, 8673, 8669, 8670, 8671, 8672, 8663, 8662, 8656, 8657, 8658, 8659, 8660, 8661)) 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 (3704, 8174, 8175, 8176, 8177, 8178, 8179, 8180, 8181, 8182, 8183, 8184, 8185, 8186, 8187, 8188, 8189, 8190, 8191, 8192, 8193, 8194, 8195, 8196, 8197, 8198, 8199, 8200, 8201, 8218, 8202, 8203, 8204, 8205, 8206, 8207, 8208, 8209, 8210, 8211, 8212, 8213, 8214, 8215, 8216, 8217, 8655, 8219, 8220, 8221, 8222, 8223, 8226, 8224, 8225, 8227, 8228, 8233, 8229, 8230, 8231, 8232, 8234, 8235, 8236, 8237, 8238, 8242, 8239, 8240, 8241, 8243, 8244, 8245, 8246, 8247, 8248, 8249, 8252, 8250, 8251, 8253, 8254, 8255, 8256, 8261, 8257, 8258, 8259, 8260, 8263, 8262, 8264, 8265, 8266, 8268, 8267, 8269, 8270, 8271, 8272, 8273, 8275, 8274, 8276, 8277, 8278, 8279, 8286, 8280, 8281, 8282, 8283, 8284, 8285, 8287, 8288, 8289, 8290, 8291, 8292, 8293, 8300, 8294, 8296, 8295, 8297, 8299, 8298, 8301, 8302, 8303, 8304, 8305, 8306, 8310, 8307, 8308, 8309, 8311, 8312, 8313, 8314, 8315, 8316, 8317, 8318, 8319, 8320, 8321, 8323, 8322, 8325, 8324, 8326, 8327, 8328, 8329, 8336, 8330, 8331, 8332, 8333, 8334, 8335, 8340, 8339, 8338, 8341, 8337, 8342, 8343, 8344, 8345, 8347, 8346, 8348, 8349, 8350, 8351, 8354, 8352, 8353, 8355, 8356, 8357, 8358, 8359, 8365, 8360, 8361, 8362, 8363, 8364, 8366, 8367, 8368, 8369, 8370, 8375, 8371, 8372, 8373, 8374, 8376, 8377, 8378, 8379, 8385, 8380, 8381, 8383, 8382, 8384, 8386, 8387, 8388, 8389, 8390, 8399, 8391, 8392, 8393, 8394, 8395, 8396, 8397, 8398, 8400, 8404, 8401, 8406, 8407, 8405, 8402, 8403, 8408, 8409, 8410, 8411, 8412, 8413, 8415, 8414, 8416, 8417, 8418, 8419, 8424, 8420, 8421, 8422, 8423, 8425, 8428, 8426, 8427, 8429, 8430, 8431, 8433, 8432, 8434, 8435, 8436, 8437, 8438, 8439, 8440, 8441, 8442, 8443, 8449, 8444, 8445, 8446, 8447, 8448, 8451, 8450, 8452, 8453, 8459, 8454, 8455, 8456, 8457, 8458, 8460, 8462, 8461, 8463, 8467, 8464, 8465, 8466, 8468, 8469, 8470, 8471, 8472, 8474, 8473, 8475, 8477, 8476, 8481, 8478, 8479, 8480, 8482, 8483, 8484, 8485, 8486, 8492, 8487, 8488, 8489, 8490, 8491, 8493, 8494, 8495, 8496, 8502, 8497, 8498, 8499, 8500, 8501, 8503, 8504, 8505, 8507, 8512, 8506, 8508, 8509, 8510, 8511, 8513, 8514, 8515, 8519, 8516, 8517, 8518, 8520, 8521, 8522, 8523, 8528, 8524, 8525, 8526, 8527, 8529, 8533, 8530, 8532, 8531, 8535, 8536, 8537, 8538, 8539, 8540, 8541, 8542, 8543, 8544, 8534, 8545, 8546, 8547, 8548, 8549, 8550, 8551, 8559, 8552, 8553, 8554, 8555, 8558, 8556, 8557, 8560, 8561, 8562, 8563, 8564, 8572, 8565, 8566, 8567, 8568, 8569, 8570, 8571, 8573, 8574, 8575, 8580, 8576, 8577, 8578, 8579, 8581, 8582, 8583, 8585, 8586, 8584, 8587, 8596, 8588, 8589, 8590, 8591, 8592, 8593, 8594, 8595, 8597, 8598, 8604, 8599, 8601, 8600, 8602, 8603, 8605, 8606, 8607, 8608, 8609, 8614, 8610, 8611, 8612, 8613, 8615, 8616, 8623, 8617, 8618, 8619, 8620, 8621, 8622, 8624, 8625, 8626, 8631, 8627, 8628, 8629, 8630, 8633, 8632, 8634, 8635, 8644, 8637, 8636, 8638, 8639, 8640, 8641, 8642, 8643, 8645, 8646, 8647, 8649, 8654, 8650, 8648, 8651, 8652, 8653, 8664, 8665, 8666, 8667, 8668, 8673, 8669, 8670, 8671, 8672, 8663, 8662, 8656, 8657, 8658, 8659, 8660, 8661)) 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