Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: shahiderp »Table: company_rating
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database Queried time

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Showing rows 0 - 24 (51 total, Query took 0.0010 seconds.)
SELECT * FROM `company_rating`
Full textsrating_idOrg_Nooverall_ratingpersonavail_deliverycall_responseemail_responsecall_response_afteremailpayment_termsdirect_connectionrelease_paymentcompany_documentcheque_clearanceamount_pendingdecision_person_responsecorrect_infomationusual_requirementemail_response_commentscall_response_afteremail_commentspayment_terms_commentsdirect_connection_commentsrelease_payment_commentscompany_document_commentscheque_clearance_commentsamount_pending_commentsdecision_person_response_commentscorrect_infomation_commentsusual_requirement_commentsStatusverify_statusverified_byverify_timeapprove_statusapproved_byapproved_timeCreateuserCreateTimemanagement_instructionsaccounts_ratingModifyuserModifytimenew_payment_terms
1 8609 4 Yes Good After call No Confirm Open Credit No Never Pending Papers Cleared More than 1 month No response No Others ac b cc dc ec f g h ic jc k Enable 0 0000-00-00 00:00:00 Approved 1 2019-09-12 15:07:42 1 2019-09-12 15:03:35 zeabros india 2 1 2019-09-12 15:06:37
3 5101 5 Yes Good Immediate Written Confirm CDC Yes Always Papers Provided Cleared 15 days Committed Yes Al scaffold test test test test test test test test test test test Enable 0 0000-00-00 00:00:00 Approved 2 2019-09-29 13:48:35 2 2019-09-29 13:45:03 test 5 0 0000-00-00 00:00:00 test
6 10316 0 Yes Good Disable 0 0000-00-00 00:00:00 Rejected 2 2019-10-07 22:26:37 2 2019-10-03 16:50:40 TEST 0 0 0000-00-00 00:00:00
7 12 5 Yes Good Immediate Written Confirm Open Credit Yes Sometimes Papers Provided Cleared More than 1 month Committed Yes Al scaffold very good very good open good late due to followup only done no issue due to improper followup professional accurate all scaffolding Enable 0 0000-00-00 00:00:00 Approved 2 2019-10-07 22:26:47 2 2019-10-07 22:26:06 Always give rock bottom prices good company payme... 4 0 0000-00-00 00:00:00 90 Days Open Credit
8 2693 0 Yes Good Enable 0 0000-00-00 00:00:00 Approved 2 2019-11-10 17:20:34 2 2019-10-14 17:38:16 30 days pdc is allowed, good company 0 0 0000-00-00 00:00:00 30 Days PDC upon Delivery
9 17402 0 Yes Good Enable 0 0000-00-00 00:00:00 Approved 2 2019-11-10 17:20:39 2 2019-10-16 15:07:36 60 days pdc approved 0 0 0000-00-00 00:00:00
10 6211 0 Yes Good Enable 0 0000-00-00 00:00:00 Approved 2 2019-11-10 17:20:43 2 2019-11-10 16:32:52 inform me before giving the quoation 0 0 0000-00-00 00:00:00
11 27761 0 Yes Good Enable 0 0000-00-00 00:00:00 Approved 2 2019-11-10 17:20:47 2 2019-11-10 17:19:14 we lost the order due a type ladder sample reject... 0 0 0000-00-00 00:00:00
12 9647 0 Yes Good Enable 0 0000-00-00 00:00:00 Approved 2 2019-11-13 19:35:52 2 2019-11-12 16:43:16 al bawadi sister concern company   0 0 0000-00-00 00:00:00
13 9022 0 Yes Good Enable 0 0000-00-00 00:00:00 Approved 2 2019-11-13 19:36:02 2 2019-11-12 22:34:11 steel materail from brother steel 30 days pdc pri... 0 0 0000-00-00 00:00:00
14 27255 5 Yes Good Immediate Written Confirm PDC Yes Always Papers Provided Cleared 15 days Committed Yes Al scaffold Mostly needs the confirmations over mail. Easy to Establish connection and always respond ov... Payment term is 60 DAYS PDC after delivery collect... Easily to Establish Connection over Phone and Emai... Sometimes it gets Delayed by few days As committed... All Documents are available. No issues regarding the payment. No pending payment remaining. Good Response Person is friendly But always like t... Site engineers are also responsive but stays a lit... Mostly requires Ladder, Scaffolding, And steel com... Enable 0 0000-00-00 00:00:00 0 0000-00-00 00:00:00 121 2019-11-30 13:00:21 0 0000-00-00 00:00:00
15 9326 5 Yes Good After Reminder Written Confirm PDC No Always Papers Provided Cleared 15 days Committed Yes Podium Tower They dosen't requires much email responses. Emails... Always are good in responding over calls. Prior cl... Payment never been the issue. 60 days PDC terms is... Not much requirment of getting in touch with accou... Release payment within the committed time. All documents are provided by them. Cheque cleared every time over each invoice. Never... No pending Payment. Responses in very good manner and always responds. Most of the time there driver person comes for col... Podium tower, Aluminium Towers, A type ladder  are... Enable 0 0000-00-00 00:00:00 0 0000-00-00 00:00:00 121 2019-11-30 15:52:57 0 0000-00-00 00:00:00
16 1436 4 Yes Good Immediate Written Confirm Open Credit Yes Always Papers Provided Cleared 15 days Committed Yes Al scaffold Yes they prefer mail conversation Yes they respond over mail 30 days Open credit yes i am in touch with both of them exactly on the same day of overdue yes they have provided the Papers all the cheque are Cleared No amount is pending they are committed on there words yes it is always correct Aluminium towers and steels components Enable 0 0000-00-00 00:00:00 0 0000-00-00 00:00:00 139 2019-11-30 15:54:15 0 0000-00-00 00:00:00
17 7815 5 Yes Good After call Written Confirm PDC Yes Always Papers Provided Cleared 15 days Committed Yes Al scaffold they mostly prefer on calls , but sometimes they r... yes they respond on mail also 120 days PDc upon delivery yes i am in touch with them yes at the site only yes documents are available with us . cheque are cleared no pending amount the purchaser is always good and if he said we get... yes always Al towers and warehouse Ladders Enable 0 0000-00-00 00:00:00 0 0000-00-00 00:00:00 139 2019-11-30 15:57:23 0 0000-00-00 00:00:00
18 27623 5 Yes Good After call Written Confirm PDC Yes Always Papers Provided Cleared 15 days Non Committed Yes Al scaffold They very rarely respond yes they always respond over the call unless they ... 120 days Pdc or 90 days Open Yes i am in direct connection with the purchaser . yes they release the cheque every time . yes the papers are provided No cheque is bounced no pending amount the response from decision maker is non committed ... Yes they provide accurate information for delivery... Al scaffolding and warehouse ladders ,castor wheel... Enable 0 0000-00-00 00:00:00 0 0000-00-00 00:00:00 139 2019-12-01 10:16:40 0 0000-00-00 00:00:00
19 13463 5 Yes Good Immediate Written Confirm CDC Yes Always Papers Provided Cleared 15 days Committed Yes Al scaffold Immediate response over the mail when there is any... Not frequently respond. Always Cash / CDC direct connection with Purchaser Always cleared within a time. Usually he give CDC ... All documents we have Cheque cleared always on time No pending payment Good response Always provide correct information Requirement is frequently Enable 0 0000-00-00 00:00:00 0 0000-00-00 00:00:00 116 2019-12-01 10:20:39 0 0000-00-00 00:00:00
20 28049 4 Yes Good After call No Confirm CDC Yes Always Pending Papers Cleared 15 days Non Committed Yes Al scaffold he very rarely respond over mail . he doesnt respond over mail . CDC was there for the 1st order . Yes i am In direct contact with the purchaser . yes the payment was released at the same time . I only have trade licence and vat certificates . Yes the cheque is cleared . No amount is pending . he doesnt committ anything for the orders . yes he always provide the correct information . Al scaffolding and ladders . Enable 0 0000-00-00 00:00:00 0 0000-00-00 00:00:00 139 2019-12-01 10:23:14 0 0000-00-00 00:00:00
21 4780 4 Yes Bad After call No Confirm Open Credit Yes Never Papers Provided Cleared More than 1 month Committed Yes Al scaffold sometimes. received call after so many tries. 90 days Open credit and they don't do on time yes direct connection with purchaser. They never do payment on time. yes available. till date no cheque bounced. they never do payment on time. positive reponse yes scaffolding, ladders, podium and baker tower. Enable 0 0000-00-00 00:00:00 0 0000-00-00 00:00:00 115 2019-12-01 10:25:33 0 0000-00-00 00:00:00
22 18269 3 Yes Good After call No Confirm CDC Yes Always Papers Provided Cleared 15 days Committed Yes Al scaffold No response whatsoever on mail No confirmation , he always come to factory to giv... The payment term is Cash Or CDC . The purchaser is directly in contact with me , Payment is done on the factory everytime . Only trn and vat certificates are here . Cheque is got cleared . No amount whatsoever is pending . he always give committment for the orders in facto... Information provided are true and geneuine , Al scaffolding once in a month or two  . Enable 0 0000-00-00 00:00:00 0 0000-00-00 00:00:00 139 2019-12-01 10:27:17 0 0000-00-00 00:00:00
23 11570 3 Yes Good After call Written Confirm PDC Yes Always Papers Provided Cleared 15 days Non Committed Yes Al scaffold They respond over mail only after many times he di... Yes he always gives written confirmation ,. 30 days PDC upon delivery Yes both of them are in direct touch with me ,. They always release the payment on time . The papers are there with me ,. The cheque is cleared everytime ,. No pending amount . The response is non committed . He always comes to colect the material from factor... Al scaffolding and ladders and sometimes wodden pl... Enable 0 0000-00-00 00:00:00 0 0000-00-00 00:00:00 139 2019-12-01 10:30:38 0 0000-00-00 00:00:00
24 22336 4 Yes Good After call Written Confirm CDC Yes Always Papers Provided Cleared 15 days Committed Yes Al scaffold He never respond over mail , only we deal on whats... he gives written confirmation for the orders payment term is cash . Yes i am in touch with them . he gives payment at the times of delivery . Only trade and vat is there with me . the cheque is cleared . No amount is pending from his side . he ask if we can provide that price , if we give h... Yes correct information is there all time.   Only aluminium towers and ladders he requires . Enable 0 0000-00-00 00:00:00 0 0000-00-00 00:00:00 139 2019-12-01 10:34:44 0 0000-00-00 00:00:00
25 14966 0 Yes Good After call No Confirm CDC Yes Always Papers Provided Cleared 15 days Committed Yes Ladders never receive email from his end.
only calls befo...
He confirms everything over calls. Cash upon material collection Very good client of mine.
very good rapport.
Always clears payment on spot Have his details Cash No delay Committs things Provides the reuired information Ladders only. Enable 0 0000-00-00 00:00:00 0 0000-00-00 00:00:00 153 2019-12-01 10:35:27 0 0000-00-00 00:00:00
26 27481 5 Yes Good After Reminder Written Confirm CDC Yes Always Papers Provided Cleared 15 days Committed Yes Al scaffold Give respond over the emails after sending the rem... Good response over the call. Always give CDC cheque Good connection with them Sometimes they got late in releasing the payment Having all documents Always little amount is pending bit it will clear after s... Good response Always provide correct and accurate information Mostly he is taking the material on rental basis. Enable 0 0000-00-00 00:00:00 0 0000-00-00 00:00:00 116 2019-12-01 10:35:54 0 0000-00-00 00:00:00
27 27727 4 Yes Good Immediate No Confirm CDC Yes Always Papers Provided Cleared 15 days Committed Yes Al scaffold He respond over mail quite fast There is no confirmation over the mail . For this 3 orders they ahve given bank transfer , ... Yes i am in direct touch The payment is released on time everytime . TRade licence and vat is there with me . All cheques are cleared no amount is pending he is always committed to his words . the delivery informations are correct al scaffolding , steel componenst , ladders Enable 0 0000-00-00 00:00:00 0 0000-00-00 00:00:00 139 2019-12-01 10:38:07 0 0000-00-00 00:00:00
28 842 3 Yes Good After call Written Confirm CDC Yes Sometimes Papers Provided Cleared 30 days Committed Yes Al scaffold The response over mail is good . Yes they give written confirmation  over mail . we get the cdc cheque after 1 week for sale and fo... Yes i am in direct touch with them ,. sometime it gets delayed . Trade and vat are with me . All the cheque gets cleared Amount is pending from 30 days , but we will get t... They arte committed to there words ,. Yes they provide teh correct informations . Only aluminium towers Enable 0 0000-00-00 00:00:00 0 0000-00-00 00:00:00 139 2019-12-01 10:41:32 0 0000-00-00 00:00:00