pegasus_mysql_use: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and ( i00_i.pl301=0 ) GROUP BY i00_i.nr01 limit 132) as ttt' at line 46
Whole query: select sum(1) / 12 as pages from (select i30.nr01 as i30_nr01, i00_i.nr01, i00_i.p9901, i00_i.p9902, i00_i.pno,i00_i.name,i00_i.p9000,i00_i.p632, i00_i.p9904, i00_i.p9905, i00_i.p9907, i00_i.p903, i00_i.p9001, i00_i.p99 as i20, i00_i.pd300, i00_i.p302, i00_i.p9903, i00_i.dat, i00_i.timh2, i00_i.remdate, i00_i.p632e, i00_i.pd10, i00_i.pd11, i00_i.pd12, i00_i.pd13, i00_i.pd20, i00_i.pd21, i00_i.pd22, i00_i.pd23, i00_i.pd30, i00_i.pd31, i00_i.pd32, i00_i.pd33, i00_i.pd40, i00_i.pd41, i00_i.pd42, i00_i.pd43, i00_i.pd50, i00_i.pd51, i00_i.pd52, i00_i.pd53, i00_i.p906, i00_i.p62, i00_i.rp, i00_i.op, i21.tax as i21_tax, i22.tax as i22_tax, i29.tax as i29_tax, i30.tax as i30_tax,i49.p02 as i49p02 , i46.p02 as i46p02, if(i17.pe03>0 , i17.pe03 ,i00_i.timh2 * (100-i00_i.p617) /100) as timh , i00_i.p630 , sum(i00tot_00.p03) as i00tot_00p03, sum(i00tot_00.p04) as i00tot_00p04, sum(i00tot_00.p05) as i00tot_00p05, i00_i.ep9000 from i00 as i00_i left join i49 on i49.p01=i00_i.p9907 left join i46 on i46.p01=i00_i.p9903 left join i17 on i17.i00=i00_i.nr01 and i17.pe02='3' left join i21 on i21.nr01=i00_i.p9901 left join i22 on i22.nr01=i00_i.p9902 left join i29 on i29.nr01=i00_i.p910 left join i30 on i30.nr01=i00_i.p911 left join ( select i00tot.pno1, i00tot.p03,i00tot.p04,i00tot.p05 from i00tot join i16 on i16.p00=i00tot.p610 and i16.p300=1 ) as i00tot_00 on i00tot_00.pno1=i00_i.pno where i00_i.p300=1 and i00_i.p203=0 and i00_i.pd300=1 and i00_i.nr01 in and ( i00_i.pl301=0 ) GROUP BY i00_i.nr01 limit 132) as ttt ;
Array ( [file] => /home/tesae/public_html/pegasus/kernel00/functions.php [line] => 1723 [function] => pegasus_mysql_use [args] => Array ( [0] => select sum(1) / 12 as pages from (select i30.nr01 as i30_nr01, i00_i.nr01, i00_i.p9901, i00_i.p9902, i00_i.pno,i00_i.name,i00_i.p9000,i00_i.p632, i00_i.p9904, i00_i.p9905, i00_i.p9907, i00_i.p903, i00_i.p9001, i00_i.p99 as i20, i00_i.pd300, i00_i.p302, i00_i.p9903, i00_i.dat, i00_i.timh2, i00_i.remdate, i00_i.p632e, i00_i.pd10, i00_i.pd11, i00_i.pd12, i00_i.pd13, i00_i.pd20, i00_i.pd21, i00_i.pd22, i00_i.pd23, i00_i.pd30, i00_i.pd31, i00_i.pd32, i00_i.pd33, i00_i.pd40, i00_i.pd41, i00_i.pd42, i00_i.pd43, i00_i.pd50, i00_i.pd51, i00_i.pd52, i00_i.pd53, i00_i.p906, i00_i.p62, i00_i.rp, i00_i.op, i21.tax as i21_tax, i22.tax as i22_tax, i29.tax as i29_tax, i30.tax as i30_tax,i49.p02 as i49p02 , i46.p02 as i46p02, if(i17.pe03>0 , i17.pe03 ,i00_i.timh2 * (100-i00_i.p617) /100) as timh , i00_i.p630 , sum(i00tot_00.p03) as i00tot_00p03, sum(i00tot_00.p04) as i00tot_00p04, sum(i00tot_00.p05) as i00tot_00p05, i00_i.ep9000 from i00 as i00_i left join i49 on i49.p01=i00_i.p9907 left join i46 on i46.p01=i00_i.p9903 left join i17 on i17.i00=i00_i.nr01 and i17.pe02='3' left join i21 on i21.nr01=i00_i.p9901 left join i22 on i22.nr01=i00_i.p9902 left join i29 on i29.nr01=i00_i.p910 left join i30 on i30.nr01=i00_i.p911 left join ( select i00tot.pno1, i00tot.p03,i00tot.p04,i00tot.p05 from i00tot join i16 on i16.p00=i00tot.p610 and i16.p300=1 ) as i00tot_00 on i00tot_00.pno1=i00_i.pno where i00_i.p300=1 and i00_i.p203=0 and i00_i.pd300=1 and i00_i.nr01 in and ( i00_i.pl301=0 ) GROUP BY i00_i.nr01 limit 132) as ttt ; [1] => ) ) Array ( [file] => /home/tesae/public_html/pegasus/products00/classes.php [line] => 574 [function] => countpages [args] => Array ( [0] => (select i30.nr01 as i30_nr01, i00_i.nr01, i00_i.p9901, i00_i.p9902, i00_i.pno,i00_i.name,i00_i.p9000,i00_i.p632, i00_i.p9904, i00_i.p9905, i00_i.p9907, i00_i.p903, i00_i.p9001, i00_i.p99 as i20, i00_i.pd300, i00_i.p302, i00_i.p9903, i00_i.dat, i00_i.timh2, i00_i.remdate, i00_i.p632e, i00_i.pd10, i00_i.pd11, i00_i.pd12, i00_i.pd13, i00_i.pd20, i00_i.pd21, i00_i.pd22, i00_i.pd23, i00_i.pd30, i00_i.pd31, i00_i.pd32, i00_i.pd33, i00_i.pd40, i00_i.pd41, i00_i.pd42, i00_i.pd43, i00_i.pd50, i00_i.pd51, i00_i.pd52, i00_i.pd53, i00_i.p906, i00_i.p62, i00_i.rp, i00_i.op, i21.tax as i21_tax, i22.tax as i22_tax, i29.tax as i29_tax, i30.tax as i30_tax,i49.p02 as i49p02 , i46.p02 as i46p02, if(i17.pe03>0 , i17.pe03 ,i00_i.timh2 * (100-i00_i.p617) /100) as timh , i00_i.p630 , sum(i00tot_00.p03) as i00tot_00p03, sum(i00tot_00.p04) as i00tot_00p04, sum(i00tot_00.p05) as i00tot_00p05, i00_i.ep9000 from i00 as i00_i left join i49 on i49.p01=i00_i.p9907 left join i46 on i46.p01=i00_i.p9903 left join i17 on i17.i00=i00_i.nr01 and i17.pe02='3' left join i21 on i21.nr01=i00_i.p9901 left join i22 on i22.nr01=i00_i.p9902 left join i29 on i29.nr01=i00_i.p910 left join i30 on i30.nr01=i00_i.p911 left join ( select i00tot.pno1, i00tot.p03,i00tot.p04,i00tot.p05 from i00tot join i16 on i16.p00=i00tot.p610 and i16.p300=1 ) as i00tot_00 on i00tot_00.pno1=i00_i.pno where i00_i.p300=1 and i00_i.p203=0 and i00_i.pd300=1 and i00_i.nr01 in and ( i00_i.pl301=0 ) GROUP BY i00_i.nr01 limit 132) as ttt [1] => javascript:window.location = '' + peg_qString('listSearch',['bt','pcode','timh_lower','timh_upper'],['i43p01_in','size','i40p01_in','color','price','timh_apo','timh_eos','view','max','pd300','newprod','p02','name','herp06','p9907','i43p01','i40p01','p9907_in','i46p01','book_search','isbn','timh_lower','timh_upper','omada3','omada2','omada1','omada0']) +' [2] => 12 [3] => 0 [4] => ' [5] => 0 [6] => SCHEDULED_OFFERS [7] => 10 ) ) Array ( [file] => /home/tesae/public_html/pegasus/products01/list00.php [line] => 382 [function] => product_countpages [class] => productList [object] => productList Object ( [tmp_urlnotpost:productList:private] => Array ( [0] => bt [1] => pcode [2] => timh_lower [3] => timh_upper ) [p9001:productList:private] => [i10p01_in:productList:private] => [titles] => [data] =>
Δεν υπάρχουν αλλά πρoϊόντα
[mysqlQuery] => select i30.nr01 as i30_nr01, i00_i.nr01, i00_i.p9901, i00_i.p9902, i00_i.pno,i00_i.name,i00_i.p9000,i00_i.p632, i00_i.p9904, i00_i.p9905, i00_i.p9907, i00_i.p903, i00_i.p9001, i00_i.p99 as i20, i00_i.pd300, i00_i.p302, i00_i.p9903, i00_i.dat, i00_i.timh2, i00_i.remdate, i00_i.p632e, i00_i.pd10, i00_i.pd11, i00_i.pd12, i00_i.pd13, i00_i.pd20, i00_i.pd21, i00_i.pd22, i00_i.pd23, i00_i.pd30, i00_i.pd31, i00_i.pd32, i00_i.pd33, i00_i.pd40, i00_i.pd41, i00_i.pd42, i00_i.pd43, i00_i.pd50, i00_i.pd51, i00_i.pd52, i00_i.pd53, i00_i.p906, i00_i.p62, i00_i.rp, i00_i.op, i21.tax as i21_tax, i22.tax as i22_tax, i29.tax as i29_tax, i30.tax as i30_tax,i49.p02 as i49p02 , i46.p02 as i46p02, if(i17.pe03>0 , i17.pe03 ,i00_i.timh2 * (100-i00_i.p617) /100) as timh , i00_i.p630 , sum(i00tot_00.p03) as i00tot_00p03, sum(i00tot_00.p04) as i00tot_00p04, sum(i00tot_00.p05) as i00tot_00p05, i00_i.ep9000 from i00 as i00_i left join i49 on i49.p01=i00_i.p9907 left join i46 on i46.p01=i00_i.p9903 left join i17 on i17.i00=i00_i.nr01 and i17.pe02='3' left join i21 on i21.nr01=i00_i.p9901 left join i22 on i22.nr01=i00_i.p9902 left join i29 on i29.nr01=i00_i.p910 left join i30 on i30.nr01=i00_i.p911 left join ( select i00tot.pno1, i00tot.p03,i00tot.p04,i00tot.p05 from i00tot join i16 on i16.p00=i00tot.p610 and i16.p300=1 ) as i00tot_00 on i00tot_00.pno1=i00_i.pno where i00_i.p300=1 and i00_i.p203=0 and i00_i.pd300=1 and i00_i.nr01 in and ( i00_i.pl301=0 ) GROUP BY i00_i.nr01 [mysqlResult] => [where] => and i00.nr01 in [order] => i00tot_00p03 desc , i00_i.p630 [orderTyp] => [groupby] => [having] => [max] => 12 [page] => 0 [name] => [omada0] => 0 [omada1] => 0 [omada2] => 0 [omada3] => 0 [pd300] => 1 [newprod] => [p02] => [p02_arr] => [p9907] => [p9903] => [i39_p02] => Array ( ) [i39_p04] => Array ( ) [i40p01] => [i43p01] => [select_i54] => select i53.p104 as i53p104, i53.pp04 as i53pp04,i55.p00,i54.nr01 as i54nr01,i54.p02 as i54p02, i53.p01 as i53p01, i53.p02 as i53p02 from i54 join i55 on i55.p01=i54.nr01 join i53 on i53.p01=i55.p02 where i53.p04=1 and i54.p010>0 and ( i54.p010=0 ) and ( i54.p011=0 ) and ( i54.p012=0 ) and ( i54.p013=0 ) group by i55.p02 order by i55.p00,i53.tax,i53p02,i53.nr01; [i54cnt] => 0 [i40p01_in] => [omada0_in] => [omada2_in] => [omada3_in] => [p9907_in] => [p9903_in] => [i43p01_in] => [i53p01_in] => [timh_apo] => 0 [timh_eos] => 0 [timh_multi] => [dat_apo] => [dat_eos] => [i] => 0 [data_clsize] => [imageType] => 2 [i00_nr01_arr] => Array ( ) [i00_px01_text] => [i00_px01_en] => [count_products] => [pages_txt] => [only_search_i39] => 0 [prod_omades_arr] => [disabled_i54] => [productPagesUrl:productList:private] => '' + peg_qString('listSearch',['bt','pcode','timh_lower','timh_upper'],['i43p01_in','size','i40p01_in','color','price','timh_apo','timh_eos','view','max','pd300','newprod','p02','name','herp06','p9907','i43p01','i40p01','p9907_in','i46p01','book_search','isbn','timh_lower','timh_upper','omada3','omada2','omada1','omada0']) [view:productList:private] => [height] => ) [type] => -> [args] => Array ( [0] => (select i30.nr01 as i30_nr01, i00_i.nr01, i00_i.p9901, i00_i.p9902, i00_i.pno,i00_i.name,i00_i.p9000,i00_i.p632, i00_i.p9904, i00_i.p9905, i00_i.p9907, i00_i.p903, i00_i.p9001, i00_i.p99 as i20, i00_i.pd300, i00_i.p302, i00_i.p9903, i00_i.dat, i00_i.timh2, i00_i.remdate, i00_i.p632e, i00_i.pd10, i00_i.pd11, i00_i.pd12, i00_i.pd13, i00_i.pd20, i00_i.pd21, i00_i.pd22, i00_i.pd23, i00_i.pd30, i00_i.pd31, i00_i.pd32, i00_i.pd33, i00_i.pd40, i00_i.pd41, i00_i.pd42, i00_i.pd43, i00_i.pd50, i00_i.pd51, i00_i.pd52, i00_i.pd53, i00_i.p906, i00_i.p62, i00_i.rp, i00_i.op, i21.tax as i21_tax, i22.tax as i22_tax, i29.tax as i29_tax, i30.tax as i30_tax,i49.p02 as i49p02 , i46.p02 as i46p02, if(i17.pe03>0 , i17.pe03 ,i00_i.timh2 * (100-i00_i.p617) /100) as timh , i00_i.p630 , sum(i00tot_00.p03) as i00tot_00p03, sum(i00tot_00.p04) as i00tot_00p04, sum(i00tot_00.p05) as i00tot_00p05, i00_i.ep9000 from i00 as i00_i left join i49 on i49.p01=i00_i.p9907 left join i46 on i46.p01=i00_i.p9903 left join i17 on i17.i00=i00_i.nr01 and i17.pe02='3' left join i21 on i21.nr01=i00_i.p9901 left join i22 on i22.nr01=i00_i.p9902 left join i29 on i29.nr01=i00_i.p910 left join i30 on i30.nr01=i00_i.p911 left join ( select i00tot.pno1, i00tot.p03,i00tot.p04,i00tot.p05 from i00tot join i16 on i16.p00=i00tot.p610 and i16.p300=1 ) as i00tot_00 on i00tot_00.pno1=i00_i.pno where i00_i.p300=1 and i00_i.p203=0 and i00_i.pd300=1 and i00_i.nr01 in and ( i00_i.pl301=0 ) GROUP BY i00_i.nr01 limit 132) as ttt [1] => javascript:window.location = '' + peg_qString('listSearch',['bt','pcode','timh_lower','timh_upper'],['i43p01_in','size','i40p01_in','color','price','timh_apo','timh_eos','view','max','pd300','newprod','p02','name','herp06','p9907','i43p01','i40p01','p9907_in','i46p01','book_search','isbn','timh_lower','timh_upper','omada3','omada2','omada1','omada0']) +' [2] => 12 [3] => 0 [4] => ' [5] => 0 [6] => 0 [7] => SCHEDULED_OFFERS [8] => 10 ) )