SQLSTATE[21000]: Cardinality violation: 1222 The used SELECT statements have a different number of columns from OtramsDB.php on 05-07-2020 05:38:44
 Query:select * from xmllogs where reservation_id='2774' and source_type = 'localsystem'
	   UNION  select * from xmllogs_archive where reservation_id='2774' and source_type = 'localsystem'

/tms/booking_detail.php?booking_id=2777&reservation_id=RDT2020061576&print_sum=1&service=hotel

SQLSTATE[21000]: Cardinality violation: 1222 The used SELECT statements have a different number of columns from OtramsDB.php on 05-07-2020 05:38:44
 Query:select * from xmllogs where reservation_id='2775' and source_type = 'localsystem'
	   UNION  select * from xmllogs_archive where reservation_id='2775' and source_type = 'localsystem'

/tms/booking_detail.php?booking_id=2777&reservation_id=RDT2020061576&print_sum=1&service=hotel

SQLSTATE[21000]: Cardinality violation: 1222 The used SELECT statements have a different number of columns from OtramsDB.php on 05-07-2020 05:38:44
 Query:select * from xmllogs where reservation_id='2776' and source_type = 'localsystem'
	   UNION  select * from xmllogs_archive where reservation_id='2776' and source_type = 'localsystem'

/tms/booking_detail.php?booking_id=2777&reservation_id=RDT2020061576&print_sum=1&service=hotel

SQLSTATE[21000]: Cardinality violation: 1222 The used SELECT statements have a different number of columns from OtramsDB.php on 05-07-2020 05:38:45
 Query:select * from xmllogs where reservation_id='2777' and source_type = 'localsystem'
	   UNION  select * from xmllogs_archive where reservation_id='2777' and source_type = 'localsystem'

/tms/booking_detail.php?booking_id=2777&reservation_id=RDT2020061576&print_sum=1&service=hotel

SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION otrams_thefabulousgetaway_alpha.agent_reference does not exist from OtramsDB.php on 25-07-2020 01:42:13
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,GROUP_CONCAT(DATE(q.service_date)) as service_date, GROUP_CONCAT(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND q.unique_id IN ('QTECHCD00251','QTECHCA002217','RDTCD0021183','QTECHCA002212','QTECHCA002216','CD0021Q4','RDTCD0021184','QTECHCA002211','QTECHCA002215','QTECHCA002213','QTECHCA002214','RDTCA0021Q93_1','RDTCA0021177','RDTCA0021182','RDTCA0021181','RDTCA0021180','RDTCA0021179','RDTCA0021178','CD0003Q8','RDTCA0021Q176','RDTCA0021Q172','RDTCA0021Q174','QTECHCA0022Q10','RDTCA0021Q175','RDTCA0021Q173')  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
            UNION ALL
            SELECT booking_code, reservation_id, service' at line 1 from OtramsDB.php on 25-07-2020 02:18:11
 Query:select count(*) as cnt from (SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='sale'  and b.booking_branch_id in ()
            UNION ALL
            SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a
                    WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='debitnote'  and b.booking_branch_id in ()
            UNION ALL
            SELECT  booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, r.create_date AS document_date, receipt_type doc_type, r.amount_received tamount, (r.amount_received*r.accounting_multiplier) amount FROM receipts r LEFT JOIN bookings b ON r.booking_ref = b.id
            LEFT JOIN agents a ON r.agent_id=a.id
                    WHERE receipt_type ='credit_note'  and a.branch_id in ()) as countdata

/tms/controller.php?page=sales_register&action=search&trhuogh_ajax=yes&pageno=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
            UNION ALL
            SELECT booking_code, reservation_id, service' at line 1 from OtramsDB.php on 25-07-2020 02:18:12
 Query:SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='sale'  and b.booking_branch_id in ()
            UNION ALL
            SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a
                    WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='debitnote'  and b.booking_branch_id in ()
            UNION ALL
            SELECT  booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, r.create_date AS document_date, receipt_type doc_type, r.amount_received tamount, (r.amount_received*r.accounting_multiplier) amount FROM receipts r LEFT JOIN bookings b ON r.booking_ref = b.id
            LEFT JOIN agents a ON r.agent_id=a.id
                    WHERE receipt_type ='credit_note'  and a.branch_id in () LIMIT 0,25 

/tms/controller.php?page=sales_register&action=search&trhuogh_ajax=yes&pageno=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
            UNION ALL
            SELECT booking_code, reservation_id, service' at line 1 from OtramsDB.php on 25-07-2020 02:18:12
 Query:select doc_type, sum(amount) as total_amount from (SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='sale'  and b.booking_branch_id in ()
            UNION ALL
            SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a
                    WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='debitnote'  and b.booking_branch_id in ()
            UNION ALL
            SELECT  booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, r.create_date AS document_date, receipt_type doc_type, r.amount_received tamount, (r.amount_received*r.accounting_multiplier) amount FROM receipts r LEFT JOIN bookings b ON r.booking_ref = b.id
            LEFT JOIN agents a ON r.agent_id=a.id
                    WHERE receipt_type ='credit_note'  and a.branch_id in ()) as totalvalue group by doc_type order by doc_type desc 

/tms/controller.php?page=sales_register&action=search&trhuogh_ajax=yes&pageno=1

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'vehicle_id' in 'field list' from OtramsDB.php on 29-07-2020 11:46:31
 Query:SELECT vehicle_id,vehicle_desc FROM bookings_packages b LEFT JOIN vehicle_type v ON b.vehicle_id=v.id WHERE booking_id='0' AND service_id='4' AND supplier_id='S000000066'

/tms/logistics.php?module=assignmentSheet&action=viewAssignVehicleGuide&type=undefined&booking_id=437&serviceName=Road%20Transfer&assignment_number=

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'vehicle_id' in 'field list' from OtramsDB.php on 29-07-2020 12:05:06
 Query:SELECT vehicle_id,vehicle_desc FROM bookings_packages b LEFT JOIN vehicle_type v ON b.vehicle_id=v.id WHERE booking_id='0' AND service_id='204' AND supplier_id='S000000003'

/tms/logistics.php?module=assignmentSheet&action=viewAssignVehicleGuide&type=undefined&booking_id=438&serviceName=Leisure%20Day&assignment_number=L00074

SQLSTATE[21000]: Cardinality violation: 1222 The used SELECT statements have a different number of columns from OtramsDB.php on 30-07-2020 10:49:20
 Query:select * from xmllogs where reservation_id='2786' and source_type = 'localsystem'
	   UNION  select * from xmllogs_archive where reservation_id='2786' and source_type = 'localsystem'

/tms/booking_detail.php?booking_id=2786&reservation_id=QTECH2020071674&onload=1&service=hotel

SQLSTATE[21000]: Cardinality violation: 1222 The used SELECT statements have a different number of columns from OtramsDB.php on 30-07-2020 10:54:12
 Query:select * from xmllogs where reservation_id='2789' and source_type = 'localsystem'
	   UNION  select * from xmllogs_archive where reservation_id='2789' and source_type = 'localsystem'

/tms/booking_detail.php?booking_id=2789&reservation_id=QTECH2020071675&onload=1&service=hotel

SQLSTATE[21000]: Cardinality violation: 1222 The used SELECT statements have a different number of columns from OtramsDB.php on 30-07-2020 10:54:22
 Query:select * from xmllogs where reservation_id='2790' and source_type = 'localtransfer'
	   UNION  select * from xmllogs_archive where reservation_id='2790' and source_type = 'localtransfer'

/tms/booking_detail.php?booking_id=2790&reservation_id=QTECH2020071675&onload=1&service=transfer

SQLSTATE[21000]: Cardinality violation: 1222 The used SELECT statements have a different number of columns from OtramsDB.php on 30-07-2020 10:54:34
 Query:select * from xmllogs where reservation_id='2791' and source_type = 'localsightseeing'
	   UNION  select * from xmllogs_archive where reservation_id='2791' and source_type = 'localsightseeing'

/tms/booking_detail.php?booking_id=2791&reservation_id=QTECH2020071675&onload=1&service=sightseeing

SQLSTATE[21000]: Cardinality violation: 1222 The used SELECT statements have a different number of columns from OtramsDB.php on 30-07-2020 10:54:42
 Query:select * from xmllogs where reservation_id='2792' and source_type = 'misc'
	   UNION  select * from xmllogs_archive where reservation_id='2792' and source_type = 'misc'

/tms/booking_detail.php?booking_id=2792&reservation_id=QTECH2020071675&onload=1&service=misc

SQLSTATE[21000]: Cardinality violation: 1222 The used SELECT statements have a different number of columns from OtramsDB.php on 30-07-2020 01:05:12
 Query:select * from xmllogs where reservation_id='2792' and source_type = 'misc'
	   UNION  select * from xmllogs_archive where reservation_id='2792' and source_type = 'misc'

/tms/booking_detail.php?booking_id=2792&print_sum=1&reservation_id=QTECH2020071675&print_sum=1&service=misc

SQLSTATE[21000]: Cardinality violation: 1222 The used SELECT statements have a different number of columns from OtramsDB.php on 30-07-2020 01:05:44
 Query:select * from xmllogs where reservation_id='2792' and source_type = 'misc'
	   UNION  select * from xmllogs_archive where reservation_id='2792' and source_type = 'misc'

/tms/booking_detail.php?booking_id=2792&print_sum=1&reservation_id=QTECH2020071675&print_sum=1&service=misc

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'assigned_to' in 'where clause' from OtramsDB.php on 30-07-2020 01:20:21
 Query:SELECT mn.*, b.source_type  FROM msg_note mn, bookings b  WHERE mn.note_delete!='Y' AND b.id=mn.booking_id AND mn.site_id = 0 AND (b.booking_code = 'TFG402792' or b.id = 'TFG402792') AND assigned_to like '%nitinalpha%'  ORDER BY mn.note_datetime DESC

/tms/search_note.php

SQLSTATE[21000]: Cardinality violation: 1222 The used SELECT statements have a different number of columns from OtramsDB.php on 30-07-2020 01:36:24
 Query:select * from xmllogs where reservation_id='2793' and source_type = 'localsystem'
	   UNION  select * from xmllogs_archive where reservation_id='2793' and source_type = 'localsystem'

/tms/booking_detail.php?booking_id=2793&reservation_id=QTECH2020071685&onload=1&service=hotel

SQLSTATE[21000]: Cardinality violation: 1222 The used SELECT statements have a different number of columns from OtramsDB.php on 30-07-2020 01:37:43
 Query:select * from xmllogs where reservation_id='2793' and source_type = 'localsystem'
	   UNION  select * from xmllogs_archive where reservation_id='2793' and source_type = 'localsystem'

/tms/booking_detail.php?booking_id=2793&reservation_id=QTECH2020071685&onload=1&service=hotel

SQLSTATE[21000]: Cardinality violation: 1222 The used SELECT statements have a different number of columns from OtramsDB.php on 30-07-2020 01:41:14
 Query:select * from xmllogs where reservation_id='2793' and source_type = 'localsystem'
	   UNION  select * from xmllogs_archive where reservation_id='2793' and source_type = 'localsystem'

/tms/booking_detail.php?booking_id=2793&reservation_id=QTECH2020071685&service=hotel&onload=1

SQLSTATE[21000]: Cardinality violation: 1222 The used SELECT statements have a different number of columns from OtramsDB.php on 30-07-2020 01:45:21
 Query:select * from xmllogs where reservation_id='2793' and source_type = 'localsystem'
	   UNION  select * from xmllogs_archive where reservation_id='2793' and source_type = 'localsystem'

/tms/booking_detail.php?booking_id=2793&reservation_id=QTECH2020071685&print_sum=1&service=hotel

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'vehicle_id' in 'field list' from OtramsDB.php on 04-08-2020 07:25:21
 Query:SELECT vehicle_id FROM bookings_packages WHERE booking_id='0' AND service_id='27' AND supplier_id='S000000068'

/tms/view_booking_sight.php?action_name=view_sight_booking_modification&booking_id=2796

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
            UNION ALL
            SELECT booking_code, reservation_id, service' at line 1 from OtramsDB.php on 04-08-2020 11:41:47
 Query:select count(*) as cnt from (SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='sale'  and b.booking_branch_id in ()
            UNION ALL
            SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a
                    WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='debitnote'  and b.booking_branch_id in ()
            UNION ALL
            SELECT  booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, r.create_date AS document_date, receipt_type doc_type, r.amount_received tamount, (r.amount_received*r.accounting_multiplier) amount FROM receipts r LEFT JOIN bookings b ON r.booking_ref = b.id
            LEFT JOIN agents a ON r.agent_id=a.id
                    WHERE receipt_type ='credit_note'  and a.branch_id in ()) as countdata

/tms/controller.php?page=sales_register&action=search&trhuogh_ajax=yes&pageno=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
            UNION ALL
            SELECT booking_code, reservation_id, service' at line 1 from OtramsDB.php on 04-08-2020 11:41:47
 Query:SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='sale'  and b.booking_branch_id in ()
            UNION ALL
            SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a
                    WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='debitnote'  and b.booking_branch_id in ()
            UNION ALL
            SELECT  booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, r.create_date AS document_date, receipt_type doc_type, r.amount_received tamount, (r.amount_received*r.accounting_multiplier) amount FROM receipts r LEFT JOIN bookings b ON r.booking_ref = b.id
            LEFT JOIN agents a ON r.agent_id=a.id
                    WHERE receipt_type ='credit_note'  and a.branch_id in () LIMIT 0,25 

/tms/controller.php?page=sales_register&action=search&trhuogh_ajax=yes&pageno=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
            UNION ALL
            SELECT booking_code, reservation_id, service' at line 1 from OtramsDB.php on 04-08-2020 11:41:47
 Query:select doc_type, sum(amount) as total_amount from (SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='sale'  and b.booking_branch_id in ()
            UNION ALL
            SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a
                    WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='debitnote'  and b.booking_branch_id in ()
            UNION ALL
            SELECT  booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, r.create_date AS document_date, receipt_type doc_type, r.amount_received tamount, (r.amount_received*r.accounting_multiplier) amount FROM receipts r LEFT JOIN bookings b ON r.booking_ref = b.id
            LEFT JOIN agents a ON r.agent_id=a.id
                    WHERE receipt_type ='credit_note'  and a.branch_id in ()) as totalvalue group by doc_type order by doc_type desc 

/tms/controller.php?page=sales_register&action=search&trhuogh_ajax=yes&pageno=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
            UNION ALL
            SELECT booking_code, reservation_id, service' at line 1 from OtramsDB.php on 04-08-2020 11:41:53
 Query:select count(*) as cnt from (SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='sale'  and b.booking_branch_id in ()
            UNION ALL
            SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a
                    WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='debitnote'  and b.booking_branch_id in ()
            UNION ALL
            SELECT  booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, r.create_date AS document_date, receipt_type doc_type, r.amount_received tamount, (r.amount_received*r.accounting_multiplier) amount FROM receipts r LEFT JOIN bookings b ON r.booking_ref = b.id
            LEFT JOIN agents a ON r.agent_id=a.id
                    WHERE receipt_type ='credit_note'  and a.branch_id in ()) as countdata

/tms/controller.php?page=sales_register&action=search&trhuogh_ajax=yes&pageno=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
            UNION ALL
            SELECT booking_code, reservation_id, service' at line 1 from OtramsDB.php on 04-08-2020 11:41:53
 Query:SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='sale'  and b.booking_branch_id in ()
            UNION ALL
            SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a
                    WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='debitnote'  and b.booking_branch_id in ()
            UNION ALL
            SELECT  booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, r.create_date AS document_date, receipt_type doc_type, r.amount_received tamount, (r.amount_received*r.accounting_multiplier) amount FROM receipts r LEFT JOIN bookings b ON r.booking_ref = b.id
            LEFT JOIN agents a ON r.agent_id=a.id
                    WHERE receipt_type ='credit_note'  and a.branch_id in () LIMIT 0,25 

/tms/controller.php?page=sales_register&action=search&trhuogh_ajax=yes&pageno=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
            UNION ALL
            SELECT booking_code, reservation_id, service' at line 1 from OtramsDB.php on 04-08-2020 11:41:53
 Query:select doc_type, sum(amount) as total_amount from (SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='sale'  and b.booking_branch_id in ()
            UNION ALL
            SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a
                    WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='debitnote'  and b.booking_branch_id in ()
            UNION ALL
            SELECT  booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, r.create_date AS document_date, receipt_type doc_type, r.amount_received tamount, (r.amount_received*r.accounting_multiplier) amount FROM receipts r LEFT JOIN bookings b ON r.booking_ref = b.id
            LEFT JOIN agents a ON r.agent_id=a.id
                    WHERE receipt_type ='credit_note'  and a.branch_id in ()) as totalvalue group by doc_type order by doc_type desc 

/tms/controller.php?page=sales_register&action=search&trhuogh_ajax=yes&pageno=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
            UNION ALL
            SELECT booking_code, reservation_id, service' at line 1 from OtramsDB.php on 05-08-2020 05:34:53
 Query:select count(*) as cnt from (SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='sale'  and b.booking_branch_id in ()
            UNION ALL
            SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a
                    WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='debitnote'  and b.booking_branch_id in ()
            UNION ALL
            SELECT  booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, r.create_date AS document_date, receipt_type doc_type, r.amount_received tamount, (r.amount_received*r.accounting_multiplier) amount FROM receipts r LEFT JOIN bookings b ON r.booking_ref = b.id
            LEFT JOIN agents a ON r.agent_id=a.id
                    WHERE receipt_type ='credit_note'  and a.branch_id in ()) as countdata

/tms/controller.php?page=sales_register&action=search&trhuogh_ajax=yes&pageno=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
            UNION ALL
            SELECT booking_code, reservation_id, service' at line 1 from OtramsDB.php on 05-08-2020 05:34:53
 Query:SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='sale'  and b.booking_branch_id in ()
            UNION ALL
            SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a
                    WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='debitnote'  and b.booking_branch_id in ()
            UNION ALL
            SELECT  booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, r.create_date AS document_date, receipt_type doc_type, r.amount_received tamount, (r.amount_received*r.accounting_multiplier) amount FROM receipts r LEFT JOIN bookings b ON r.booking_ref = b.id
            LEFT JOIN agents a ON r.agent_id=a.id
                    WHERE receipt_type ='credit_note'  and a.branch_id in () LIMIT 0,25 

/tms/controller.php?page=sales_register&action=search&trhuogh_ajax=yes&pageno=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
            UNION ALL
            SELECT booking_code, reservation_id, service' at line 1 from OtramsDB.php on 05-08-2020 05:34:53
 Query:select doc_type, sum(amount) as total_amount from (SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='sale'  and b.booking_branch_id in ()
            UNION ALL
            SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a
                    WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='debitnote'  and b.booking_branch_id in ()
            UNION ALL
            SELECT  booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, r.create_date AS document_date, receipt_type doc_type, r.amount_received tamount, (r.amount_received*r.accounting_multiplier) amount FROM receipts r LEFT JOIN bookings b ON r.booking_ref = b.id
            LEFT JOIN agents a ON r.agent_id=a.id
                    WHERE receipt_type ='credit_note'  and a.branch_id in ()) as totalvalue group by doc_type order by doc_type desc 

/tms/controller.php?page=sales_register&action=search&trhuogh_ajax=yes&pageno=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) as countdata' at line 8 from OtramsDB.php on 05-08-2020 05:41:51
 Query:select count(*) as cnt from (SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='sale' 
			UNION ALL
			SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a
			WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='debitnote' 
			UNION ALL
			SELECT  booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, r.create_date AS document_date, receipt_type doc_type, r.amount_received tamount, (r.amount_received*r.accounting_multiplier) amount FROM receipts r LEFT JOIN bookings b ON r.booking_ref = b.id
			LEFT JOIN agents a ON r.agent_id=a.id
			WHERE receipt_type ='credit_note'  and a.branch_id in ()) as countdata

/tms/controller.php?page=sales_register&action=search&trhuogh_ajax=yes&pageno=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIMIT 0,25' at line 8 from OtramsDB.php on 05-08-2020 05:41:51
 Query:SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='sale' 
			UNION ALL
			SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a
			WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='debitnote' 
			UNION ALL
			SELECT  booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, r.create_date AS document_date, receipt_type doc_type, r.amount_received tamount, (r.amount_received*r.accounting_multiplier) amount FROM receipts r LEFT JOIN bookings b ON r.booking_ref = b.id
			LEFT JOIN agents a ON r.agent_id=a.id
			WHERE receipt_type ='credit_note'  and a.branch_id in () LIMIT 0,25 

/tms/controller.php?page=sales_register&action=search&trhuogh_ajax=yes&pageno=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) as totalvalue group by doc_type order by doc_type desc' at line 8 from OtramsDB.php on 05-08-2020 05:41:51
 Query:select doc_type, sum(amount) as total_amount from (SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='sale' 
			UNION ALL
			SELECT booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, bri.create_date AS document_date, bri.acc_type doc_type, bri.agent_price tamount, (bri.agent_price*bri.accounting_multiplier) amount FROM booking_rate_info bri , bookings b, agents a
			WHERE b.id = bri.booking_id AND b.parent_agent_id=a.id AND bri.acc_type ='debitnote' 
			UNION ALL
			SELECT  booking_code, reservation_id, service_date as check_in, check_out_date, b.consultant_id, display_currency_code, parent_agent_id, a.agency_name, agent_reference(a.id,a.agent_type) AS agent_code, r.create_date AS document_date, receipt_type doc_type, r.amount_received tamount, (r.amount_received*r.accounting_multiplier) amount FROM receipts r LEFT JOIN bookings b ON r.booking_ref = b.id
			LEFT JOIN agents a ON r.agent_id=a.id
			WHERE receipt_type ='credit_note'  and a.branch_id in ()) as totalvalue group by doc_type order by doc_type desc 

/tms/controller.php?page=sales_register&action=search&trhuogh_ajax=yes&pageno=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Array   group by year(CONVERT_TZ(b.create_date ,'+00:00','+5:30')) order by b.cr' at line 1 from OtramsDB.php on 06-08-2020 05:25:05
 Query:SELECT count(*) as iCount ,  year(CONVERT_TZ(b.create_date ,'+00:00','+5:30')) as col  from agent_logs as b   where  1 and b.create_date !='' and  b.create_date!='0000-00-00 00:00:00'   Array   group by year(CONVERT_TZ(b.create_date ,'+00:00','+5:30')) order by b.create_date  asc

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Array   group by year(CONVERT_TZ(b.create_date ,'+00:00','+5:30')) order by b.cr' at line 1 from OtramsDB.php on 06-08-2020 05:39:25
 Query:SELECT count(*) as iCount ,  year(CONVERT_TZ(b.create_date ,'+00:00','+5:30')) as col  from agent_logs as b   where  1 and b.create_date !='' and  b.create_date!='0000-00-00 00:00:00'   Array   group by year(CONVERT_TZ(b.create_date ,'+00:00','+5:30')) order by b.create_date  asc

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND parent_booking=0' at line 4 from OtramsDB.php on 07-08-2020 05:54:07
 Query:SELECT b.id, IF(''='system_currency',bri.agent_price * bri.accounting_multiplier,bri.agent_price) AS rate,
                    b.service_type FROM bookings AS b
                    INNER JOIN booking_rate_info AS bri ON b.id = bri.booking_id AND acc_type ='sale'
                    WHERE b.invoice_number = ? AND b.parent_agent_id =  AND parent_booking='2020/365' 

/print_invoice.php?id=2789&type=hotel

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND parent_booking=0' at line 4 from OtramsDB.php on 07-08-2020 05:58:28
 Query:SELECT b.id, IF(''='system_currency',bri.agent_price * bri.accounting_multiplier,bri.agent_price) AS rate,
                    b.service_type FROM bookings AS b
                    INNER JOIN booking_rate_info AS bri ON b.id = bri.booking_id AND acc_type ='sale'
                    WHERE b.invoice_number = ? AND b.parent_agent_id =  AND parent_booking='2020/365' 

/print_invoice.php?id=2789&type=hotel&ez_queries=1

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.credit_days' in 'field list' from OtramsDB.php on 21-08-2020 06:55:09
 Query:SELECT a.id AS LedgerID,agent_reference(a.id,a.agent_type) AS LedgerCode,CONCAT(a.agency_name,' (',agent_reference(a.id,a.agent_type),')') AS LedgerName,
        a.address AS Address,a.pincode AS Pincode,
        CONCAT_WS(a.first_name,a.last_name) AS ContactName,a.phone AS Phone,a.fax AS Fax,a.mobile AS Mobile,a.email AS Email,'agent' AS `Type`,
        a.country AS Country,a.agent_type AS LedgerType,a.branch_id AS BranchID,a.city AS City,a.currency AS Currency,a.logo AS Logo,a.time_zone_offset AS TimeOffset,
        a.consultant_id AS ConsultantID,ati.tax_registration_no AS TaxRegNo,ati.registration_date AS TaxRegDate,ati.registration_country AS TaxRegCountry,'OP' AS TaxType,
        a.accounting_id as AccountingID,a.status AS Status, a.credit_days As CreditDays,
        '' AS BankName, '' AS BankCode, '' AS AccName, '' AS AccountNumber
        FROM agents AS a
        LEFT JOIN account_tax_information AS ati ON a.id = ati.entity_id AND entity_table = 'agent'
        WHERE a.parent_agent='0' and site_id='0' AND a.accounts_processed='0' AND a.agency_name !=''  AND FIND_IN_SET(a.branch_id,'1')
        UNION ALL
        SELECT s.id AS LedgerID,s.en_supplier_code AS LedgerCode,CONCAT(s.company_name,' (',s.supplier_code,')') AS LedgerName,s.address AS Address,s.pincode AS Pincode,
        CONCAT_WS(s.first_name,s.last_name) AS ContactName,s.phone AS Phone,'' AS Fax,s.mobile AS Mobile,s.email AS Email,'supplier' AS `Type`,
        s.country AS Country,'online' AS LedgerType,'' AS BranchID,s.city AS City,'' AS Currency,'' AS Logo,s.time_zone_offset AS TimeOffset,'' AS ConsultantID,
        ati.tax_registration_no AS TaxRegNo,ati.registration_date AS TaxRegDate,ati.registration_country AS TaxRegCountry,'IP' AS TaxType,s.accounting_id as AccountingID,
        s.status AS Status, '' As CreditDays, '' AS BankName, '' AS BankCode, '' AS AccName, '' AS AccountNumber
        FROM suppliers AS s
        LEFT JOIN account_tax_information AS ati ON s.id = ati.entity_id AND entity_table = 'suppliers'
        WHERE s.accounts_processed='0' AND s.company_name !=''
        UNION ALL
        SELECT s.SupplierId AS LedgerID,s.SupplierId AS LedgerCode,CONCAT(SupplierName,' (',s.SupplierId,')') AS LedgerName,s.Address, '' AS Pincode,
        s.SupplierName AS ContactName,s.TelNo AS Phone,s.Fax,s.Mobile,s.Email,'supplier' AS `Type`,
        s.CountryID AS Country,'offline' AS LedgerType,'' AS BranchID,s.CityID AS City,'' AS Currency,'' AS Logo,s.time_zone_offset AS TimeOffset,'' AS ConsultantID,
        ati.tax_registration_no,ati.registration_date,ati.registration_country ,'IP' AS TaxType,s.accounting_id as AccountingID,s.Visible AS Status, '' As CreditDays,  s.bank_name AS BankName, s.swift_code AS BankCode, s.acc_name AS AccName, s.acc_no AS AccountNumber
        FROM supplier AS s
        LEFT JOIN account_tax_information AS ati ON s.SupplierId = ati.entity_id AND entity_table = 'supplier'
        WHERE s.accounts_processed='0' AND s.SupplierName !=''

/crons/v3_accounting_report.php

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.credit_days' in 'field list' from OtramsDB.php on 21-08-2020 06:59:03
 Query:SELECT a.id AS LedgerID,agent_reference(a.id,a.agent_type) AS LedgerCode,CONCAT(a.agency_name,' (',agent_reference(a.id,a.agent_type),')') AS LedgerName,
        a.address AS Address,a.pincode AS Pincode,
        CONCAT_WS(a.first_name,a.last_name) AS ContactName,a.phone AS Phone,a.fax AS Fax,a.mobile AS Mobile,a.email AS Email,'agent' AS `Type`,
        a.country AS Country,a.agent_type AS LedgerType,a.branch_id AS BranchID,a.city AS City,a.currency AS Currency,a.logo AS Logo,a.time_zone_offset AS TimeOffset,
        a.consultant_id AS ConsultantID,ati.tax_registration_no AS TaxRegNo,ati.registration_date AS TaxRegDate,ati.registration_country AS TaxRegCountry,'OP' AS TaxType,
        a.accounting_id as AccountingID,a.status AS Status, a.credit_days As CreditDays,
        '' AS BankName, '' AS BankCode, '' AS AccName, '' AS AccountNumber
        FROM agents AS a
        LEFT JOIN account_tax_information AS ati ON a.id = ati.entity_id AND entity_table = 'agent'
        WHERE a.parent_agent='0' and site_id='0' AND a.accounts_processed='0' AND a.agency_name !=''  AND FIND_IN_SET(a.branch_id,'1,2,3,4')
        UNION ALL
        SELECT s.id AS LedgerID,s.en_supplier_code AS LedgerCode,CONCAT(s.company_name,' (',s.supplier_code,')') AS LedgerName,s.address AS Address,s.pincode AS Pincode,
        CONCAT_WS(s.first_name,s.last_name) AS ContactName,s.phone AS Phone,'' AS Fax,s.mobile AS Mobile,s.email AS Email,'supplier' AS `Type`,
        s.country AS Country,'online' AS LedgerType,'' AS BranchID,s.city AS City,'' AS Currency,'' AS Logo,s.time_zone_offset AS TimeOffset,'' AS ConsultantID,
        ati.tax_registration_no AS TaxRegNo,ati.registration_date AS TaxRegDate,ati.registration_country AS TaxRegCountry,'IP' AS TaxType,s.accounting_id as AccountingID,
        s.status AS Status, '' As CreditDays, '' AS BankName, '' AS BankCode, '' AS AccName, '' AS AccountNumber
        FROM suppliers AS s
        LEFT JOIN account_tax_information AS ati ON s.id = ati.entity_id AND entity_table = 'suppliers'
        WHERE s.accounts_processed='0' AND s.company_name !=''
        UNION ALL
        SELECT s.SupplierId AS LedgerID,s.SupplierId AS LedgerCode,CONCAT(SupplierName,' (',s.SupplierId,')') AS LedgerName,s.Address, '' AS Pincode,
        s.SupplierName AS ContactName,s.TelNo AS Phone,s.Fax,s.Mobile,s.Email,'supplier' AS `Type`,
        s.CountryID AS Country,'offline' AS LedgerType,'' AS BranchID,s.CityID AS City,'' AS Currency,'' AS Logo,s.time_zone_offset AS TimeOffset,'' AS ConsultantID,
        ati.tax_registration_no,ati.registration_date,ati.registration_country ,'IP' AS TaxType,s.accounting_id as AccountingID,s.Visible AS Status, '' As CreditDays,  s.bank_name AS BankName, s.swift_code AS BankCode, s.acc_name AS AccName, s.acc_no AS AccountNumber
        FROM supplier AS s
        LEFT JOIN account_tax_information AS ati ON s.SupplierId = ati.entity_id AND entity_table = 'supplier'
        WHERE s.accounts_processed='0' AND s.SupplierName !=''

/crons/v3_accounting_report.php

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.credit_days' in 'field list' from OtramsDB.php on 21-08-2020 06:59:11
 Query:SELECT a.id AS LedgerID,agent_reference(a.id,a.agent_type) AS LedgerCode,CONCAT(a.agency_name,' (',agent_reference(a.id,a.agent_type),')') AS LedgerName,
        a.address AS Address,a.pincode AS Pincode,
        CONCAT_WS(a.first_name,a.last_name) AS ContactName,a.phone AS Phone,a.fax AS Fax,a.mobile AS Mobile,a.email AS Email,'agent' AS `Type`,
        a.country AS Country,a.agent_type AS LedgerType,a.branch_id AS BranchID,a.city AS City,a.currency AS Currency,a.logo AS Logo,a.time_zone_offset AS TimeOffset,
        a.consultant_id AS ConsultantID,ati.tax_registration_no AS TaxRegNo,ati.registration_date AS TaxRegDate,ati.registration_country AS TaxRegCountry,'OP' AS TaxType,
        a.accounting_id as AccountingID,a.status AS Status, a.credit_days As CreditDays,
        '' AS BankName, '' AS BankCode, '' AS AccName, '' AS AccountNumber
        FROM agents AS a
        LEFT JOIN account_tax_information AS ati ON a.id = ati.entity_id AND entity_table = 'agent'
        WHERE a.parent_agent='0' and site_id='0' AND a.accounts_processed='0' AND a.agency_name !=''  AND FIND_IN_SET(a.branch_id,'1,2,3,4')
        UNION ALL
        SELECT s.id AS LedgerID,s.en_supplier_code AS LedgerCode,CONCAT(s.company_name,' (',s.supplier_code,')') AS LedgerName,s.address AS Address,s.pincode AS Pincode,
        CONCAT_WS(s.first_name,s.last_name) AS ContactName,s.phone AS Phone,'' AS Fax,s.mobile AS Mobile,s.email AS Email,'supplier' AS `Type`,
        s.country AS Country,'online' AS LedgerType,'' AS BranchID,s.city AS City,'' AS Currency,'' AS Logo,s.time_zone_offset AS TimeOffset,'' AS ConsultantID,
        ati.tax_registration_no AS TaxRegNo,ati.registration_date AS TaxRegDate,ati.registration_country AS TaxRegCountry,'IP' AS TaxType,s.accounting_id as AccountingID,
        s.status AS Status, '' As CreditDays, '' AS BankName, '' AS BankCode, '' AS AccName, '' AS AccountNumber
        FROM suppliers AS s
        LEFT JOIN account_tax_information AS ati ON s.id = ati.entity_id AND entity_table = 'suppliers'
        WHERE s.accounts_processed='0' AND s.company_name !=''
        UNION ALL
        SELECT s.SupplierId AS LedgerID,s.SupplierId AS LedgerCode,CONCAT(SupplierName,' (',s.SupplierId,')') AS LedgerName,s.Address, '' AS Pincode,
        s.SupplierName AS ContactName,s.TelNo AS Phone,s.Fax,s.Mobile,s.Email,'supplier' AS `Type`,
        s.CountryID AS Country,'offline' AS LedgerType,'' AS BranchID,s.CityID AS City,'' AS Currency,'' AS Logo,s.time_zone_offset AS TimeOffset,'' AS ConsultantID,
        ati.tax_registration_no,ati.registration_date,ati.registration_country ,'IP' AS TaxType,s.accounting_id as AccountingID,s.Visible AS Status, '' As CreditDays,  s.bank_name AS BankName, s.swift_code AS BankCode, s.acc_name AS AccName, s.acc_no AS AccountNumber
        FROM supplier AS s
        LEFT JOIN account_tax_information AS ati ON s.SupplierId = ati.entity_id AND entity_table = 'supplier'
        WHERE s.accounts_processed='0' AND s.SupplierName !=''

/crons/v3_accounting_report.php

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.credit_days' in 'field list' from OtramsDB.php on 21-08-2020 06:59:14
 Query:SELECT a.id AS LedgerID,agent_reference(a.id,a.agent_type) AS LedgerCode,CONCAT(a.agency_name,' (',agent_reference(a.id,a.agent_type),')') AS LedgerName,
        a.address AS Address,a.pincode AS Pincode,
        CONCAT_WS(a.first_name,a.last_name) AS ContactName,a.phone AS Phone,a.fax AS Fax,a.mobile AS Mobile,a.email AS Email,'agent' AS `Type`,
        a.country AS Country,a.agent_type AS LedgerType,a.branch_id AS BranchID,a.city AS City,a.currency AS Currency,a.logo AS Logo,a.time_zone_offset AS TimeOffset,
        a.consultant_id AS ConsultantID,ati.tax_registration_no AS TaxRegNo,ati.registration_date AS TaxRegDate,ati.registration_country AS TaxRegCountry,'OP' AS TaxType,
        a.accounting_id as AccountingID,a.status AS Status, a.credit_days As CreditDays,
        '' AS BankName, '' AS BankCode, '' AS AccName, '' AS AccountNumber
        FROM agents AS a
        LEFT JOIN account_tax_information AS ati ON a.id = ati.entity_id AND entity_table = 'agent'
        WHERE a.parent_agent='0' and site_id='0' AND a.accounts_processed='0' AND a.agency_name !=''  AND FIND_IN_SET(a.branch_id,'1,2,3,4')
        UNION ALL
        SELECT s.id AS LedgerID,s.en_supplier_code AS LedgerCode,CONCAT(s.company_name,' (',s.supplier_code,')') AS LedgerName,s.address AS Address,s.pincode AS Pincode,
        CONCAT_WS(s.first_name,s.last_name) AS ContactName,s.phone AS Phone,'' AS Fax,s.mobile AS Mobile,s.email AS Email,'supplier' AS `Type`,
        s.country AS Country,'online' AS LedgerType,'' AS BranchID,s.city AS City,'' AS Currency,'' AS Logo,s.time_zone_offset AS TimeOffset,'' AS ConsultantID,
        ati.tax_registration_no AS TaxRegNo,ati.registration_date AS TaxRegDate,ati.registration_country AS TaxRegCountry,'IP' AS TaxType,s.accounting_id as AccountingID,
        s.status AS Status, '' As CreditDays, '' AS BankName, '' AS BankCode, '' AS AccName, '' AS AccountNumber
        FROM suppliers AS s
        LEFT JOIN account_tax_information AS ati ON s.id = ati.entity_id AND entity_table = 'suppliers'
        WHERE s.accounts_processed='0' AND s.company_name !=''
        UNION ALL
        SELECT s.SupplierId AS LedgerID,s.SupplierId AS LedgerCode,CONCAT(SupplierName,' (',s.SupplierId,')') AS LedgerName,s.Address, '' AS Pincode,
        s.SupplierName AS ContactName,s.TelNo AS Phone,s.Fax,s.Mobile,s.Email,'supplier' AS `Type`,
        s.CountryID AS Country,'offline' AS LedgerType,'' AS BranchID,s.CityID AS City,'' AS Currency,'' AS Logo,s.time_zone_offset AS TimeOffset,'' AS ConsultantID,
        ati.tax_registration_no,ati.registration_date,ati.registration_country ,'IP' AS TaxType,s.accounting_id as AccountingID,s.Visible AS Status, '' As CreditDays,  s.bank_name AS BankName, s.swift_code AS BankCode, s.acc_name AS AccName, s.acc_no AS AccountNumber
        FROM supplier AS s
        LEFT JOIN account_tax_information AS ati ON s.SupplierId = ati.entity_id AND entity_table = 'supplier'
        WHERE s.accounts_processed='0' AND s.SupplierName !=''

/crons/v3_accounting_report.php?ez_queries=1

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.credit_days' in 'field list' from OtramsDB.php on 21-08-2020 06:59:28
 Query:SELECT a.id AS LedgerID,agent_reference(a.id,a.agent_type) AS LedgerCode,CONCAT(a.agency_name,' (',agent_reference(a.id,a.agent_type),')') AS LedgerName,
        a.address AS Address,a.pincode AS Pincode,
        CONCAT_WS(a.first_name,a.last_name) AS ContactName,a.phone AS Phone,a.fax AS Fax,a.mobile AS Mobile,a.email AS Email,'agent' AS `Type`,
        a.country AS Country,a.agent_type AS LedgerType,a.branch_id AS BranchID,a.city AS City,a.currency AS Currency,a.logo AS Logo,a.time_zone_offset AS TimeOffset,
        a.consultant_id AS ConsultantID,ati.tax_registration_no AS TaxRegNo,ati.registration_date AS TaxRegDate,ati.registration_country AS TaxRegCountry,'OP' AS TaxType,
        a.accounting_id as AccountingID,a.status AS Status, a.credit_days As CreditDays,
        '' AS BankName, '' AS BankCode, '' AS AccName, '' AS AccountNumber
        FROM agents AS a
        LEFT JOIN account_tax_information AS ati ON a.id = ati.entity_id AND entity_table = 'agent'
        WHERE a.parent_agent='0' and site_id='0' AND a.accounts_processed='0' AND a.agency_name !=''  AND FIND_IN_SET(a.branch_id,'1,2,3,4')
        UNION ALL
        SELECT s.id AS LedgerID,s.en_supplier_code AS LedgerCode,CONCAT(s.company_name,' (',s.supplier_code,')') AS LedgerName,s.address AS Address,s.pincode AS Pincode,
        CONCAT_WS(s.first_name,s.last_name) AS ContactName,s.phone AS Phone,'' AS Fax,s.mobile AS Mobile,s.email AS Email,'supplier' AS `Type`,
        s.country AS Country,'online' AS LedgerType,'' AS BranchID,s.city AS City,'' AS Currency,'' AS Logo,s.time_zone_offset AS TimeOffset,'' AS ConsultantID,
        ati.tax_registration_no AS TaxRegNo,ati.registration_date AS TaxRegDate,ati.registration_country AS TaxRegCountry,'IP' AS TaxType,s.accounting_id as AccountingID,
        s.status AS Status, '' As CreditDays, '' AS BankName, '' AS BankCode, '' AS AccName, '' AS AccountNumber
        FROM suppliers AS s
        LEFT JOIN account_tax_information AS ati ON s.id = ati.entity_id AND entity_table = 'suppliers'
        WHERE s.accounts_processed='0' AND s.company_name !=''
        UNION ALL
        SELECT s.SupplierId AS LedgerID,s.SupplierId AS LedgerCode,CONCAT(SupplierName,' (',s.SupplierId,')') AS LedgerName,s.Address, '' AS Pincode,
        s.SupplierName AS ContactName,s.TelNo AS Phone,s.Fax,s.Mobile,s.Email,'supplier' AS `Type`,
        s.CountryID AS Country,'offline' AS LedgerType,'' AS BranchID,s.CityID AS City,'' AS Currency,'' AS Logo,s.time_zone_offset AS TimeOffset,'' AS ConsultantID,
        ati.tax_registration_no,ati.registration_date,ati.registration_country ,'IP' AS TaxType,s.accounting_id as AccountingID,s.Visible AS Status, '' As CreditDays,  s.bank_name AS BankName, s.swift_code AS BankCode, s.acc_name AS AccName, s.acc_no AS AccountNumber
        FROM supplier AS s
        LEFT JOIN account_tax_information AS ati ON s.SupplierId = ati.entity_id AND entity_table = 'supplier'
        WHERE s.accounts_processed='0' AND s.SupplierName !=''

/crons/v3_accounting_report.php?ez_queries=1&error_reporting=yes

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.credit_days' in 'field list' from OtramsDB.php on 21-08-2020 07:04:02
 Query:SELECT a.id AS LedgerID,agent_reference(a.id,a.agent_type) AS LedgerCode,CONCAT(a.agency_name,' (',agent_reference(a.id,a.agent_type),')') AS LedgerName,
        a.address AS Address,a.pincode AS Pincode,
        CONCAT_WS(a.first_name,a.last_name) AS ContactName,a.phone AS Phone,a.fax AS Fax,a.mobile AS Mobile,a.email AS Email,'agent' AS `Type`,
        a.country AS Country,a.agent_type AS LedgerType,a.branch_id AS BranchID,a.city AS City,a.currency AS Currency,a.logo AS Logo,a.time_zone_offset AS TimeOffset,
        a.consultant_id AS ConsultantID,ati.tax_registration_no AS TaxRegNo,ati.registration_date AS TaxRegDate,ati.registration_country AS TaxRegCountry,'OP' AS TaxType,
        a.accounting_id as AccountingID,a.status AS Status, a.credit_days As CreditDays,
        '' AS BankName, '' AS BankCode, '' AS AccName, '' AS AccountNumber
        FROM agents AS a
        LEFT JOIN account_tax_information AS ati ON a.id = ati.entity_id AND entity_table = 'agent'
        WHERE a.parent_agent='0' and site_id='0' AND a.accounts_processed='0' AND a.agency_name !=''  AND FIND_IN_SET(a.branch_id,'1')
        UNION ALL
        SELECT s.id AS LedgerID,s.en_supplier_code AS LedgerCode,CONCAT(s.company_name,' (',s.supplier_code,')') AS LedgerName,s.address AS Address,s.pincode AS Pincode,
        CONCAT_WS(s.first_name,s.last_name) AS ContactName,s.phone AS Phone,'' AS Fax,s.mobile AS Mobile,s.email AS Email,'supplier' AS `Type`,
        s.country AS Country,'online' AS LedgerType,'' AS BranchID,s.city AS City,'' AS Currency,'' AS Logo,s.time_zone_offset AS TimeOffset,'' AS ConsultantID,
        ati.tax_registration_no AS TaxRegNo,ati.registration_date AS TaxRegDate,ati.registration_country AS TaxRegCountry,'IP' AS TaxType,s.accounting_id as AccountingID,
        s.status AS Status, '' As CreditDays, '' AS BankName, '' AS BankCode, '' AS AccName, '' AS AccountNumber
        FROM suppliers AS s
        LEFT JOIN account_tax_information AS ati ON s.id = ati.entity_id AND entity_table = 'suppliers'
        WHERE s.accounts_processed='0' AND s.company_name !=''
        UNION ALL
        SELECT s.SupplierId AS LedgerID,s.SupplierId AS LedgerCode,CONCAT(SupplierName,' (',s.SupplierId,')') AS LedgerName,s.Address, '' AS Pincode,
        s.SupplierName AS ContactName,s.TelNo AS Phone,s.Fax,s.Mobile,s.Email,'supplier' AS `Type`,
        s.CountryID AS Country,'offline' AS LedgerType,'' AS BranchID,s.CityID AS City,'' AS Currency,'' AS Logo,s.time_zone_offset AS TimeOffset,'' AS ConsultantID,
        ati.tax_registration_no,ati.registration_date,ati.registration_country ,'IP' AS TaxType,s.accounting_id as AccountingID,s.Visible AS Status, '' As CreditDays,  s.bank_name AS BankName, s.swift_code AS BankCode, s.acc_name AS AccName, s.acc_no AS AccountNumber
        FROM supplier AS s
        LEFT JOIN account_tax_information AS ati ON s.SupplierId = ati.entity_id AND entity_table = 'supplier'
        WHERE s.accounts_processed='0' AND s.SupplierName !=''

/crons/v3_accounting_report.php?ez_queries=1&error_reporting=yes

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'rb.accounts_processed' in 'where clause' from OtramsDB.php on 24-08-2020 02:20:22
 Query:SELECT DISTINCT(rb.id) FROM   bookings b
       INNER JOIN receipts_bookings rb
               ON b.id = rb.booking_id
     WHERE  b.is_payment_gateway = '1' AND rb.accounts_processed='0';

/push_account_data_manually.php?reservation_id=QTECH2020081754&debug=1

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'rb.accounts_processed' in 'where clause' from OtramsDB.php on 24-08-2020 02:20:22
 Query:SELECT DISTINCT(rb.id) FROM receipts_bookings rb INNER JOIN receipts r
                ON rb.receipt_id=r.id where r.booking_ref!='' and r.acc_export='1' and rb.accounts_processed='0'  AND r.received_by != 'Accounts Webservice'

/push_account_data_manually.php?reservation_id=QTECH2020081754&debug=1

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'rb.accounts_processed' in 'where clause' from OtramsDB.php on 24-08-2020 02:20:53
 Query:SELECT DISTINCT(rb.id) FROM   bookings b
       INNER JOIN receipts_bookings rb
               ON b.id = rb.booking_id
     WHERE  b.is_payment_gateway = '1' AND rb.accounts_processed='0';

/push_account_data_manually.php?reservation_id=QTECH2020081754&debug=1

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'rb.accounts_processed' in 'where clause' from OtramsDB.php on 24-08-2020 02:20:54
 Query:SELECT DISTINCT(rb.id) FROM receipts_bookings rb INNER JOIN receipts r
                ON rb.receipt_id=r.id where r.booking_ref!='' and r.acc_export='1' and rb.accounts_processed='0'  AND r.received_by != 'Accounts Webservice'

/push_account_data_manually.php?reservation_id=QTECH2020081754&debug=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'c.status='A'  AND h.id IN (97,53699,53703,53701,53705,53706,53708,53709,53710,53' at line 4 from OtramsDB.php on 31-10-2020 08:34:25
 Query:SELECT COUNT(DISTINCT h.id) as hotelcount,c.name as city
            FROM hotels h
            LEFT JOIN cities c ON c.city_code=h.city
            c.status='A'  AND h.id IN (97,53699,53703,53701,53705,53706,53708,53709,53710,53711,53712,53713,53714,53715,51808,53716,53717,53718,53719,53721,53722,53723,53724,53725,53726,53727,53728,53729,53730,53731,53732,53733,53737,53739,53740,53741,53745,53746,53748,53749,53750,53751,53757,53759,53762,53763,53704,53764,53767,53768,53769,51817,53770,53772,53774,53771,53773,53775,53776,53742,53777)
            GROUP BY h.city

/tms/search_local_hotel.php?action=search

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND h.id IN (97,53699,53703,53701,53705,53706,53708,53709,53710,53711,53712,5371' at line 4 from OtramsDB.php on 31-10-2020 08:43:32
 Query:SELECT COUNT(DISTINCT h.id) as hotelcount,c.name as countryname
            FROM hotels h
            LEFT JOIN countries c ON c.code=h.country
            WHERE c.status='A' AND  AND h.id IN (97,53699,53703,53701,53705,53706,53708,53709,53710,53711,53712,53713,53714,53715,51808,53716,53717,53718,53719,53721,53722,53723,53724,53725,53726,53727,53728,53729,53730,53731,53732,53733,53737,53739,53740,53741,53745,53746,53748,53749,53750,53751,53757,53759,53762,53763,53704,53764,53767,53768,53769,51817,53770,53772,53774,53771,53773,53775,53776,53742,53777)
            GROUP BY h.country
            ORDER BY c.name ASC

/tms/search_local_hotel.php?action=search

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND h.id IN (97,53699,53703,53701,53705,53706,53708,53709,53710,53711,53712,5371' at line 4 from OtramsDB.php on 31-10-2020 08:43:33
 Query:SELECT COUNT(DISTINCT h.id) as hotelcount,c.name as countryname
            FROM hotels h
            LEFT JOIN countries c ON c.code=h.country
            WHERE rr.availability > 0 AND  AND h.id IN (97,53699,53703,53701,53705,53706,53708,53709,53710,53711,53712,53713,53714,53715,51808,53716,53717,53718,53719,53721,53722,53723,53724,53725,53726,53727,53728,53729,53730,53731,53732,53733,53737,53739,53740,53741,53745,53746,53748,53749,53750,53751,53757,53759,53762,53763,53704,53764,53767,53768,53769,51817,53770,53772,53774,53771,53773,53775,53776,53742,53777)
            GROUP BY h.country
            ORDER BY c.name ASC

/tms/search_local_hotel.php?action=search

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND h.id IN (97,53699,53703,53701,53705,53706,53708,53709,53710,53711,53712,5371' at line 4 from OtramsDB.php on 31-10-2020 08:43:33
 Query:SELECT COUNT(DISTINCT h.id) as hotelcount,c.name as city
            FROM hotels h
            LEFT JOIN cities c ON c.city_code=h.city
            WHERE rr.availability > 0 AND  AND h.id IN (97,53699,53703,53701,53705,53706,53708,53709,53710,53711,53712,53713,53714,53715,51808,53716,53717,53718,53719,53721,53722,53723,53724,53725,53726,53727,53728,53729,53730,53731,53732,53733,53737,53739,53740,53741,53745,53746,53748,53749,53750,53751,53757,53759,53762,53763,53704,53764,53767,53768,53769,51817,53770,53772,53774,53771,53773,53775,53776,53742,53777)
            GROUP BY h.city
            ORDER BY c.name ASC

/tms/search_local_hotel.php?action=search

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND h.id IN (97,53699,53703,53701,53705,53706,53708,53709,53710,53711,53712,5371' at line 4 from OtramsDB.php on 31-10-2020 08:43:33
 Query:SELECT COUNT(DISTINCT h.id) as hotelcount,c.name as countryname
            FROM hotels h
            LEFT JOIN countries c ON c.code=h.country
            WHERE c.status='A' AND (rr.availability=0 OR rr.availability IS NULL) AND  AND h.id IN (97,53699,53703,53701,53705,53706,53708,53709,53710,53711,53712,53713,53714,53715,51808,53716,53717,53718,53719,53721,53722,53723,53724,53725,53726,53727,53728,53729,53730,53731,53732,53733,53737,53739,53740,53741,53745,53746,53748,53749,53750,53751,53757,53759,53762,53763,53704,53764,53767,53768,53769,51817,53770,53772,53774,53771,53773,53775,53776,53742,53777)
            GROUP BY h.country
            ORDER BY c.name ASC

/tms/search_local_hotel.php?action=search

SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'h' from OtramsDB.php on 31-10-2020 08:43:34
 Query:SELECT COUNT(DISTINCT rr.hotel_id) as hotelcount,c.name as city
            FROM hotels h
            LEFT JOIN hotels h ON h.id=rr.hotel_id
            LEFT JOIN cities c ON c.city_code=h.city
            WHERE c.status='A' AND (rr.availability=0 OR rr.availability IS NULL) AND  AND h.id IN (97,53699,53703,53701,53705,53706,53708,53709,53710,53711,53712,53713,53714,53715,51808,53716,53717,53718,53719,53721,53722,53723,53724,53725,53726,53727,53728,53729,53730,53731,53732,53733,53737,53739,53740,53741,53745,53746,53748,53749,53750,53751,53757,53759,53762,53763,53704,53764,53767,53768,53769,51817,53770,53772,53774,53771,53773,53775,53776,53742,53777)
            GROUP BY h.city
            ORDER BY c.name ASC

/tms/search_local_hotel.php?action=search

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'rr.hotel_id' in 'group statement' from OtramsDB.php on 03-11-2020 10:29:32
 Query:SELECT SQL_CALC_FOUND_ROWS h.id,h.rating,h.name,h.country,h.city,h.status,h.rating, s.SupplierName , s.supplierid , hsm.supplier_type, s.fit_package_supplier
                FROM hotels as h
                
                JOIN hotel_supplier_mapping as hsm ON h.id=hsm.hotel_id
                 JOIN supplier as s ON hsm.SupplierId=s.SupplierId
                 WHERE h.status!='D' AND s.Visible!='N' AND s.status!='D' AND h.city IN ('71100') AND h.country IN ('132') AND h.id NOT IN (51817,53699,53701,53770,53733,53777)  GROUP BY rr.hotel_id,rr.supplier_id 
                ORDER BY h.name asc LIMIT 0,25

/tms/search_local_hotel.php?action=search

SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('otrams_thefab'@'%') does not exist from OtramsDB.php on 04-11-2020 11:57:28
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND q.unique_id IN ('QTECHCD002510','RDTCD0021189','RDTCD0021188','QTECHCD00093','QTECHCA002227','QTECHCA002226','RDTCD0021187','QTECHCA002219','RDTCD0021186','QTECHCA002225','QTECHCA002223','QTECHCA002224','RDTCD0021185','QTECHCA002222','QTECHCA002221','QTECHCA002218','QTECHCA002220','QTECHCD00259','RDTCA0021Q169','QTECHCD00258','QTECHCD00257','QTECHCD00256','QTECHCD00255','QTECHCD00253','QTECHCD00252')  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('otrams_thefab'@'%') does not exist from OtramsDB.php on 04-11-2020 11:57:44
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND q.unique_id IN ('QTECHCD002510','RDTCD0021189','RDTCD0021188','QTECHCD00093','QTECHCA002227','QTECHCA002226','RDTCD0021187','QTECHCA002219','RDTCD0021186','QTECHCA002225','QTECHCA002223','QTECHCA002224','RDTCD0021185','QTECHCA002222','QTECHCA002221','QTECHCA002218','QTECHCA002220','QTECHCD00259','RDTCA0021Q169','QTECHCD00258','QTECHCD00257','QTECHCD00256','QTECHCD00255','QTECHCD00253','QTECHCD00252')  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('otrams_thefab'@'%') does not exist from OtramsDB.php on 04-11-2020 11:59:06
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND q.unique_id IN ('QTECHCD002510','RDTCD0021189','RDTCD0021188','QTECHCD00093','QTECHCA002227','QTECHCA002226','RDTCD0021187','QTECHCA002219','RDTCD0021186','QTECHCA002225','QTECHCA002223','QTECHCA002224','RDTCD0021185','QTECHCA002222','QTECHCA002221','QTECHCA002218','QTECHCA002220','QTECHCD00259','RDTCA0021Q169','QTECHCD00258','QTECHCD00257','QTECHCD00256','QTECHCD00255','QTECHCD00253','QTECHCD00252')  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('otrams_thefab'@'%') does not exist from OtramsDB.php on 04-11-2020 12:29:00
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND q.unique_id IN ('QTECHCD002510','RDTCD0021189','RDTCD0021188','QTECHCD00093','QTECHCA002227','QTECHCA002226','RDTCD0021187','QTECHCA002219','RDTCD0021186','QTECHCA002225','QTECHCA002223','QTECHCA002224','RDTCD0021185','QTECHCA002222','QTECHCA002221','QTECHCA002218','QTECHCA002220','QTECHCD00259','RDTCA0021Q169','QTECHCD00258','QTECHCD00257','QTECHCD00256','QTECHCD00255','QTECHCD00253','QTECHCD00252')  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('otrams_thefab'@'%') does not exist from OtramsDB.php on 04-11-2020 12:29:05
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND q.unique_id IN ('QTECHCD002510','RDTCD0021189','RDTCD0021188','QTECHCD00093','QTECHCA002227','QTECHCA002226','RDTCD0021187','QTECHCA002219','RDTCD0021186','QTECHCA002225','QTECHCA002223','QTECHCA002224','RDTCD0021185','QTECHCA002222','QTECHCA002221','QTECHCA002218','QTECHCA002220','QTECHCD00259','RDTCA0021Q169','QTECHCD00258','QTECHCD00257','QTECHCD00256','QTECHCD00255','QTECHCD00253','QTECHCD00252')  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('otrams_thefab'@'%') does not exist from OtramsDB.php on 04-11-2020 12:29:40
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND q.unique_id IN ('QTECHCD002510','RDTCD0021189','RDTCD0021188','QTECHCD00093','QTECHCA002227','QTECHCA002226','RDTCD0021187','QTECHCA002219','RDTCD0021186','QTECHCA002225','QTECHCA002223','QTECHCA002224','RDTCD0021185','QTECHCA002222','QTECHCA002221','QTECHCA002218','QTECHCA002220','QTECHCD00259','RDTCA0021Q169','QTECHCD00258','QTECHCD00257','QTECHCD00256','QTECHCD00255','QTECHCD00253','QTECHCD00252')  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('otrams_thefab'@'%') does not exist from OtramsDB.php on 04-11-2020 12:30:34
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND q.unique_id IN ('QTECHCD002510','RDTCD0021189','RDTCD0021188','QTECHCD00093','QTECHCA002227','QTECHCA002226','RDTCD0021187','QTECHCA002219','RDTCD0021186','QTECHCA002225','QTECHCA002223','QTECHCA002224','RDTCD0021185','QTECHCA002222','QTECHCA002221','QTECHCA002218','QTECHCA002220','QTECHCD00259','RDTCA0021Q169','QTECHCD00258','QTECHCD00257','QTECHCD00256','QTECHCD00255','QTECHCD00253','QTECHCD00252')  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList&ez_queries=1

SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('otrams_thefab'@'%') does not exist from OtramsDB.php on 04-11-2020 12:31:39
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND q.unique_id IN ('QTECHCD002510','RDTCD0021189','RDTCD0021188','QTECHCD00093','QTECHCA002227','QTECHCA002226','RDTCD0021187','QTECHCA002219','RDTCD0021186','QTECHCA002225','QTECHCA002223','QTECHCA002224','RDTCD0021185','QTECHCA002222','QTECHCA002221','QTECHCA002218','QTECHCA002220','QTECHCD00259','RDTCA0021Q169','QTECHCD00258','QTECHCD00257','QTECHCD00256','QTECHCD00255','QTECHCD00253','QTECHCD00252')  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList&ez_queries=1

SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('otrams_thefab'@'%') does not exist from OtramsDB.php on 04-11-2020 12:35:01
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND q.unique_id IN ('QTECHCD002510','RDTCD0021189','RDTCD0021188','QTECHCD00093','QTECHCA002227','QTECHCA002226','RDTCD0021187','QTECHCA002219','RDTCD0021186','QTECHCA002225','QTECHCA002223','QTECHCA002224','RDTCD0021185','QTECHCA002222','QTECHCA002221','QTECHCA002218','QTECHCA002220','QTECHCD00259','RDTCA0021Q169','QTECHCD00258','QTECHCD00257','QTECHCD00256','QTECHCD00255','QTECHCD00253','QTECHCD00252')  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('otrams_thefab'@'%') does not exist from OtramsDB.php on 04-11-2020 12:37:06
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND q.unique_id IN ('QTECHCD002510','RDTCD0021189','RDTCD0021188','QTECHCD00093','QTECHCA002227','QTECHCA002226','RDTCD0021187','QTECHCA002219','RDTCD0021186','QTECHCA002225','QTECHCA002223','QTECHCA002224','RDTCD0021185','QTECHCA002222','QTECHCA002221','QTECHCA002218','QTECHCA002220','QTECHCD00259','RDTCA0021Q169','QTECHCD00258','QTECHCD00257','QTECHCD00256','QTECHCD00255','QTECHCD00253','QTECHCD00252')  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('otrams_thefab'@'%') does not exist from OtramsDB.php on 04-11-2020 12:37:10
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND q.unique_id IN ('QTECHCD002510','RDTCD0021189','RDTCD0021188','QTECHCD00093','QTECHCA002227','QTECHCA002226','RDTCD0021187','QTECHCA002219','RDTCD0021186','QTECHCA002225','QTECHCA002223','QTECHCA002224','RDTCD0021185','QTECHCA002222','QTECHCA002221','QTECHCA002218','QTECHCA002220','QTECHCD00259','RDTCA0021Q169','QTECHCD00258','QTECHCD00257','QTECHCD00256','QTECHCD00255','QTECHCD00253','QTECHCD00252')  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('otrams_thefab'@'%') does not exist from OtramsDB.php on 05-11-2020 04:45:45
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND q.unique_id IN ('QTECHCD002510','RDTCD0021189','RDTCD0021188','QTECHCD00093','QTECHCA002227','QTECHCA002226','RDTCD0021187','QTECHCA002219','RDTCD0021186','QTECHCA002225','QTECHCA002223','QTECHCA002224','RDTCD0021185','QTECHCA002222','QTECHCA002221','QTECHCA002218','QTECHCA002220','QTECHCD00259','RDTCA0021Q169','QTECHCD00258','QTECHCD00257','QTECHCD00256','QTECHCD00255','QTECHCD00253','QTECHCD00252')  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('otrams_thefab'@'%') does not exist from OtramsDB.php on 05-11-2020 04:46:19
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND q.unique_id IN ('QTECHCD002510','RDTCD0021189','RDTCD0021188','QTECHCD00093','QTECHCA002227','QTECHCA002226','RDTCD0021187','QTECHCA002219','RDTCD0021186','QTECHCA002225','QTECHCA002223','QTECHCA002224','RDTCD0021185','QTECHCA002222','QTECHCA002221','QTECHCA002218','QTECHCA002220','QTECHCD00259','RDTCA0021Q169','QTECHCD00258','QTECHCD00257','QTECHCD00256','QTECHCD00255','QTECHCD00253','QTECHCD00252')  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('otrams_thefab'@'%') does not exist from OtramsDB.php on 05-11-2020 04:46:31
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND q.unique_id IN ('QTECHCD002510','RDTCD0021189','RDTCD0021188','QTECHCD00093','QTECHCA002227','QTECHCA002226','RDTCD0021187','QTECHCA002219','RDTCD0021186','QTECHCA002225','QTECHCA002223','QTECHCA002224','RDTCD0021185','QTECHCA002222','QTECHCA002221','QTECHCA002218','QTECHCA002220','QTECHCD00259','RDTCA0021Q169','QTECHCD00258','QTECHCD00257','QTECHCD00256','QTECHCD00255','QTECHCD00253','QTECHCD00252')  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'otrams_thefabulousgetaway_alpha.rategain_ip_list' doesn't exist from OtramsDB.php on 14-12-2020 08:42:41
 Query:SELECT ip FROM rategain_ip_list WHERE status='A'

/api/rate_gain_response.php

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'b.current_status' in 'where clause' from OtramsDB.php on 30-04-2021 05:26:14
 Query:SELECT id as booking_id, booking_code, reservation_id, source_type FROM bookings WHERE b.current_status NOT IN ('inprocess_cancel', 'cancelled', 'failed')

/tms/booking_detail.php?ez_queries=1&booking_id=3113&reservation_id=QTECH2021041967&service=hotel&onload=1

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'b.current_status' in 'where clause' from OtramsDB.php on 30-04-2021 05:27:02
 Query:SELECT id as booking_id, booking_code, reservation_id, source_type FROM bookings WHERE b.current_status NOT IN ('inprocess_cancel', 'cancelled', 'failed')

/tms/booking_detail.php?booking_id=3113&reservation_id=QTECH2021041967&service=hotel&onload=1

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'b.current_status' in 'where clause' from OtramsDB.php on 30-04-2021 05:27:20
 Query:SELECT id as booking_id, booking_code, reservation_id, source_type FROM bookings WHERE b.current_status NOT IN ('inprocess_cancel', 'cancelled', 'failed')

/tms/booking_detail.php?ez_queries=1&booking_id=3113&reservation_id=QTECH2021041967&service=hotel&onload=1

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'attributes' in 'order clause' from OtramsDB.php on 04-05-2021 05:48:46
 Query:SELECT SQL_CALC_FOUND_ROWS id, reservation_id , service_type , agent_id, check_out_date, leader_title , leader_first_name  , leader_last_name , email_id , city_id , city_id 
    FROM bookings WHERE service_type!='packages'  AND service_type IN ('transfer') Order By attributes asc Limit 0,10

/tms/service_report.php?sEcho=6&iColumns=10&sColumns=%2C%2C%2C%2C%2C%2C%2C%2C%2C&iDisplayStart=0&iDisplayLength=10&mDataProp_0=company&sSearch_0=&bRegex_0=false&bSearchable_0=true&bSortable_0=true&mDataProp_1=reservation_id&sSearch_1=&bRegex_1=false&bSearchable_1=true&bSortable_1=true&mDataProp_2=passenger&sSearch_2=&bRegex_2=false&bSearchable_2=true&bSortable_2=true&mDataProp_3=email_id&sSearch_3=&bRegex_3=false&bSearchable_3=true&bSortable_3=true&mDataProp_4=service_type&sSearch_4=&bRegex_4=false&bSearchable_4=true&bSortable_4=true&mDataProp_5=date&sSearch_5=&bRegex_5=false&bSearchable_5=true&bSortable_5=true&mDataProp_6=agency_name&sSearch_6=&bRegex_6=false&bSearchable_6=true&bSortable_6=true&mDataProp_7=service_type&sSearch_7=&bRegex_7=false&bSearchable_7=true&bSortable_7=true&mDataProp_8=tags&sSearch_8=&bRegex_8=false&bSearchable_8=true&bSortable_8=true&mDataProp_9=attributes&sSearch_9=&bRegex_9=false&bSearchable_9=true&bSortable_9=true&sSearch=&bRegex=false&iSortCol_0=9&sSortDir_0=asc&iSortingCols=1&action=search_bookings&service_type%5B%5D=transfer&_=1620103518325

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'unique_id' in where clause is ambiguous from OtramsDB.php on 18-08-2021 11:13:34
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,qt.tags AS tags ,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT Join quotation_tags qt on q.unique_id = qt.unique_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND (unique_id!='' AND unique_id IS NOT NULL) AND (q.enquiry_id IN ('225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','276','277','278','279','280','281','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412') OR backoffice_user='tfg' OR q.unique_id IN ('RDTCA0021Q91','RDTCA0021Q122'))  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'unique_id' in where clause is ambiguous from OtramsDB.php on 18-08-2021 11:14:45
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,qt.tags AS tags ,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT Join quotation_tags qt on q.unique_id = qt.unique_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND (unique_id!='' AND unique_id IS NOT NULL) AND (q.enquiry_id IN ('225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','276','277','278','279','280','281','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412') OR backoffice_user='tfg' OR q.unique_id IN ('RDTCA0021Q91','RDTCA0021Q122'))  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'unique_id' in where clause is ambiguous from OtramsDB.php on 18-08-2021 11:15:29
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,qt.tags AS tags ,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT Join quotation_tags qt on q.unique_id = qt.unique_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND (unique_id!='' AND unique_id IS NOT NULL) AND (q.enquiry_id IN ('225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','276','277','278','279','280','281','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412') OR backoffice_user='tfg' OR q.unique_id IN ('RDTCA0021Q91','RDTCA0021Q122'))  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'unique_id' in where clause is ambiguous from OtramsDB.php on 18-08-2021 11:15:44
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,qt.tags AS tags ,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT Join quotation_tags qt on q.unique_id = qt.unique_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND (unique_id!='' AND unique_id IS NOT NULL) AND (q.enquiry_id IN ('225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','276','277','278','279','280','281','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412') OR backoffice_user='tfg' OR q.unique_id IN ('RDTCA0021Q91','RDTCA0021Q122'))  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'unique_id' in where clause is ambiguous from OtramsDB.php on 18-08-2021 11:16:52
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,qt.tags AS tags ,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT Join quotation_tags qt on q.unique_id = qt.unique_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND (unique_id!='' AND unique_id IS NOT NULL) AND (q.enquiry_id IN ('225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','276','277','278','279','280','281','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412') OR backoffice_user='tfg' OR q.unique_id IN ('RDTCA0021Q91','RDTCA0021Q122'))  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'unique_id' in where clause is ambiguous from OtramsDB.php on 18-08-2021 11:17:17
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,qt.tags AS tags ,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT Join quotation_tags qt on q.unique_id = qt.unique_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND (unique_id!='' AND unique_id IS NOT NULL) AND (q.enquiry_id IN ('225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','276','277','278','279','280','281','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412') OR backoffice_user='tfg' OR q.unique_id IN ('RDTCA0021Q91','RDTCA0021Q122'))  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'unique_id' in where clause is ambiguous from OtramsDB.php on 18-08-2021 11:18:25
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,qt.tags AS tags ,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT Join quotation_tags qt on q.unique_id = qt.unique_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND (unique_id!='' AND unique_id IS NOT NULL) AND (q.enquiry_id IN ('225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','276','277','278','279','280','281','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412') OR backoffice_user='tfg' OR q.unique_id IN ('RDTCA0021Q91','RDTCA0021Q122'))  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'unique_id' in where clause is ambiguous from OtramsDB.php on 18-08-2021 11:47:58
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,qt.tags AS tags ,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT Join quotation_tags qt on q.unique_id = qt.unique_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND (unique_id!='' AND unique_id IS NOT NULL) AND (q.enquiry_id IN ('225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','276','277','278','279','280','281','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412') OR backoffice_user='tfg' OR q.unique_id IN ('RDTCA0021Q91','RDTCA0021Q122'))  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'unique_id' in where clause is ambiguous from OtramsDB.php on 23-08-2021 04:59:05
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,qt.tags AS tags ,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT Join quotation_tags qt on q.unique_id = qt.unique_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND (unique_id!='' AND unique_id IS NOT NULL) AND (q.enquiry_id IN ('225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','276','277','278','279','280','281','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412') OR backoffice_user='tfg' OR q.unique_id IN ('RDTCA0021Q91','RDTCA0021Q122'))  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'unique_id' in where clause is ambiguous from OtramsDB.php on 23-08-2021 05:02:46
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,qt.tags AS tags ,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT Join quotation_tags qt on q.unique_id = qt.unique_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND (unique_id!='' AND unique_id IS NOT NULL) AND (q.enquiry_id IN ('225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','276','277','278','279','280','281','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412') OR backoffice_user='tfg' OR q.unique_id IN ('RDTCA0021Q91','RDTCA0021Q122'))  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'unique_id' in where clause is ambiguous from OtramsDB.php on 23-08-2021 05:02:54
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,qt.tags AS tags ,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT Join quotation_tags qt on q.unique_id = qt.unique_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND (unique_id!='' AND unique_id IS NOT NULL) AND (q.enquiry_id IN ('225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','276','277','278','279','280','281','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412') OR backoffice_user='tfg' OR q.unique_id IN ('RDTCA0021Q91','RDTCA0021Q122'))  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'unique_id' in where clause is ambiguous from OtramsDB.php on 23-08-2021 05:03:03
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,qt.tags AS tags ,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT Join quotation_tags qt on q.unique_id = qt.unique_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND (unique_id!='' AND unique_id IS NOT NULL) AND (q.enquiry_id IN ('225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','276','277','278','279','280','281','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412') OR backoffice_user='tfg' OR q.unique_id IN ('RDTCA0021Q91','RDTCA0021Q122'))  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'unique_id' in where clause is ambiguous from OtramsDB.php on 23-08-2021 05:10:19
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,qt.tags AS tags ,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT Join quotation_tags qt on q.unique_id = qt.unique_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND (unique_id!='' AND unique_id IS NOT NULL) AND (q.enquiry_id IN ('225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','276','277','278','279','280','281','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412') OR backoffice_user='tfg' OR q.unique_id IN ('RDTCA0021Q91','RDTCA0021Q122'))  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'unique_id' in where clause is ambiguous from OtramsDB.php on 23-08-2021 05:19:27
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,qt.tags AS tags ,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT Join quotation_tags qt on q.unique_id = qt.unique_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND (unique_id!='' AND unique_id IS NOT NULL) AND (q.enquiry_id IN ('225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','276','277','278','279','280','281','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412') OR backoffice_user='tfg' OR q.unique_id IN ('RDTCA0021Q91','RDTCA0021Q122'))  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'q.tags' in 'field list' from OtramsDB.php on 23-08-2021 05:32:41
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,q.tags,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT Join quotation_tags qt on q.unique_id = qt.unique_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND (unique_id!='' AND unique_id IS NOT NULL) AND (q.enquiry_id IN ('225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','276','277','278','279','280','281','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412') OR backoffice_user='tfg' OR q.unique_id IN ('RDTCA0021Q91','RDTCA0021Q122'))  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'unique_id' in where clause is ambiguous from OtramsDB.php on 23-08-2021 05:35:02
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,qt.tags,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT Join quotation_tags qt on q.unique_id = qt.unique_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND (unique_id!='' AND unique_id IS NOT NULL) AND (q.enquiry_id IN ('225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','276','277','278','279','280','281','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412') OR backoffice_user='tfg' OR q.unique_id IN ('RDTCA0021Q91','RDTCA0021Q122'))  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'unique_id' in where clause is ambiguous from OtramsDB.php on 23-08-2021 05:36:25
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,qt.tags,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT Join quotation_tags qt on q.unique_id = qt.unique_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND (unique_id!='' AND unique_id IS NOT NULL) AND (q.enquiry_id IN ('225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','276','277','278','279','280','281','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412') OR backoffice_user='tfg' OR q.unique_id IN ('RDTCA0021Q91','RDTCA0021Q122'))  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'unique_id' in where clause is ambiguous from OtramsDB.php on 23-08-2021 05:39:07
 Query:SELECT q.q_id,q.q_name,a.agency_name AS agent_name,CONCAT(CONVERT(a.agency_name USING utf8),' [',CONVERT(agent_reference(a.id,a.agent_type) USING utf8),'-',CONVERT(a.username USING utf8),']',' [',CONVERT(a.first_name USING utf8),'-',CONVERT(a.last_name USING utf8),']') AS agency_name,q.service,q.quotation_status,q.quotation_type,GROUP_CONCAT(DISTINCT q.rate_type) as rate_type,q.unique_id,backoffice_user,q.agent_id,MIN(DATE(q.service_date)) as service_date, MAX(DATE(q.service_checkout_date)) as service_checkout_date,MIN(DATE(q.create_date)) as create_date,MAX(DATE(q.modified_date)) as last_modified_date,UPPER(GROUP_CONCAT(q.service)) as service,cu.currency_code,e.residing_country,q.enquiry_id,qt.tags,GREATEST(MAX(q.modified_date), MAX(q.create_date)) AS latest_processed_date
            FROM agent_quotation q
            LEFT JOIN agents a ON a.id = q.agent_id
            LEFT JOIN enquiry e ON e.id = q.enquiry_id
            LEFT Join quotation_tags qt on q.unique_id = qt.unique_id
            LEFT JOIN currencies cu ON cu.currency_code = q.currency  WHERE q.status = 'A' AND (unique_id!='' AND unique_id IS NOT NULL) AND (q.enquiry_id IN ('225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','276','277','278','279','280','281','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412') OR backoffice_user='tfg' OR q.unique_id IN ('RDTCA0021Q91','RDTCA0021Q122'))  GROUP BY q.agent_id, q.unique_id ORDER BY latest_processed_date DESC

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCD0021191';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCD0021190';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD00093';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD002510';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCD0021189';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCD0021188';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA002227';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA002226';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCD0021187';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA002219';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCD0021186';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA002225';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA002223';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA002224';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCD0021185';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA002222';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA002221';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA002218';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA002220';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD00259';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q169';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD00258';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD00257';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD00256';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD00255';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD00253';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD00252';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD00251';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA002217';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCD0021183';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA002212';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA002216';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0021Q4';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCD0021184';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA002211';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA002215';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA002213';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA002214';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q93_1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021177';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021182';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021181';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021180';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021179';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021178';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0003Q8';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q176';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q172';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q174';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA0022Q10';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q175';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q173';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA0022Q9';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA0022Q2';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q171';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q170';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q168';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q167';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q166';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q164';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q165';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q163';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q162';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q161';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q160';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q159';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q158';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q157';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q153';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q156';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q155';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q154';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q150';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q152';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA0022Q8';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA0022Q7';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA0022Q6';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA0022Q5';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA0022Q4';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA0022Q3';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q149';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0021Q2';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q151';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q147';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q146';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q144';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q148';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q143';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q138';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q145';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q142';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q140';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q139';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q141';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q133';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q137';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q135';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q136';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q132';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD0020Q14';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA0022Q1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q134';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q131';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q130';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q129';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD0009Q2';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='UAECD0014Q1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q112_1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q128';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD0008Q3';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q125';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD0008Q2';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q127';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q126';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q118';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q122';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q124';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q121';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q123';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q120';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q119';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA0001Q1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q117';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q116';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q114_1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q114';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q109';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q110';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q110_1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q112';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q108';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q106';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q107';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q105';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q93';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q101';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q104';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q77';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q102';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q103';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q99';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q98';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q54';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD0020Q13';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q96';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q97';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q95';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q94';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q54_1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q92';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q90';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q91';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q86';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q89';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD0020Q1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q88';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q47';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q87';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q85';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q84';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD0020Q12';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD0020Q11';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD0020Q10';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q79';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD0020Q9';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q82';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD0020Q8';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q81';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q80';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q76';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q78';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q73';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q74_1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q74';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q72';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q70';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q69';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q64';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q68';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q65';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q67';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q66';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q56_1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q63';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q62';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q56';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q59';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q61';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q57';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q58';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q55';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q53';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q51';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q50';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q52';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q47_1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q48';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q46';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA0020Q6';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCA0020Q7';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q45';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD0018Q8';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD0020Q5';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD0012Q1_2';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD0012Q1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q18';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q41';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q44';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q42';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q43';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD0020Q4';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q40';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q39';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q36';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD0020Q3';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD0012Q1_1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q38';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q37';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q34_1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q34';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q32';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q31';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q30';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q29';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q27';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q28';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q22';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q26';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q24';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q23';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD0018Q7';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='QTECHCD0020Q1_1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='COLBCD0003Q12';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q17';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCA0021Q16';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='RDTCD0021Q15';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0021Q14';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0021Q10';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0021Q12_1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0021Q12';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0021Q11';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0003Q4';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0021Q8_1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0003Q7';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0003Q11';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0021Q8';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0003Q9';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0003Q10';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0003Q6';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0003Q5';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0003Q3';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0018Q2_1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0003Q2';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0021Q7';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0021Q5_1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0021Q5';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0021Q2_1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0021Q1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0018Q6';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0018Q2_2';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0018Q2';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0003Q1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0019Q11';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0019Q10';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0019Q9';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0019Q8';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0019Q7';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0019Q6';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0019Q5';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0019Q4';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0019Q3';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0019Q2';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0019Q1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0018Q5';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'unique_id' in 'where clause' from OtramsDB.php on 23-08-2021 05:45:09
 Query:SELECT tags FROM tags_booking WHERE unique_id='CD0018Q1';

/tms/controller_quotation.php?action=showQuotationList

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'b.branch_note' in 'field list' from OtramsDB.php on 11-11-2021 04:40:37
 Query:SELECT pb.*,b.booking_code,b.reservation_id,b.service_type,b.branch_note,b.source_type,b.agent_id,b.service_type_detail,b.supplier_rate,b.agent_rate,b.booking_branch_id,b.site_id,b.sub_user_id,b.current_status FROM psa_branches pb LEFT JOIN bookings b ON b.booking_branch_id=pb.id WHERE b.id='3142';

/tms/print_voucher.php?reservationid=RDT2021081973&id=3142

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'b.branch_note' in 'field list' from OtramsDB.php on 11-11-2021 04:56:53
 Query:SELECT pb.*,b.booking_code,b.reservation_id,b.service_type,b.branch_note,b.source_type,b.agent_id,b.service_type_detail,b.supplier_rate,b.agent_rate,b.booking_branch_id,b.site_id,b.sub_user_id,b.current_status FROM psa_branches pb LEFT JOIN bookings b ON b.booking_branch_id=pb.id WHERE b.id='3142';

/tms/print_voucher.php?reservationid=RDT2021081973&id=3142

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'b.branch_note' in 'field list' from OtramsDB.php on 11-11-2021 04:57:04
 Query:SELECT pb.*,b.booking_code,b.reservation_id,b.service_type,b.branch_note,b.source_type,b.agent_id,b.service_type_detail,b.supplier_rate,b.agent_rate,b.booking_branch_id,b.site_id,b.sub_user_id,b.current_status FROM psa_branches pb LEFT JOIN bookings b ON b.booking_branch_id=pb.id WHERE b.id='3142';

/tms/print_voucher.php?reservationid=RDT2021081973&id=3142

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'b.branch_note' in 'field list' from OtramsDB.php on 11-11-2021 05:01:25
 Query:SELECT pb.*,b.booking_code,b.reservation_id,b.service_type,b.branch_note,b.source_type,b.agent_id,b.service_type_detail,b.supplier_rate,b.agent_rate,b.booking_branch_id,b.site_id,b.sub_user_id,b.current_status FROM psa_branches pb LEFT JOIN bookings b ON b.booking_branch_id=pb.id WHERE b.id='3142';

/tms/print_voucher.php?reservationid=RDT2021081973&id=3142

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'b.branch_note' in 'field list' from OtramsDB.php on 11-11-2021 05:03:24
 Query:SELECT pb.*,b.booking_code,b.reservation_id,b.service_type,b.branch_note,b.source_type,b.agent_id,b.service_type_detail,b.supplier_rate,b.agent_rate,b.booking_branch_id,b.site_id,b.sub_user_id,b.current_status FROM psa_branches pb LEFT JOIN bookings b ON b.booking_branch_id=pb.id WHERE b.id='3142';

/tms/print_voucher.php?reservationid=RDT2021081973&id=3142

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 from OtramsDB.php on 21-12-2021 04:15:57
 Query:SELECT name From countries WHERE id = 

/tms/print_voucher.php?reservationid=541&id=407

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 10:52:05
 Query:SELECT count(*) FROM  bookings as b WHERE  ( current_status = 'inprocess_cancel')   AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi' 

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 10:52:05
 Query:SELECT count(*) FROM  bookings as b WHERE  (current_status = 'inprocess-booking')  AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 10:52:05
 Query:SELECT count(*) FROM  bookings as b WHERE pending_cancellation = 'yes' AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 10:52:05
 Query:SELECT count(*) FROM  bookings as b WHERE pending_ammendment = '1'AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:03:52
 Query:SELECT count(*) FROM  bookings as b WHERE  ( current_status = 'inprocess_cancel')   AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi' 

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:03:52
 Query:SELECT count(*) FROM  bookings as b WHERE  (current_status = 'inprocess-booking')  AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:03:52
 Query:SELECT count(*) FROM  bookings as b WHERE pending_cancellation = 'yes' AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:03:52
 Query:SELECT count(*) FROM  bookings as b WHERE pending_ammendment = '1'AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:04:39
 Query:SELECT count(*) FROM  bookings as b WHERE  ( current_status = 'inprocess_cancel')   AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi' 

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:04:39
 Query:SELECT count(*) FROM  bookings as b WHERE  (current_status = 'inprocess-booking')  AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:04:39
 Query:SELECT count(*) FROM  bookings as b WHERE pending_cancellation = 'yes' AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:04:39
 Query:SELECT count(*) FROM  bookings as b WHERE pending_ammendment = '1'AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:10:44
 Query:SELECT count(*) FROM  bookings as b WHERE  ( current_status = 'inprocess_cancel')   AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi' 

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:10:44
 Query:SELECT count(*) FROM  bookings as b WHERE  (current_status = 'inprocess-booking')  AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:10:44
 Query:SELECT count(*) FROM  bookings as b WHERE pending_cancellation = 'yes' AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:10:44
 Query:SELECT count(*) FROM  bookings as b WHERE pending_ammendment = '1'AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:12:40
 Query:SELECT count(*) FROM  bookings as b WHERE  ( current_status = 'inprocess_cancel')   AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi' 

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:12:40
 Query:SELECT count(*) FROM  bookings as b WHERE  (current_status = 'inprocess-booking')  AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:12:40
 Query:SELECT count(*) FROM  bookings as b WHERE pending_cancellation = 'yes' AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:12:40
 Query:SELECT count(*) FROM  bookings as b WHERE pending_ammendment = '1'AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:12:52
 Query:SELECT count(*) FROM  bookings as b WHERE  ( current_status = 'inprocess_cancel')   AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi' 

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:12:52
 Query:SELECT count(*) FROM  bookings as b WHERE  (current_status = 'inprocess-booking')  AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:12:52
 Query:SELECT count(*) FROM  bookings as b WHERE pending_cancellation = 'yes' AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:12:52
 Query:SELECT count(*) FROM  bookings as b WHERE pending_ammendment = '1'AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:13:09
 Query:SELECT count(*) FROM  bookings as b WHERE  ( current_status = 'inprocess_cancel')   AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi' 

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:13:09
 Query:SELECT count(*) FROM  bookings as b WHERE  (current_status = 'inprocess-booking')  AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:13:09
 Query:SELECT count(*) FROM  bookings as b WHERE pending_cancellation = 'yes' AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:13:09
 Query:SELECT count(*) FROM  bookings as b WHERE pending_ammendment = '1'AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:23:39
 Query:SELECT count(*) FROM  bookings as b WHERE  ( current_status = 'inprocess_cancel')   AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi' 

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:23:39
 Query:SELECT count(*) FROM  bookings as b WHERE  (current_status = 'inprocess-booking')  AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:23:39
 Query:SELECT count(*) FROM  bookings as b WHERE pending_cancellation = 'yes' AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:23:39
 Query:SELECT count(*) FROM  bookings as b WHERE pending_ammendment = '1'AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:23:53
 Query:SELECT count(*) FROM  bookings as b WHERE  ( current_status = 'inprocess_cancel')   AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi' 

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:23:53
 Query:SELECT count(*) FROM  bookings as b WHERE  (current_status = 'inprocess-booking')  AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:23:53
 Query:SELECT count(*) FROM  bookings as b WHERE pending_cancellation = 'yes' AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:23:53
 Query:SELECT count(*) FROM  bookings as b WHERE pending_ammendment = '1'AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:24:17
 Query:SELECT count(*) FROM  bookings as b WHERE  ( current_status = 'inprocess_cancel')   AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi' 

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:24:17
 Query:SELECT count(*) FROM  bookings as b WHERE  (current_status = 'inprocess-booking')  AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:24:17
 Query:SELECT count(*) FROM  bookings as b WHERE pending_cancellation = 'yes' AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:24:17
 Query:SELECT count(*) FROM  bookings as b WHERE pending_ammendment = '1'AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:30:26
 Query:SELECT count(*) FROM  bookings as b WHERE  ( current_status = 'inprocess_cancel')   AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi' 

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:30:26
 Query:SELECT count(*) FROM  bookings as b WHERE  (current_status = 'inprocess-booking')  AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:30:26
 Query:SELECT count(*) FROM  bookings as b WHERE pending_cancellation = 'yes' AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:30:26
 Query:SELECT count(*) FROM  bookings as b WHERE pending_ammendment = '1'AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:30:33
 Query:SELECT count(*) FROM  bookings as b WHERE  ( current_status = 'inprocess_cancel')   AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi' 

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:30:33
 Query:SELECT count(*) FROM  bookings as b WHERE  (current_status = 'inprocess-booking')  AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:30:33
 Query:SELECT count(*) FROM  bookings as b WHERE pending_cancellation = 'yes' AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'' at line 1 from OtramsDB.php on 31-01-2022 11:30:33
 Query:SELECT count(*) FROM  bookings as b WHERE pending_ammendment = '1'AND AND b.booking_branch_id in (2,4,7) AND b.consultant_id='rinshi'

/tms/list_bookings.php?ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 06:29:28
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php?cstatus=cor

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 06:29:28
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php?cstatus=cor

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 06:32:25
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 06:32:25
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 06:33:40
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 06:33:40
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 06:55:29
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 06:55:29
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 06:55:43
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 06:55:43
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 06:55:48
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 06:55:48
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 06:55:59
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 06:55:59
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 06:56:14
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 06:56:14
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 06:56:20
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 06:56:20
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 06:57:24
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 06:57:24
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 06:58:17
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php?cstatus=cor

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 06:58:17
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php?cstatus=cor

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 06:58:27
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 06:58:27
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 08:01:36
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 08:01:36
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 08:01:50
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 08:01:50
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 08:01:55
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 08:01:55
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 08:05:12
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 08:05:12
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 08:05:20
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 08:05:20
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 08:05:24
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 08:05:24
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 08:05:38
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php?&ez_query=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 08:05:38
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php?&ez_query=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 08:05:49
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php?&ez_query=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 08:05:49
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php?&ez_query=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 08:06:06
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php?&ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 08:06:06
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php?&ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 09:23:24
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php?&ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 09:23:24
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php?&ez_queries=1

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id where 1' at line 1 from OtramsDB.php on 03-02-2022 09:26:12
 Query:SELECT count(*) as iCount FROM left join agents as a on .parent_agent_id =a.id where 1

/tms/list_bookings.php

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.su' at line 1 from OtramsDB.php on 03-02-2022 09:26:12
 Query:SELECT b.agent_rate-SUM(rb.amount_received) AS pending_amount,b.supplier_rate-SUM(IFNULL(pb.amount_received, 0)) AS pending_amount_supplier,qb.q_id AS quotation_id,qb.enquiry_id, enq.enquiry_source, b.*, if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) AS agent_name ,if(b.site_id>0,a.consultant_id,b.consultant_id) AS consultant_id,a.username,a.agency_name,a.time_zone_offset,a.parent_agent,a.accounting_id as agent_accounting_id,a.branch_id ,bri.acc_type AS supplier_invoice_status FROM left join agents as a on .parent_agent_id =a.id LEFT JOIN sub_user as su on b.sub_user_id = su.sub_user_id WHERE 1 GROUP BY b.id limit ,25

/tms/list_bookings.php

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'otrams_thefabulousgetaway_alpha.special_fields_booking' doesn't exist from OtramsDB.php on 16-08-2022 04:23:09
 Query:select b.id,b.site_id,b.customer_id,b.source_type,agent_reference(a.id,a.agent_type) as agent_code,sfb.*,if(b.sub_user_id>0,concat(su.first_name, ' ',su.middle_name, ' ',su.last_name),concat(a.first_name, ' ',a.middle_name, ' ',a.last_name)) as agent_name from bookings as b left join agents as a on if(b.site_id = 0,b.agent_id,b.wh_agent_id)=a.id   left join sub_user as su on b.sub_user_id = su.sub_user_id left join special_fields_booking as sfb on b.id = sfb.booking_id  where 1  AND sfb.booking_id IS NOT NULL  and sfb.status='A'  ORDER BY sfb.id DESC

/tms/list_bookings.php?&download_accounts_report=yes

