

===============================================================================
User: 12  |  Time: 15:12:11  |  URL: /customers/apple_clinic/InventoryAjax/submitCustomer

Array
(
    [0] => 23000
    [1] => 1062
    [2] => Duplicate entry 'sleiman sleiman--' for key 'Customer_Name'
)

INSERT                                      INTO                                          tbl_customers                                      (                                         Customer_Name,                                         Customer_Code,                                         Customer_Email,                                         Customer_Phone,                                         Customer_Work_Phone,                                         Customer_Mobile,                                         Customer_Company,                                         Customer_Country_ID,                                         Customer_City_ID,                                         Customer_Address,                                         Customer_Limit_Balance,                                         Customer_Discount,                                         Currency_ID,                                         Customer_CR,                                         Class_ID,                                         Customer_Lat,                                         Customer_Lng,                                         customer_due_date_period,                                         account_parent_id,                                         stop_invoice,                                         Logged_ID,                                         user_name,                                         password,                                         allergy_id,                                         intolerance_id,web_api_user_id,app_id,type,                                         customer_group_id,customer_class_id,region_id,customer_note,other_pay_acc_id,customer_vat,customer_additional_number,customer_postal_code,customer_other_id ,branch_id                                     )                                         VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Array
(
    [0] => sleiman sleiman
    [1] => 
    [2] => 
    [3] => 79109969
    [4] => 
    [5] => 79109969
    [6] => 
    [7] => 120
    [8] => 4198
    [9] => 
    [10] => 
    [11] => 
    [12] => 144
    [13] => 
    [14] => 1
    [15] => 
    [16] => 
    [17] => 
    [18] => 
    [19] => 
    [20] => 12
    [21] => 
    [22] => 6c991fe85d9fcaea917f71fbdc9e384e
    [23] => 
    [24] => 
    [25] => 
    [26] => 
    [27] => 0
    [28] => 
    [29] => 
    [30] => 
    [31] => 
    [32] => 
    [33] => 
    [34] => 
    [35] => 
    [36] => 
    [37] => 1
)


===============================================================================
User: 16  |  Time: 16:37:59  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1873,1874,1875,1876,1877,1878,1879,1880,1881,1882)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:05  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1883,1884,1885,1886,1887,1888,1889,1890,1891,1892)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:08  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1893,1894,1895,1896,1897,1898,1899,1900,1901,1902)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:09  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1903,1904,1905,1906,1907,1908,1909,1910,1911,1912)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:10  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1913,1914,1915,1916,1917,1918,1919,1920,1921,1922)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:14  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1923,1924,1925,1926,1927,1928,1929,1930,1931,1932)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:15  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1933,1934,1935,1936,1937,1938,1939,1940,1941,1942)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:16  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1943,1944,1945,1946,1947,1948,1949,1950,1951,1952)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:18  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1953,1954,1955,1956,1957,1958,1959,1960,1961,1962)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:21  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1963,1964,1965,1966,1967,1968,1969,1970,1971,1972)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:22  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1973,1974,1975,1976,1977,1978,1979,1980,1981,1982)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:22  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1983,1984,1985,1986,1987,1988,1989,1990,1991,1992)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:25  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1993,1994,1995,1996,1997,1998,1999,2000,2001,2002)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:26  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2003,2004,2005,2006,2007,2008,2009,2010,2011,2012)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:27  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2013,2014,2015,2016,2017,2018,2019,2020,2021,2022)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:27  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2023,2024,2025,2026,2027,2028,2029,2030,2031,2032)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:28  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2033,2034,2035,2036,2037,2038,2039,2040,2041,2042)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:30  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2043,2044,2045,2046,2047,2048,2049,2050,2051,2052)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:31  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2053,2054,2055,2056,2057,2058,2059,2060,2061,2062)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:32  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2063,2064,2065,2066,2067,2068,2069,2070,2071,2072)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:33  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2073,2074,2075,2076,2077,2078,2079,2080,2081,2082)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:33  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2083,2084,2085,2086,2087,2088,2089,2090,2091,2092)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:34  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2093,2094,2095,2096,2097,2098,2099,2100,2101,2102)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:35  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2103,2104,2105,2106,2107,2108,2109,2110,2111,2112)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:36  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2113,2114,2115,2116,2117,2118,2119,2120,2121,2122)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:37  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2123,2124,2125,2126,2127,2128,2129,2130,2131,2132)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:37  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2133,2134,2135,2136,2137,2138,2139,2140,2141,2142)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:38  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2143,2144,2145,2146,2147,2148,2149,2150,2151,2152)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:39  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2153,2154,2155,2156,2157,2158,2159,2160,2161,2162)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:40  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2163,2164,2165,2166,2167,2168,2169,2170,2171,2172)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:41  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2173,2174,2175,2176,2177,2178,2179,2180,2181,2182)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:41  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2183,2184,2185,2186,2187,2188,2189,2190,2191,2192)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:42  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2193,2194,2195,2196,2197,2198,2199,2200,2201,2202)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:43  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2203,2204,2205,2206,2207,2208,2209,2210,2211,2212)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:44  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2213,2214,2215,2216,2217,2218,2219,2220,2221,2222)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:45  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2223,2224,2225,2226,2227,2228,2229,2230,2384,2385)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:46  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2386,2387,2388,2389,2390,2391,2392,2393,2394,2395)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:49  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2396,2397,2398,2399,2400,2401,2402,2403,2404,2405)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:38:50  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2406,2407,2408,2409,2410,2411,2412,2413)    AND branch_id = "1"  AND Logged_ID in (16) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:00  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1873,1874,1875,1876,1877,1878,1879,1880,1881,1882)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:04  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1883,1884,1885,1886,1887,1888,1889,1890,1891,1892)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:05  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1893,1894,1895,1896,1897,1898,1899,1900,1901,1902)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:06  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1903,1904,1905,1906,1907,1908,1909,1910,1911,1912)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:06  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1913,1914,1915,1916,1917,1918,1919,1920,1921,1922)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:07  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1923,1924,1925,1926,1927,1928,1929,1930,1931,1932)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:08  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1933,1934,1935,1936,1937,1938,1939,1940,1941,1942)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:08  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1943,1944,1945,1946,1947,1948,1949,1950,1951,1952)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:09  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1953,1954,1955,1956,1957,1958,1959,1960,1961,1962)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:09  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1963,1964,1965,1966,1967,1968,1969,1970,1971,1972)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:10  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1973,1974,1975,1976,1977,1978,1979,1980,1981,1982)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:11  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1983,1984,1985,1986,1987,1988,1989,1990,1991,1992)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:12  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (1993,1994,1995,1996,1997,1998,1999,2000,2001,2002)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:13  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2003,2004,2005,2006,2007,2008,2009,2010,2011,2012)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:13  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2013,2014,2015,2016,2017,2018,2019,2020,2021,2022)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:14  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2023,2024,2025,2026,2027,2028,2029,2030,2031,2032)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:17  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2033,2034,2035,2036,2037,2038,2039,2040,2041,2042)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:18  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2043,2044,2045,2046,2047,2048,2049,2050,2051,2052)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:19  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2053,2054,2055,2056,2057,2058,2059,2060,2061,2062)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:19  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2063,2064,2065,2066,2067,2068,2069,2070,2071,2072)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:20  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2073,2074,2075,2076,2077,2078,2079,2080,2081,2082)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:21  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2083,2084,2085,2086,2087,2088,2089,2090,2091,2092)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:21  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2093,2094,2095,2096,2097,2098,2099,2100,2101,2102)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:22  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2103,2104,2105,2106,2107,2108,2109,2110,2111,2112)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:23  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2113,2114,2115,2116,2117,2118,2119,2120,2121,2122)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:23  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2123,2124,2125,2126,2127,2128,2129,2130,2131,2132)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:24  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2133,2134,2135,2136,2137,2138,2139,2140,2141,2142)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:24  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2143,2144,2145,2146,2147,2148,2149,2150,2151,2152)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:25  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2153,2154,2155,2156,2157,2158,2159,2160,2161,2162)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:26  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2163,2164,2165,2166,2167,2168,2169,2170,2171,2172)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:27  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2173,2174,2175,2176,2177,2178,2179,2180,2181,2182)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:28  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2183,2184,2185,2186,2187,2188,2189,2190,2191,2192)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:28  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2193,2194,2195,2196,2197,2198,2199,2200,2201,2202)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:29  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2203,2204,2205,2206,2207,2208,2209,2210,2211,2212)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:30  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2213,2214,2215,2216,2217,2218,2219,2220,2221,2222)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:32  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2223,2224,2225,2226,2227,2228,2229,2230,2384,2385)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:33  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2386,2387,2388,2389,2390,2391,2392,2393,2394,2395)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:36  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2396,2397,2398,2399,2400,2401,2402,2403,2404,2405)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)


===============================================================================
User: 16  |  Time: 16:39:37  |  URL: /customers/apple_clinic/InventoryAjax/monthly_sales_report_ajax

Array
(
    [0] => 23000
    [1] => 1052
    [2] => Column 'branch_id' in where clause is ambiguous
)

SELECT d.Product_ID,             sum(d.Product_Total_Price*i.current_rate*p.default_view_rate) as price,             sum(d.Product_Quantity/p.default_view_rate) as qty,             DATE_FORMAT(i.Invoice_Date,"%Y") as year,             DATE_FORMAT(i.Invoice_Date,"%m") as month             FROM tbl_invoice_products_details d join tbl_invoices i              on i.Invoice_ID_Auto = d.Invoice_ID_Auto             join tbl_stock_products p on p.Product_ID = d.Product_ID             where d.Product_ID in (2406,2407,2408,2409,2410,2411,2412,2413)    AND branch_id = "1"  AND Logged_ID in (16,12) and is_actual = 0              group by d.Product_ID,year(i.Invoice_Date),month(i.Invoice_Date)
