Hata Olu┼čtu Hata Kodu : get_product(select p.* ,MAX( IF ( a.attr_alias = 'max_quantity', t.attributeval, NULL ) ) AS `max_quantity` , MAX( IF ( a.attr_alias = 'max_quantity', a.attr_name, NULL ) ) AS `max_quantity_desc` , 26 as max_quantity_id , MAX( IF ( a.attr_alias = 'renew', t.attributeval, NULL ) ) AS `renew` , MAX( IF ( a.attr_alias = 'renew', a.attr_name, NULL ) ) AS `renew_desc` , 27 as renew_id , MAX( IF ( a.attr_alias = 'transfer', t.attributeval, NULL ) ) AS `transfer` , MAX( IF ( a.attr_alias = 'transfer', a.attr_name, NULL ) ) AS `transfer_desc` , 28 as transfer_id , MAX( IF ( a.attr_alias = 'restore', t.attributeval, NULL ) ) AS `restore` , MAX( IF ( a.attr_alias = 'restore', a.attr_name, NULL ) ) AS `restore_desc` , 29 as restore_id , MAX( IF ( a.attr_alias = 'minLength', t.attributeval, NULL ) ) AS `minLength` , MAX( IF ( a.attr_alias = 'minLength', a.attr_name, NULL ) ) AS `minLength_desc` , 30 as minLength_id , MAX( IF ( a.attr_alias = 'maxLength', t.attributeval, NULL ) ) AS `maxLength` , MAX( IF ( a.attr_alias = 'maxLength', a.attr_name, NULL ) ) AS `maxLength_desc` , 31 as maxLength_id , MAX( IF ( a.attr_alias = 'idnSupport', t.attributeval, NULL ) ) AS `idnSupport` , MAX( IF ( a.attr_alias = 'idnSupport', a.attr_name, NULL ) ) AS `idnSupport_desc` , 32 as idnSupport_id , MAX( IF ( a.attr_alias = 'redemptionPeriod', t.attributeval, NULL ) ) AS `redemptionPeriod` , MAX( IF ( a.attr_alias = 'redemptionPeriod', a.attr_name, NULL ) ) AS `redemptionPeriod_desc` , 33 as redemptionPeriod_id , MAX( IF ( a.attr_alias = 'pendingDeletePeriod', t.attributeval, NULL ) ) AS `pendingDeletePeriod` , MAX( IF ( a.attr_alias = 'pendingDeletePeriod', a.attr_name, NULL ) ) AS `pendingDeletePeriod_desc` , 34 as pendingDeletePeriod_id , MAX( IF ( a.attr_alias = 'featuresAvailable', t.attributeval, NULL ) ) AS `featuresAvailable` , MAX( IF ( a.attr_alias = 'featuresAvailable', a.attr_name, NULL ) ) AS `featuresAvailable_desc` , 35 as featuresAvailable_id , MAX( IF ( a.attr_alias = 'rsp', t.attributeval, NULL ) ) AS `rsp` , MAX( IF ( a.attr_alias = 'rsp', a.attr_name, NULL ) ) AS `rsp_desc` , 73 as rsp_id , MAX( IF ( a.attr_alias = 'default_ns', t.attributeval, NULL ) ) AS `default_ns` , MAX( IF ( a.attr_alias = 'default_ns', a.attr_name, NULL ) ) AS `default_ns_desc` , 74 as default_ns_id , MAX( IF ( a.attr_alias = 'id_required', t.attributeval, NULL ) ) AS `id_required` , MAX( IF ( a.attr_alias = 'id_required', a.attr_name, NULL ) ) AS `id_required_desc` , 76 as id_required_id from ds_products p LEFT JOIN ds_product_by_attr t ON p.id = t.productid LEFT JOIN ds_product_attr a ON t.attributeid = a.attributeid Where p.type='domain' AND p.status='E' GROUP BY p.id,p.product_name order by p.sira asc limit 0 ,25) line:2550