DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
!Standard Message: DB Error: unknown error Standard Code: -1 DBMS/User Message: SELECT t0.products_id, t0.vendor_prodcode FROM cms_products t0 LEFT JOIN cms_products2cat t1 ON t1.product_id=t0.products_id LEFT JOIN cms_products_cat t3 ON t3.cat_id=t1.cat_id LEFT JOIN cms_brands t6 ON t6.id=t0.products_logo LEFT JOIN gestor_product_popularity_benchmarks ppb ON ppb.product_id=t0.products_id WHERE 1=1 AND (t0.products_status='Active') AND (t0.hidden_oos = 0) AND (t3.cat_id IN (697,698,699,700,701,702,703,704,705,706,707,708,709,926,927,928,929,934,1158,935,936,938,939,940,696,677)) GROUP BY t0.products_id HAVING 1=1 ORDER BY CASE WHEN t0.stock_cache > 0 THEN 0 WHEN t0.stock_cache_demo > 0 THEN 1 ELSE 2 END ASC, CASE WHEN t0.stock_cache > 0 OR t0.stock_cache_demo > 0 THEN t0.products_type='Promotion' END DESC, CASE WHEN t0.stock_cache > 0 OR t0.stock_cache_demo > 0 THEN t0.products_price END ASC, CASE WHEN t0.stock_cache > 0 OR t0.stock_cache_demo > 0 THEN t0.products_title END ASC, CASE WHEN t0.stock_cache <= 0 AND t0.stock_cache_demo <= 0 THEN CASE WHEN t0.available_in_days > 0 THEN t0.available_in_days ELSE 999999 END END ASC, CASE WHEN t0.stock_cache <= 0 AND t0.stock_cache_demo <= 0 THEN ppb.factor END DESC, CASE WHEN t0.stock_cache <= 0 AND t0.stock_cache_demo <= 0 THEN t0.products_price END ASC [nativecode=2006 ** MySQL server has gone away] DBMS/Debug Message: SELECT t0.products_id, t0.vendor_prodcode FROM cms_products t0 LEFT JOIN cms_products2cat t1 ON t1.product_id=t0.products_id LEFT JOIN cms_products_cat t3 ON t3.cat_id=t1.cat_id LEFT JOIN cms_brands t6 ON t6.id=t0.products_logo LEFT JOIN gestor_product_popularity_benchmarks ppb ON ppb.product_id=t0.products_id WHERE 1=1 AND (t0.products_status='Active') AND (t0.hidden_oos = 0) AND (t3.cat_id IN (697,698,699,700,701,702,703,704,705,706,707,708,709,926,927,928,929,934,1158,935,936,938,939,940,696,677)) GROUP BY t0.products_id HAVING 1=1 ORDER BY CASE WHEN t0.stock_cache > 0 THEN 0 WHEN t0.stock_cache_demo > 0 THEN 1 ELSE 2 END ASC, CASE WHEN t0.stock_cache > 0 OR t0.stock_cache_demo > 0 THEN t0.products_type='Promotion' END DESC, CASE WHEN t0.stock_cache > 0 OR t0.stock_cache_demo > 0 THEN t0.products_price END ASC, CASE WHEN t0.stock_cache > 0 OR t0.stock_cache_demo > 0 THEN t0.products_title END ASC, CASE WHEN t0.stock_cache <= 0 AND t0.stock_cache_demo <= 0 THEN CASE WHEN t0.available_in_days > 0 THEN t0.available_in_days ELSE 999999 END END ASC, CASE WHEN t0.stock_cache <= 0 AND t0.stock_cache_demo <= 0 THEN ppb.factor END DESC, CASE WHEN t0.stock_cache <= 0 AND t0.stock_cache_demo <= 0 THEN t0.products_price END ASC [nativecode=2006 ** MySQL server has gone away] !DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
DB Error: unknown error
!Standard Message: DB Error: unknown error Standard Code: -1 DBMS/User Message: SELECT t0.products_id, t0.vendor_prodcode FROM cms_products t0 LEFT JOIN cms_products2cat t1 ON t1.product_id=t0.products_id LEFT JOIN cms_products_cat t3 ON t3.cat_id=t1.cat_id LEFT JOIN cms_brands t6 ON t6.id=t0.products_logo WHERE 1=1 AND (t0.products_type='Promotion') AND (t0.products_status='Active') AND (t0.hidden_oos = 0) AND (t3.cat_id IN (697,698,699,700,701,702,703,704,705,706,707,708,709,926,927,928,929,934,1158,935,936,938,939,940,696,677)) GROUP BY t0.products_id HAVING 1=1 ORDER BY CASE WHEN t0.stock_cache > 0 THEN 0 WHEN t0.stock_cache_demo > 0 THEN 1 ELSE 2 END ASC, t0.products_type='Promotion' DESC, t0.products_price ASC, t0.products_title ASC LIMIT 12 [nativecode=2006 ** MySQL server has gone away] DBMS/Debug Message: SELECT t0.products_id, t0.vendor_prodcode FROM cms_products t0 LEFT JOIN cms_products2cat t1 ON t1.product_id=t0.products_id LEFT JOIN cms_products_cat t3 ON t3.cat_id=t1.cat_id LEFT JOIN cms_brands t6 ON t6.id=t0.products_logo WHERE 1=1 AND (t0.products_type='Promotion') AND (t0.products_status='Active') AND (t0.hidden_oos = 0) AND (t3.cat_id IN (697,698,699,700,701,702,703,704,705,706,707,708,709,926,927,928,929,934,1158,935,936,938,939,940,696,677)) GROUP BY t0.products_id HAVING 1=1 ORDER BY CASE WHEN t0.stock_cache > 0 THEN 0 WHEN t0.stock_cache_demo > 0 THEN 1 ELSE 2 END ASC, t0.products_type='Promotion' DESC, t0.products_price ASC, t0.products_title ASC LIMIT 12 [nativecode=2006 ** MySQL server has gone away] !DB Error: unknown error
!Standard Message: DB Error: unknown error Standard Code: -1 DBMS/User Message: SELECT t0.products_id, t0.vendor_prodcode FROM cms_products t0 LEFT JOIN cms_products2cat t1 ON t1.product_id=t0.products_id LEFT JOIN cms_products_cat t3 ON t3.cat_id=t1.cat_id LEFT JOIN cms_brands t6 ON t6.id=t0.products_logo WHERE 1=1 AND (t0.products_status='Active') AND (t0.hidden_oos = 0) AND (t0.new_status=1) AND (t3.cat_id IN (697,698,699,700,701,702,703,704,705,706,707,708,709,926,927,928,929,934,1158,935,936,938,939,940,696,677)) GROUP BY t0.products_id HAVING 1=1 ORDER BY CASE WHEN t0.stock_cache > 0 THEN 0 WHEN t0.stock_cache_demo > 0 THEN 1 ELSE 2 END ASC, t0.products_type='Promotion' DESC, t0.products_price ASC, t0.products_title ASC LIMIT 10 [nativecode=2006 ** MySQL server has gone away] DBMS/Debug Message: SELECT t0.products_id, t0.vendor_prodcode FROM cms_products t0 LEFT JOIN cms_products2cat t1 ON t1.product_id=t0.products_id LEFT JOIN cms_products_cat t3 ON t3.cat_id=t1.cat_id LEFT JOIN cms_brands t6 ON t6.id=t0.products_logo WHERE 1=1 AND (t0.products_status='Active') AND (t0.hidden_oos = 0) AND (t0.new_status=1) AND (t3.cat_id IN (697,698,699,700,701,702,703,704,705,706,707,708,709,926,927,928,929,934,1158,935,936,938,939,940,696,677)) GROUP BY t0.products_id HAVING 1=1 ORDER BY CASE WHEN t0.stock_cache > 0 THEN 0 WHEN t0.stock_cache_demo > 0 THEN 1 ELSE 2 END ASC, t0.products_type='Promotion' DESC, t0.products_price ASC, t0.products_title ASC LIMIT 10 [nativecode=2006 ** MySQL server has gone away] !DB Error: unknown error
!Standard Message: DB Error: unknown error Standard Code: -1 DBMS/User Message: SELECT t0.products_id, t0.vendor_prodcode FROM cms_products t0 LEFT JOIN cms_products2cat t1 ON t1.product_id=t0.products_id LEFT JOIN cms_products_cat t3 ON t3.cat_id=t1.cat_id LEFT JOIN cms_brands t6 ON t6.id=t0.products_logo WHERE 1=1 AND (t0.products_status='Active') AND (t0.hidden_oos = 0) AND (t3.cat_id IN (697,698,699,700,701,702,703,704,705,706,707,708,709,926,927,928,929,934,1158,935,936,938,939,940,696,677)) GROUP BY t0.products_id HAVING 1=1 ORDER BY t0.sold_cache DESC, t0.stock_cache>0 DESC, t0.views DESC LIMIT 12 [nativecode=2006 ** MySQL server has gone away] DBMS/Debug Message: SELECT t0.products_id, t0.vendor_prodcode FROM cms_products t0 LEFT JOIN cms_products2cat t1 ON t1.product_id=t0.products_id LEFT JOIN cms_products_cat t3 ON t3.cat_id=t1.cat_id LEFT JOIN cms_brands t6 ON t6.id=t0.products_logo WHERE 1=1 AND (t0.products_status='Active') AND (t0.hidden_oos = 0) AND (t3.cat_id IN (697,698,699,700,701,702,703,704,705,706,707,708,709,926,927,928,929,934,1158,935,936,938,939,940,696,677)) GROUP BY t0.products_id HAVING 1=1 ORDER BY t0.sold_cache DESC, t0.stock_cache>0 DESC, t0.views DESC LIMIT 12 [nativecode=2006 ** MySQL server has gone away] !DB Error: unknown error
!Standard Message: DB Error: unknown error Standard Code: -1 DBMS/User Message: SELECT t0.products_id, t0.vendor_prodcode FROM cms_products t0 LEFT JOIN cms_products2cat t1 ON t1.product_id=t0.products_id LEFT JOIN cms_products_cat t3 ON t3.cat_id=t1.cat_id LEFT JOIN cms_brands t6 ON t6.id=t0.products_logo WHERE 1=1 AND (t0.products_status='Active') AND (t0.hidden_oos = 0) AND (t3.cat_id IN (697,698,699,700,701,702,703,704,705,706,707,708,709,926,927,928,929,934,1158,935,936,938,939,940,696,677)) GROUP BY t0.products_id HAVING 1=1 ORDER BY t0.sold_cache*t0.products_price DESC LIMIT 500 [nativecode=2006 ** MySQL server has gone away] DBMS/Debug Message: SELECT t0.products_id, t0.vendor_prodcode FROM cms_products t0 LEFT JOIN cms_products2cat t1 ON t1.product_id=t0.products_id LEFT JOIN cms_products_cat t3 ON t3.cat_id=t1.cat_id LEFT JOIN cms_brands t6 ON t6.id=t0.products_logo WHERE 1=1 AND (t0.products_status='Active') AND (t0.hidden_oos = 0) AND (t3.cat_id IN (697,698,699,700,701,702,703,704,705,706,707,708,709,926,927,928,929,934,1158,935,936,938,939,940,696,677)) GROUP BY t0.products_id HAVING 1=1 ORDER BY t0.sold_cache*t0.products_price DESC LIMIT 500 [nativecode=2006 ** MySQL server has gone away] !DB Error: unknown error
DB Error: unknown error
DB Error: unknown error