There was an error in your query:
SELECT tblcategory.category, tblcategory.category_url, (select subcategory from tblsubcategory where id = tblproducts.subcat_id) as subcategory, (select subcategory_url from tblsubcategory where id = tblproducts.subcat_id) as subcategory_url, tblbrands.brand, tblproducts.id, tblproducts.price, tblproducts.price2, tblproducts.price3, if (tblproducts.price2 > 0 and data_start <= curdate() and data_end >= curdate(), if (tblproducts.price3 is not null and tblproducts.price3 > 0 and tblproducts.price3 < tblproducts.price2, tblproducts.price3, tblproducts.price2), if (tblproducts.price3 is not null and tblproducts.price3 > 0 and tblproducts.price3 < if(tblproducts.use_price_vanzare=1, tblproducts.price_vanzare, tblproducts.price), tblproducts.price3, if(tblproducts.use_price_vanzare=1, tblproducts.price_vanzare, tblproducts.price)) ) as pret_vanzare, tblproducts.data_start, tblproducts.data_end, tblproducts.title, tblproducts.short_desc, tblproducts.greutate, tblproducts.prodType, tblproducts.oferta_speciala, tblproducts.promotia_saptamanii, tblproducts.disponibilitate, tblproducts.eticheta_culoare, tblproducts.img1, tblproducts.vote, tblproducts.nrVotes FROM tblcategory LEFT JOIN tblsubcategory ON (tblsubcategory.p_id = tblcategory.id) INNER JOIN tblproducts ON (tblproducts.cat_id = tblcategory.id) INNER JOIN tblbrands ON (tblproducts.brand_id = tblbrands.id) WHERE tblproducts.isActive = 1 group by tblproducts.id ORDER BY disponibilitate LIMIT 0, 12
MySQL server response was: Lost connection to server during query
MySQL Error Code: 2013
SELECT tblcategory.category, tblcategory.category_url, (select subcategory from tblsubcategory where id = tblproducts.subcat_id) as subcategory, (select subcategory_url from tblsubcategory where id = tblproducts.subcat_id) as subcategory_url, tblbrands.brand, tblproducts.id, tblproducts.price, tblproducts.price2, tblproducts.price3, if (tblproducts.price2 > 0 and data_start <= curdate() and data_end >= curdate(), if (tblproducts.price3 is not null and tblproducts.price3 > 0 and tblproducts.price3 < tblproducts.price2, tblproducts.price3, tblproducts.price2), if (tblproducts.price3 is not null and tblproducts.price3 > 0 and tblproducts.price3 < if(tblproducts.use_price_vanzare=1, tblproducts.price_vanzare, tblproducts.price), tblproducts.price3, if(tblproducts.use_price_vanzare=1, tblproducts.price_vanzare, tblproducts.price)) ) as pret_vanzare, tblproducts.data_start, tblproducts.data_end, tblproducts.title, tblproducts.short_desc, tblproducts.greutate, tblproducts.prodType, tblproducts.oferta_speciala, tblproducts.promotia_saptamanii, tblproducts.disponibilitate, tblproducts.eticheta_culoare, tblproducts.img1, tblproducts.vote, tblproducts.nrVotes FROM tblcategory LEFT JOIN tblsubcategory ON (tblsubcategory.p_id = tblcategory.id) INNER JOIN tblproducts ON (tblproducts.cat_id = tblcategory.id) INNER JOIN tblbrands ON (tblproducts.brand_id = tblbrands.id) WHERE tblproducts.isActive = 1 group by tblproducts.id ORDER BY disponibilitate LIMIT 0, 12
MySQL server response was: Lost connection to server during query
MySQL Error Code: 2013