| 2 | 0.0534 | 6202144 | query( $query = '\r\nSELECT \r\nt.company_name,\r\np.sku_number,\r\np.id,\r\np.name,\r\nCASE WHEN (b.nama_cabang IS NULL OR b.nama_cabang = 0)\r\n THEN a.nama_cabang\r\n ELSE b.nama_cabang \r\n END AS nama_cabang,\r\np.boxContain,\r\nIFNULL(a.iku,0) as iku,\r\nIFNULL(b.bku,0) as bku,\r\nIFNULL(c.iku_fulfill,0) as iku_fulfill,\r\nCASE WHEN a.iku < c.iku_fulfill\r\nAND b.bku > 1 \r\nTHEN \'Y\' ELSE \'N\' END AS y_n\r\nFROM \r\nproducts p \r\nLEFT JOIN tenants t ON p.tenant_id = t.id \r\nLEFT JOIN \r\n (\r\n SELECT COUNT(ikuses.id) as i'... ) | .../peralihan_manual.php:94 |